Update bound datagrid

  • Thread starter Thread starter Jorge
  • Start date Start date
J

Jorge

Hi

I have a bound datagrid to a dataset. I want to update
the underlaying sql table when the user finishes editing
the value.
I want to build a custom update sql statement using the
headerText and the Item values of the currentcell.
I've check the DataGrid1_CurrentCellChange but it doesn't
work the way i want its raised when i click on a cell. Is
there a sort of 'LostFocus' for datagrid cells so that i
can update the field immediately.

Kind Regards
Jorge
 
Hi Jorge,

Can you try if this fits your problem?

It shows only the first column

Cor

\\\
Private WithEvents dtbCol1 As DataGridTextBox
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Database.GetDataset(ds)
Dim ts As New DataGridTableStyle
ts.MappingName = ds.Tables(0).TableName
Dim column As New DataGridTextBoxColumn
ts.GridColumnStyles.Add(column)
DataGrid1.TableStyles.Add(ts)
column = CType(ts.GridColumnStyles(0), DataGridTextBoxColumn)
dtbCol1 = DirectCast(column.TextBox, DataGridTextBox)
column.MappingName = ds.Tables(0).Columns(0).ColumnName
column.HeaderText = "Col1"
column.Width = 30
dv = New DataView(ds.Tables(0))
DataGrid1.DataSource = dv
End Sub
Private Sub dtbCol1_LostFocus(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles dtbCol1.LostFocus
Dim I As String = "lostfocus"
End Sub
///
 
Back
Top