title: How to add a new row to an existing table using c# sql server
body: <p>I need to write a program. A part of the program is to write to an sql database (.mdf).
  I had a lot of trouble trying to add a new row to my table (called: "Data"). Here is the code:</p>
  
  <pre><code>...
  DataSet ds = new DataSet();
  System.Data.SqlClient.SqlDataAdapter da;
  DataRow dRow;
  string sql = "SELECT * From Data";
  da = new System.Data.SqlClient.SqlDataAdapter(sql, con);
  ...
  System.Data.SqlClient.SqlCommandBuilder cb;
  cb = new System.Data.SqlClient.SqlCommandBuilder(da);
  dRow = ds.Tables["Data"].NewRow();
  dRow[0] = "my_data1";
  dRow[1] = "my_data2";
  dRow[2] = "my_data3";
  ...
  ds.Tables["Data"].Rows.Add(dRow);
  da.Update(ds, "Data");
  ...
  </code></pre>
  
  <p>I execute this code, but the data didn't get saved to the table. Does anyone know how to enter a new row to the table and to save it?</p>