How to add a new row to a datagridview without deleting info from the previous rows

Question

0.00/5 (No votes)

See more:

Hi, I had a tough time finding a solution to the above problem. I hope to find a solution here.
I have a datagridview with first three columns as text box and rest two columns as combobox columns.When I add a new row to this datagridview at runtime the values in the previous textbox rows disappear whereas the comboboxes remain as it is in the previous rows.
Please advise on how to retain the values of the previous textbox columns. I've constructed this multicolumn datagridview without binding it to a dataset or a datable.Instead I have constructed the datagridview cell by cell and datagridview columns. A possible solution would be highly appreciated. I will provide any other information from my side if required.

What I have tried:

Searched the entire internet.I 've searched the books but no help.

Posted 27-Aug-18 10:27am

Arvind61

Add a Solution

Comments

Matias Lopez 27-Aug-18 16:45pm

If you re-write all the row, the last row disappeared? Tell us more about this error! The definition of the DataGridView, for example.

Arvind61 27-Aug-18 16:56pm

I've made a function that adds a new row when called.So whenever I call this function called AddNewRow(), It adds one row.The row doesn't disappear, only the entries in the textboxes (and not the combos) in the 'Previous' rows disappear(not the current row). Combos remain same.

Matias Lopez 28-Aug-18 9:22am

"I've made a function that adds a new row when called."
Where did you call this function (Button, a Windows Form Handle Function, Delegate)? Have you got a cleanning function, (and at the call, maybe clean texBox's)?
If you show the code we could help you better!

Arvind61 27-Aug-18 17:00pm

if you want more info please let me know.

Richard MacCutchan 28-Aug-18 5:31am

You need to show the code that does the insert. We cannot guess how those text boxes are being cleared.

Arvind61 28-Aug-18 9:24am

Please find the code below.
Private Sub showNormalRow(ByVal classRowId As Integer, ByVal sectionRowId As Integer)
Static intRowNo As Integer = 0
dsCombined.Tables(0).Rows.Add(dsDataDsCombined.Tables(0).Rows(0).Item(0), _
dsDataDsCombined.Tables(0).Rows(0).Item(1), strClassTeacherSelected)
If intRowNo > 0 Then
dgvRecords.Rows.Add()
End If
'Dim colClassName As New DataGridViewTextBoxColumn
colClassName.Name = "Class_Name"
colClassName.HeaderText = "Class Name"
colClassName.ReadOnly = True
colClassName.SortMode = DataGridViewColumnSortMode.NotSortable
Dim colClassNameCell As New DataGridViewTextBoxCell
colClassNameCell.Value = dsCombined.Tables(0).Rows(0)(0)
colClassName.CellTemplate = colClassNameCell
Static booFirstTimeClass As Boolean = True
If booFirstTimeClass Then
dgvRecords.Columns.Add(colClassName)
booFirstTimeClass = False
End If
dgvRecords(0, intRowNo).Value = dsCombined.Tables(0).Rows(intRowNo)(0)
'Dim colSectionName As New DataGridViewTextBoxColumn
colSectionName.Name = "Section_Name"
colSectionName.HeaderText = "Section Name"
colSectionName.ReadOnly = True
colSectionName.SortMode = DataGridViewColumnSortMode.NotSortable
Static booFirstTimeSection As Boolean = True
If booFirstTimeSection Then
dgvRecords.Columns.Add(colSectionName)
booFirstTimeSection = False
End If
dgvRecords(1, intRowNo).Value = dsCombined.Tables(0).Rows(intRowNo)(1)
'Dim colcmbClassTeacher As New DataGridViewTextBoxColumn
colcmbClassTeacher.HeaderText = "Class Teacher"
colcmbClassTeacher.ReadOnly = True
colcmbClassTeacher.SortMode = DataGridViewColumnSortMode.NotSortable
Static booFirstTimeClassTeacher As Boolean = True
If booFirstTimeClassTeacher Then
dgvRecords.Columns.Add(colcmbClassTeacher)
booFirstTimeClassTeacher = False
End If
dgvRecords(2, intRowNo).Value = dsCombined.Tables(0).Rows(0)(2)
Dim objclsConnection As clsConnection
Dim strSql As String
Dim intNoOfOtionalSubjs As Integer
Static dsComboBoxSubject As DataSet
Static dsComboBoxSubjectForOptionalSubjts As DataSet
Static booEnteredFirstTime As Boolean = True
If booEnteredFirstTime Then
dsComboBoxSubjectForOptionalSubjts = New DataSet()
dsComboBoxSubjectForOptionalSubjts.Clear()
strSql = generateSqlForOptionalSubjsForThisClassSec(classRowId, sectionRowId)
objclsConnection = New clsConnection(strSql, "select", "Tbl_Eliminated_Subj")
dsComboBoxSubjectForOptionalSubjts = objclsConnection.readyDataSet()
intNoOfOtionalSubjs = dsComboBoxSubjectForOptionalSubjts.Tables(0).Rows.Count
dsComboBoxSubject = New DataSet()
dsComboBoxSubject.Clear()
strSql = "select SubjectID, Subject_Name from Tbl_Subject order by SubjectID"
objclsConnection = New clsConnection(strSql, "select", "Tbl_Subject")
dsComboBoxSubject = objclsConnection.readyDataSet()
booEnteredFirstTime = False
End If
intNoOfOtionalSubjs -= 1
'Dim colcmbSubject As New DataGridViewComboBoxColumn
colcmbSubject.Name = "Subject_Name"
colcmbSubject.HeaderText = "Subject"
colcmbSubject.SortMode = DataGridViewColumnSortMode.NotSortable
Dim colcmbSubjectCell As New DataGridViewComboBoxCell
If intNoOfOtionalSubjs >= 0 Then
colcmbSubjectCell.DataSource = dsComboBoxSubjectForOptionalSubjts.Tables(0)
Else
colcmbSubjectCell.DataSource = dsComboBoxSubject.Tables(0)
End If
colcmbSubjectCell.ValueMember = "SubjectID"
colcmbSubjectCell.DisplayMember = "Subject_Name"
colcmbSubject.CellTem

Richard Deeming 28-Aug-18 12:12pm

Don't try to post the code in a comment - click the green "Improve question" link, and add the code to the question.

Make sure you format it as a code block, using the "code" button in the toolbar, or the option in the message that pops up when you paste it.

If you don't get the pop-up message, and you can't see the button on the toolbar, you'll need to type <pre> before the code block, and </pre> after it.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)