 <p>In order to Updateupdate the data on the database your SqlDataAdapter need to have its InsertCommand, UpdateCommand, DeleteCommand properties set.</p> <p>So, try the below code:</p> <pre><code> ds.Tables[0].Rows.Add(newRow); SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adp); adp.DeleteCommand = commandBuilder.GetDeleteCommand(true); adp.UpdateCommand = commandBuilder.GetUpdateCommand(true); adp.InsertCommand = commandBuilder.GetInsertCommand(true); adp.Update(ds.Tables[0]); //connection.UpdateDatabase(ds); connection.Close(); </code></pre> <p>Edit: The Update method takes the name of a DataSet and a table. The DataSet for us is ds, which is the one we passed in to our UpdateDatabase method when we set it up. After a dot, you type the name of a table in your dataset.</p>