Update database with changes made to DataTable... confusion

c#, dataadapter, datatable

Solution

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);

Problem

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(?).

Original source