摘要：
--表：表--字段：columnsA，columnsB，columnsC，columnsDoid Main（）｛stringsql=“selectcolumnsAfromtable”；DataTabledt=SqlHelper.executeQuery（sql）；dt.rows[0][“columnsA”]=“111”；sdaUpdate（sql，dt）｝publicvoid sdaUpdate
--表：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)
{
}
}