save changes to checkbox to database

[David Gammon]

I have a sfdatagrid with a gridcheckboxcolumn.  I need to update the database field bound to the checkbox when the checkbox becomes checked or unchecked.  I have tried the gridcheckbox and a checkbox imbedded in a datatemplate, but cannot get the database to be updated.

[Jai Ganesh S]

Hi David, 

 

You can get the underlying record values and update it to database fields while we check/uncheck the GridCheckBoxColumn by wiring the CurrentCellValueChanged event.  

 

this.sfGrid.CurrentCellValueChanged += sfGrid_CurrentCellValueChanged; 

 

void sfGrid_CurrentCellValueChanged(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellValueChangedEventArgs args) 

{ 

    int columnIndex = this.sfGrid.ResolveToGridVisibleColumnIndex(args.RowColumnIndex.ColumnIndex); 

 

    if (this.sfGrid.Columns[columnIndex].CellType == "CheckBox") 

    { 

        var record = args.Record; 

    } 

} 

 

Sample: 

CheckBoxColumDemo 

 

Regards, 

Jai Ganesh S 

[David Gammon]

Can you show an example using visual basic?

[Gnanasownthari Thirugnanam]

Hi David, 

 

We have prepared the sample for your requirement in VB as per your update, you can download the sample from below mentioned location. 

 

VB 

AddHandler Me.sfGrid.CurrentCellValueChanged, AddressOf sfGrid_CurrentCellValueChanged 

Private Sub sfGrid_CurrentCellValueChanged(ByVal sender As Object, ByVal args As Syncfusion.UI.Xaml.Grid.CurrentCellValueChangedEventArgs) 

       Dim columnIndex As Integer = Me.sfGrid.ResolveToGridVisibleColumnIndex(args.RowColumnIndex.ColumnIndex) 

 

       If Me.sfGrid.Columns(columnIndex).CellType Is "CheckBox" Then 

              Dim record = args.Record 

       End If 

End Sub 

 

Sample location: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/VB_sample-1577235150.zip 

 

Regards, 

Gnanasownthari T.