 其实很简单，就是用sqldataadapter的update方法就行了。主要代码例如下所示： private void update() { string link = configurationsettings.appsettings["link_local"].tostring(); sqlconnection conn = new sqlconnection(link); sqldataadapter da = new sqldataadapter("select order_id, contract from linhai", conn); dataset ds = new dataset(); da.fill(ds, "linhai"); da.updatecommand = new sqlcommand("update linhai set contract = @contract " + "where order_id = @order_id" , conn); da.updatecommand.parameters.add("@contract", sqldbtype.nvarchar, 15, "contract"); da.updatecommand.parameters.add("@order_id", sqldbtype.nvarchar, 15, "order_id"); ds.tables["linhai"].rows[0]["contract"] = "ppp"; da.update(ds.tables[0]); } |
喜欢本文，那就收藏到： |
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到POCO网摘"){kind=logo}
Rss Feed
