Edit Data In DataSet then transfer to SQL Server

Question

Dear all, Please tell me about code for edit data in DataSet and then transfer to Table in Sql Server. thank in advance. best regards, Mala

Manath Pathana · Answer

cannot open this link. it show content not found

Nattudurai Eswaramurthy · Answer

DataSet custDS = new DataSet(); SqlConnection nwindConn = new SqlConnection("Data Source=localhost;User ID=sa;Initial Catalog=northwind"); SqlCommand selectCMD = new SqlCommand("SELECT * FROM Customers", nwindConn); selectCMD.CommandTimeout = 30; SqlDataAdapter custDA = new SqlDataAdapter(); custDA.SelectCommand = selectCMD; try { nwindConn.Open(); custDA.Fill(custDS, "Customers"); DataRow[] tempDR = custDS.Tables[0].Select("ContactName = 'Maria Anders'"); tempDR[0].ItemArray[2] = "Somebody Else"; custDS.Tables[0].AcceptChanges(); custDA.Update(custDS,"Customers"); nwindConn.Close(); } catch(Exception e) { Console.WriteLine(e.Message); }

Satyapriya Nayak · Answer

Hi Manath, Please refer the below links http://msdn.microsoft.com/en-us/library/ms233701%28v=vs.80%29.aspx http://www.dotnetfunda.com/articles/article131.aspx Thanks

brunda k · Answer

Edit data in dataset http://msdn.microsoft.com/en-US/library/tat996zc(v=vs.80 )

Edit Data In DataSet then transfer to SQL Server

Answers (4)