Apply Changes to the Database

[Rasha]

Hey guys,
Could you please help me with this example 
http://www.telerik.com/help/aspnet-ajax/listview-manual-editing.html

how can I update the database using the data table in the example, please reply...
Thanks, 
Rasha

[Princy]

Hi Rasha,

Try the following.
C#:

      SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString());
     string name=changedRows[0][columnname].ToString();
     con.Open();
     string updateQuery="update tblename set name='"+name+"' where ProductID=changedRows[0][ProductID].Tostring()";//to update;
      SqlCommand cmd = new SqlCommand(updateQuery, con);
      cmd.ExecuteNonQuery();
      con.Close();

Thanks,
Princy.