VB.NET 2005 - Datagridview - Update cell value with code

[dbelley_office]

Hi,

I have a Datagridview with containing 9 columns.

Column #2 is hidden and remains blank until the user presses a given button on my WinForm. At that moment, I have to go put a value in column #2 for all the rows of my datagridview and save.

Dataset (dtsData) is the datasource of the datagridview (grdInfo)

Here is what I tried:

For i = 0 To grdInfo.Rows.Count - 1
   grdInfo.Rows(i).Cells("idDossierDisciplinaireEntete").Value = 6       '(6 is just a sample value for the use of my question)
Next

If dtsData.HasChanges Then
   intRet = sqlAdaptor.Update(dtsData)
End If

The "sqlAdaptor.Update(dtsData) doesn't work because the grid cell I just updated doesn't seem to retain the new value. And in my UpdateCommand that column is a mandatory field in my database table. The update tells my I can't insert NULL which is true, but the value should be 6, not NULL.

After the Cells("idDossierDisciplinaireEntete") affectation I tried this:

grdInfo.UpdateCellValue(grdInfo.Rows(i).Cells("idDossierDisciplinaireEntete").ColumnIndex, i)

It didn't help
I tried this:

grdInfo.RefreshEdit()

It didn't help either.

Anyone can help me.
Thank you

[dbelley_office]

I use this code instead. Seems to work ..

                            For i = 0 To dtsData.Tables(0).Rows.Count - 1
                                dtsData.Tables(0).Rows(i).BeginEdit()
                                dtsData.Tables(0).Rows(i).Item("idDossierDisciplinaireEntete") = 6
                                dtsData.Tables(0).Rows(i).EndEdit()
                            Next

                        If dtsData.HasChanges Then
                            intRet = sqlAdaptor.Update(dtsData)
                        End If