Hi Tony,

There is nothing here that explains why your updates don't work.  Need more code for that.  What is the UpdateCommand string at the time of the update?

You could also try to adapt the code below, which should update the table (although that particular AdventureWorks table has some triggers updating the date field behind the scenes that may cause concurrency problems on the second update)

        SqlDataAdapter da = new SqlDataAdapter();
        DataSet ds = new DataSet();
        private void test1ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI;"))
            {
                using (SqlCommand com = new SqlCommand("SELECT * FROM Production.Culture", conn))
                {
                    using (da = new SqlDataAdapter(com))
                    {
                        da.Fill(ds);
                        dataGridView1.DataSource = ds;
                        dataGridView1.DataMember = "Table";
                    }
                }
            }
        }

        private void test2ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI;"))
            {
                using (SqlCommand com = new SqlCommand("SELECT * FROM Production.Culture", conn))
                {
                    using (da = new SqlDataAdapter(com))
                    {
                        using (SqlCommandBuilder b = new SqlCommandBuilder(da))
                        {
                            da.Update(ds);
                        }
                    }
                }
            }
        }