DataSet更新问题

Question

 private void button5_Click(object sender, EventArgs e)
        {
            DataSet dataset=new DataSet();
            String connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from T_Persons"; 
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dataset);
                    DataTable table = dataset.Tables[0];
                    DataRow row = table.Rows[0];
                    row["Name"] = "jason";                    SqlCommandBuilder builder = new SqlCommandBuilder(adapter);                    adapter.Update(dataset);
                    
                }
            }
            
        }运行时报错 对于不返回任何键列信息的的SelectCommand,不支持UpdateCommand的动态SQL生成，这是我跟着视频教程敲的代码 为什么视频上能正常运行，我这里就报错了呢

Answer 1

SqlCommandBuilder builder = new SqlCommandBuilder(adapter);使用CommandBuilder，必须在select的语句里包括主键或者唯一列。参考链接如下：
http://msdn.microsoft.com/zh-cn/library/tf579hcz.aspx