I want to insert data into new rows and edit existing rows of data grid in db table.I have set in datagrid CanUserAddRows="True" in xaml .Here is my sqlite code for connecting with datagrid:
SQLiteCommand comm = new SQLiteCommand("update Security_details set id=@id,Code=@Code,Description=@Description,Rate=@Rate,Qty=@Qty,Amount=@Amount,Remarks=@Remarks where id=@id", sqlitecon);
comm.ExecuteNonQuery();
Tell me the set of commands for above query for inserting and updating data into data grid rows ?
I am first time coding in wpf using data grid .I search it on google the material i found is using entity frame work for this operation on datagrid..please help