入赘女皇伤不起,ose.exe,黄志强凉茶
1、修改数据
datarow dr = hrdataset.tables["emp"].rows.find(textbox3.text);
//datarow dr = hrdataset.tables["emp"].select("id="+textbox3.text)[0];
dr.beginedit();
dr["name"] = textbox1.text;
dr.endedit();
sqlcommandbuilder cmd=new sqlcommandbuilder(emptableadapter);
emptableadapter.update(hrdataset);
this.emptableadapter.fill(this.hrdataset.emp);
2、插入数据
dataset ds = new dataset();
using (sqlconnection conn = new sqlconnection(configurationmanager.connectionstrings["db"].connectionstring))
{
string sql = "select id,name,age from emp";
sqldataadapter adp = new sqldataadapter(sql, conn);
adp.fill(ds);
datarow dr=ds.tables[0].newrow();
dr["name"]=txtname.text;
dr["age"] = convert.toint32(txtage.text);
sqlcommandbuilder cmd=new sqlcommandbuilder(adp);
ds.tables[0].rows.add(dr);
adp.update(ds);
}
3、删除数据
datarow dr = hrdataset.tables["emp"].rows.find(textbox3.text);
//datarow dr = hrdataset.tables["emp"].select("id="+textbox3.text)[0];
dr.delete();
sqlcommandbuilder cmd=new sqlcommandbuilder(emptableadapter);
emptableadapter.update(hrdataset);
this.emptableadapter.fill(this.hrdataset.emp);
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
网友评论