Hiw do i Update the dataset records to database
-
Hi all, Plese some body help me out its very urgent,i am trying to update the dataset records into database but its not workinh fine ... The code i have tried as follows for your reference Da=new SqlDataAdapter("SELECT * FROM MailsInQueueTest",sqlcon); SqlCommandBuilder builder = new SqlCommandBuilder(Da); Da.FillSchema(MailDataset,SchemaType.Mapped,"t1"); Da.Fill(MailDataset,"t1"); foreach(DataRow dr in MailDataset.Tables[0].Rows) { if((Convert.ToInt16(dr[0]))==1) { dr.Delete(); //dr[3]=1; } } MailDataset.AcceptChanges(); builder.GetDeleteCommand(); Da.Update(MailDataset,"t1"); Thanks in Advance Chandra Gupta
-
Hi all, Plese some body help me out its very urgent,i am trying to update the dataset records into database but its not workinh fine ... The code i have tried as follows for your reference Da=new SqlDataAdapter("SELECT * FROM MailsInQueueTest",sqlcon); SqlCommandBuilder builder = new SqlCommandBuilder(Da); Da.FillSchema(MailDataset,SchemaType.Mapped,"t1"); Da.Fill(MailDataset,"t1"); foreach(DataRow dr in MailDataset.Tables[0].Rows) { if((Convert.ToInt16(dr[0]))==1) { dr.Delete(); //dr[3]=1; } } MailDataset.AcceptChanges(); builder.GetDeleteCommand(); Da.Update(MailDataset,"t1"); Thanks in Advance Chandra Gupta
-
on completion of any change you could try something like the following: DataSet = changedData = MailDataset.GetChanges(); if(changedData != null) { SqlDataAdapter.Update(changedData); } else { MessageBox.Show(" Error ...", "Error"); }
dotman1
-
Hi all, Plese some body help me out its very urgent,i am trying to update the dataset records into database but its not workinh fine ... The code i have tried as follows for your reference Da=new SqlDataAdapter("SELECT * FROM MailsInQueueTest",sqlcon); SqlCommandBuilder builder = new SqlCommandBuilder(Da); Da.FillSchema(MailDataset,SchemaType.Mapped,"t1"); Da.Fill(MailDataset,"t1"); foreach(DataRow dr in MailDataset.Tables[0].Rows) { if((Convert.ToInt16(dr[0]))==1) { dr.Delete(); //dr[3]=1; } } MailDataset.AcceptChanges(); builder.GetDeleteCommand(); Da.Update(MailDataset,"t1"); Thanks in Advance Chandra Gupta
public string TabloOlarakGuncelle(DataTable tablom) { using (SqlConnection connection = new SqlConnection("path")) { try { SqlCommand cmd = (SqlCommand)connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Products"; SqlDataAdapter da = new SqlDataAdapter(cmd); SqlCommandBuilder bldr = new SqlCommandBuilder(da); //da.Fill(Dset, "Products"); da.Update(tablom); return "
Successfully: Güncelle işlemi tamamlanmıştır"; } catch (Exception exp) { return "Error: Hata:aşağıdaki mesajı sistem yöneticisine bildiriniz
\n" + exp.Message.ToString(); } } } www.serkannet.com