SqlDataAdapter的易错用法

strsql = "select id as'方案编号',prereagentid as '试剂编号' ,prereagent as '试剂名称',preamount as '试剂用量'  

from project where id = (select Max(id)+1 from remarks)";
this.myconn = new SqlConnection(strconn);
this.da = new SqlDataAdapter(strsql, strconn);
this.ds = new DataSet();da.Fill(ds, "data");

SqlCommandBuilder bd = new SqlCommandBuilder(da);

da.InsertCommand = bd.GetInsertCommand();  

da.Update(ds.Tables["data"]);
//以上代码，如果稍不留神，就会忽略掉data名称，程序便出错。也就是说，如果写成
 da.Fill(ds);


……


da.Update(ds);
//就必然会出错，必须得有表名。