|
//Update db for Deletion.
void gridGroupingControl1_SourceListRecordChanging(object sender, Syncfusion.Grouping.RecordChangedEventArgs e)
{
if (e.Action == Syncfusion.Grouping.RecordChangedType.Removed)
{
String value = e.Record.GetValue("id").ToString();
string txtSQLQuery = "delete from mains where id =" + value;
ExecuteQuery(txtSQLQuery);
}
}
//Update db for addition.
void gridGroupingControl1_SourceListRecordChanged(object sender, Syncfusion.Grouping.RecordChangedEventArgs e)
{
if (e.Action == Syncfusion.Grouping.RecordChangedType.Added)
{
String column1Value = e.Record.GetValue("id").ToString();
string column2Value = e.Record.GetValue("desc").ToString();
string txtSQLQuery = "insert into mains ([id],[desc]) values ('" + column1Value + "','"+ column2Value + "')";
ExecuteQuery(txtSQLQuery);
}
}
//Update the db when modify the cell value.
void Table_RecordValueChanged(object sender, Syncfusion.Grouping.RecordValueChangedEventArgs e)
{
if (e.Record.Kind == Syncfusion.Grouping.DisplayElementKind.AddNewRecord)
return;
String columnName = e.Column;
Object val = e.Record.GetValue(columnName);
object unique = e.Record.GetValue("id");
if (val == null || unique == null)
return;
string value = val.ToString();
int topRowIndex = this.gridGroupingControl1.Table.Records[0].GetRowIndex();
int i = e.Record.GetRowIndex() - topRowIndex;
string txtSQLQuery = "update mains set " + columnName + " =\"" + value + "\" where id =" + unique.ToString();
ExecuteQuery(txtSQLQuery);
}
private void ExecuteQuery(string txtQuery)
{
SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
sql_cmd.ExecuteNonQuery();
sql_con.Close();
}
| 
