Changes in Grid doesn''t reflect into my MySql Database

[Santosh]

When i add/edit/delete rows in the datagrid, it doesn't get updated/deleted in mysql database. I tried different ways but couldnt figure it out. Does any one know the reason behind it??

[Rajarajeswari S]

Hi Santosh,

Thanks for using Syncfusion products.

When the user makes changes in the grid, like editing a row, deleting a row or adding a new row, these changes are immediately saved in the bound data set. Please refer the below code snippet which illustrates this:

this.oleDbDataAdapter1.Update(this.dataSetCustomers1);

Please have a look at the KB article from the below link where you can get more details regarding this:

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=312

Please let me know if this helps you.

Regards,
Raji

[Santosh]

Can I get the sample project....instead of code snippets...so that it will be more clear..

>
Hi Santosh,

Thanks for using Syncfusion products.

When the user makes changes in the grid, like editing a row, deleting a row or adding a new row, these changes are immediately saved in the bound data set. Please refer the below code snippet which illustrates this:

this.oleDbDataAdapter1.Update(this.dataSetCustomers1);

Please have a look at the KB article from the below link where you can get more details regarding this:

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=312

Please let me know if this helps you.

Regards,
Raji

[Rajarajeswari S]

Hi Santosh,

Please refer the below link where you can find the sample for updating the data source:

http://websamples.syncfusion.com/samples/Grid.Web/5.2.0.25/F69852/main.htm

Please let me know if this helps you out.

Regards,
Raji

[Santosh]

When i try to download the zip file...it says page not displayed. I guess the link is broken

>
Hi Santosh,

Please refer the below link where you can find the sample for updating the data source:

http://websamples.syncfusion.com/samples/Grid.Web/5.2.0.25/F69852/main.htm

Please let me know if this helps you out.

Regards,
Raji

[Rajarajeswari S]

Hi Santosh,

Please try the below link where you can get the same sample. Could you please check the previous link once again, because here I can open the link without any problem.

http://www.syncfusion.com/support/user/uploads/GGC_Update_821913a2.zip

Regards,
Raji