int intRe = -1;
string strsql = @" SELECT * FROM News ";
//表中2字段 CategoryName CategoryId
using (SqlConnection conn = new SqlConnection(strConn) )
{
conn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter(strsql, conn);
SqlCommandBuilder myCommandB = new SqlCommandBuilder(myCommand);
DataTable t = new DataTable();
myCommand.Fill(t);
DataRow dr;
dr = t.Rows[0];
dr["CategoryName"] = "bbbbbbbbb";
intRe = myCommand.Update(t);
}
string strsql = @" SELECT * FROM News ";
//表中2字段 CategoryName CategoryId
using (SqlConnection conn = new SqlConnection(strConn) )
{
conn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter(strsql, conn);
SqlCommandBuilder myCommandB = new SqlCommandBuilder(myCommand);
DataTable t = new DataTable();
myCommand.Fill(t);
DataRow dr;
dr = t.Rows[0];
dr["CategoryName"] = "bbbbbbbbb";
intRe = myCommand.Update(t);
}
要定义UPDATE SQL COMMAND 和 PARAMETER