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:
Code:
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:
Code:
grdInfo.UpdateCellValue(grdInfo.Rows(i).Cells("idDossierDisciplinaireEntete").ColumnIndex, i)
It didn't help
I tried this:
Code:
grdInfo.RefreshEdit()
It didn't help either.

Anyone can help me.
Thank you