使用Update（）修改数据库中的值但是执行后数据库中数据没有更新

Question

private void btnUpdata_Click(object sender, EventArgs e)
        {
           DataSet dataSet = new DataSet();
         string connec = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;
            using (SqlConnection connection = new SqlConnection(connec))
            {
                connection.Open();
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "Select * from T_Users";
                    SqlDataAdapter adapter = new SqlDataAdapter(command);
                    adapter.Fill(dataSet);
                    DataTable table = dataSet.Tables[0];
                    DataRow row = table.Rows[0];
                    row["UserName"] = "admin"; 数据库中UserName的值是"uddplmqj" 这里在dataset中进行修改值
                    if (dataSet.HasChanges())
                    {
                        SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
                        dataSet.AcceptChanges();
                        adapter.Update(dataSet);//执行完修改后UserName值仍没有变真是郁闷请指点
                    }
                }
            } 
        }

Answer 1

 table.AcceptChanges();
  adapter.Update(table);

Answer 2

我按一楼说的将dataSet修改成table后还是不行,不过还是要感谢一楼，还有哪位大侠能看看帮帮忙

Answer 3

1  adapter.Fill(dataSet)   改成 adapter.Fill(dataSet,表名)
2  dataSet.AcceptChanges();这一行可以去掉
3  adapter.Update(dataSet);改成 adapter.Update(dataSet,表名);试试