Saving data to database

[madhu]

Hi,

     I have created a datagrid in which I can add new rows and edit them. However I am not getting any useful link regarding saving the data to a SQLite database. Kindly help

[Jai Ganesh S]

Hi Madhu,

 

Thank you for using Syncfusion products.

 

We have analyzed your query. You can save the datas in SfDataGrid to the database by using SfDataGrid’s “RowValidated event”.

 

Please let us know if you need further assistance.

 

Thank you,

Jai Ganesh S

[red]

Can you give us an example  by using "RowValidated event " with sqlserver database and uwp app  please

[Deivaselvan Y]

Hi Red,

Thank you for contacting Syncfusion support.

We have prepared sample using SQLite DB. We have maintained the database locally to save the insert, update and retrieve the data from the database. For inserting new record by handling RowValidating event and also updating edited data by handling RowValidated event as like below code snippet 

 

// for inserting new record in SQLite DB  

this.datagrid.RowValidating += Datagrid_RowValidating;  

  

private void Datagrid_RowValidating(object sender, Syncfusion.UI.Xaml.Grid.RowValidatingEventArgs e)  

{      

    try  

    {  

        if (database.conn == null)  

            return;  

        var data = (e.RowData as OrderItem);  

        var id = data.ID;  

        var name = data.Name;  

        var query = "INSERT INTO OrderItem (ID,Name) VALUES ('" + data.ID + "','" + data.Name + "')";  

        database.conn.Query<OrderItem>(query);  

  

    }  

    catch { }  

}  

  

//for updating edited record in SQLite DB  

this.datagrid.RowValidated += Datagrid_RowValidated;  

  

private void Datagrid_RowValidated(object sender, Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs e)  

{      

    try  

    {  

        if (database.conn == null)  

            return;  

        var data = (e.RowData as OrderItem);  

  

        var query1 = "UPDATE OrderItem SET Name='" + data.Name + "' WHERE ID='" + data.ID + "'";  

        database.conn.Query<OrderItem>(query1);  

    }  

    catch { }  

}  

 

 

Sample Link :  

http://www.syncfusion.com/downloads/support/forum/115941/ze/App223508857832075699780  

 

Please let us know if you need any further assistance. 

 

Regards,
Deivaselvan 

[red]

Thank you very much for your help ,you give me an example with Sqllite that's fine too .

In general , I appreciate your quick response.

This is my first time using your product , You are doing excellent job .

Thanks Deivaselvan Y

  

[Deivaselvan Y]

Hi Red,

Thanks for your feedback. We are happy to assist you as always. Please let us know if you required any further assistance.

Regards,
Deivaselvan