将DataTable(包括DataSet中的表)中的表的更新写入数据库

//直接在代码中写sql语句

private void fill(int id, string comArea)
{
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
        SqlDataAdapter sda = new SqlDataAdapter("select * from CommerceArea", con);
        SqlCommandBuilder scb = new SqlCommandBuilder(sda);//可自动生成更新，插入，删除sql语句
        DataSet ds = new DataSet();
        try
        {
            sda.Fill(ds, "temp");
            ds.Tables["temp"].DefaultView.Sort = "id";
            int index = ds.Tables["temp"].DefaultView.Find(id);//获取表的索引
            ds.Tables["temp"].Rows[index]["comArea"] = comArea;
            int rows = sda.Update(ds, "temp");//只有加上了这句，才会更新数据库中的数据，否则只是更新内存中的表(即DataSet中的表)
            Response.Write("更新了" + rows + "行数据");
        }
        catch (Exception e)
        {
            Response.Write(e.Message);
        }
}

//使用存储过程

        com=new SqlCommand("StuInfoPro",con);//StuInfoPro为存储过程名称
        com.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = com;

        SqlCommandBuilder scb = new SqlCommandBuilder(sda);
        DataSet ds = new DataSet();
       
        sda.Fill(ds, "temp");
       
        for (int i = 0; i < 5; i++)
        {
            DataRow dr = ds.Tables[0].NewRow();
            dr[0] = i.ToString();
            dr[1] = i.ToString();
            ds.Tables["temp"].Rows.Add(dr);
        }
        sda.Update(ds, "temp");      
       
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
        con.Close();