Update database with changes made to DataTable... confusion

c# datatable dataadapter
Jimmy D picture Jimmy D · Mar 7, 2013 · Viewed 31.2k times · Source

If I fill a DataTable with DataAdapter.Fill(DataTable); and then make changes to a row in the DataTable with something simple like this: DataTable.Rows[0]["Name"] = "New Name"; how can I easily save those changes back to the database? I assumed I could call DataAdapter.Update(DataTable); but I read that only works with a TableAdapter(?).

Answer

Jimmy D picture Jimmy D · Mar 8, 2013

Here is an actual helpful answer in case anyone else needs to know how to do this:

string selectStatement = "SELECT * FROM Contact";
System.Data.DataTable dt = new System.Data.DataTable();
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
conn.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter();
sqlDa.SelectCommand = new SqlCommand(selectStatement, conn);
SqlCommandBuilder cb = new SqlCommandBuilder(sqlDa);
sqlDa.Fill(dt);
dt.Rows[0]["Name"] = "Some new data here";
sqlDa.UpdateCommand = cb.GetUpdateCommand();
sqlDa.Update(dt);

Related questions

Using OleDbDataAdapter to update a DataTable C#

I have been trying to use OleDbDataAdapter to update a DataTable but got confused about the commands. Since I sometimes get info from diffrent tables I can't use a CommandBuilder. So I have tried to create the commands on my …

Read More
Why it doesn't save changes into datatable from datagridview?

I have binded datagridview with datatable (Growns). My main goal is, that user can work with datagridview (dataGridView1), filling and updating data and when button SAVE is clicked, all data would be saved into datatable, because I need it for …

Read More
using DataAdapter to populate table

I have a disconnected dataTable that contains a few records. I am using the following function to get the dataTable. static System.Data.DataTable ReadSetUpTable(string queryStr,SqlConnection sc) { try { var command = new SqlCommand() {Connection = sc, CommandText = queryStr}; var dataAdapter = …

Read More