说明:通常我们在做数据库交互时,并不一定要使用特定的SQL语句来更新数据,.NET Framwork为我们提供了自动更新的功能
public static void UpdateTable()
{
SqlConnection conn = null;
string sql = "select *From Course";
DataTable dt = null;
DataSet ds = new DataSet();
try
{
conn = new SqlConnection(connectionString);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand(sql, conn);
SqlCommandBuilder cb = new SqlCommandBuilder(sda);//自动生成相应的命令,这句很重要
conn.Open();
sda.Fill(ds);
dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["ID"] = 1006;
dr["Name"] = "面向对象编程";
dr["Grade"