c 如何把dataset写入mysql_C# 将Dataset中的数据直接写入数据库

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();