–表:table
–字段:columsa、columsb、columsc、columsd
void main(){
string sql=”select columsa from table”;
datatable dt=sqlhelper.executequery(sql);
dt.rows[0][“columsa”]=”111″;
sdaupdate(sql,dt)
}
public void sdaupdate(string selectsql,datatable dt)
{
try
{
sqlcommand sqlcommand = getsqlconn().createcommand();
sqlcommand.commandtext = selectsql;
sqldataadapter sdaadapter = new sqldataadapter(sqlcommand);
sqlcommandbuilder scbbuilder = new sqlcommandbuilder(sdaadapter);
sdaadapter.update(dt);
}
catch (exception ex)
{
}
}
黄山市民网:https://www.huangshanshimin.com/