Sample code here....
SqlConnection connection = new SqlConnection(@"connection
String");
SqlDataAdapter dataAdpater = new SqlDataAdapter("Query",
connection);
DataSet dataset = new DataSet();
dataAdpater.Fill(dataset);
DataRow row = dataset.Tables["Table"].Rows[0];
row["Column"] = "new data";
dataAdpater.UpdateCommand.CommandType =
CommandType.StoredProcedure;
dataAdpater.UpdateCommand.CommandText = "StoredProcedure
name";
dataAdpater.Update();
Hope this is useful....
Thanks
-Srinivas,
chandu wrote:
Hi Guys,
i am beginer in the worls of Asp.net and C#.net
I have one problem that
I have stored my changes of data into dataset using
disconnected dataset and after completion of all changes i want to
update that change to the database using stored procedure.
But i am not getting How to do it,
So if anybody know the slution then please give me
Regards
Chandra Tiwari