SqlConnection con = new SqlConnection(……);
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from t_user", con);
DataSet ds = new DataSet();
adp.Fill(ds, "biao");
DataTable Dtbl = ds.Tables["biao"];
for (int i = 1; i < 10; i++)
{
Dtbl.Rows[i].Delete();//删数据
}
Dtbl.AcceptChanges();
GridView1.DataSource = Dtbl;
GridView1.DataBind();
adp.Update(Dtbl);//我觉得这里不对,所以更新不了库中的表请帮忙说一下update()的使用方法
SqlDataAdapter da = new SqlDataAdapter("Select * FROM Tb", cn);
DataSet ds = new DataSet();
cn.Open();
da.Fill(ds, "test");
cn.Close(); ds.Tables["test"].Rows[0]["Name"] = "test";
cn.Open();
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
da.Update(ds.Tables[0]);
cn.Close();
DataSet ds = new DataSet();SqlCommandBuilder cb = new SqlCommandBuilder(adp);
加在处
SqlCommandBuilder cmd = new SqlCommandBuilder(adp);
adp.Update(ds.Tables["biao"]);
然后在绑定一下数据库!