Update the dataset into database table
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all , I need to update the changes made on the dataset to database ,i wrote the following code but its getting updated to database ,please help me somebody The code like this Da=new SqlDataAdapter("SELECT * FROM MailsInQueueTest",sqlcon); SqlCommandBuilder builder = new SqlCommandBuilder(Da); sqlcon.Open(); Da.Fill(MailDataset); foreach(DataRow dr in MailDataset.Tables[0].Rows) { if((Convert.ToInt16(dr[0]))==1) { dr.Delete(); } } MailDataset.AcceptChanges(); builder.GetUpdateCommand ();//.GetDeleteCommand(); Da.Update(MailDataset); Thanks In Advance Chandra Gupta