string strsql = "insert into subitem (id,subitem,item,dept) values(2,2,3,4)"; try
{
SqlDaConn.Open();
SqlDataAdapter SqlDa = new SqlDataAdapter(StrSql, SqlDaConn);
SqlCommandBuilder SqlCb = new SqlCommandBuilder(SqlDa);
return SqlDa;
}
catch
{
return null;
}
语句我通过sql2000里的查询分析是能添加的。运用下面方法就不行。第一次写mssql的求指教。
string strsql = "insert into subitem (id,subitem,item,dept) values(2,2,3,4)";
SqlDaConn.Open();
SqlCommand SqlDa = new SqlCommand(StrSql, SqlDaConn);
SqlDa.ExcuteNonQuery();
SqlCommandBuilder SqlCb = new SqlCommandBuilder(strsql,SqlDaConn);
SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCb);
这样试试
SqlCommandBuilder
这两个到底怎么用啊?
求教程求指导。
SqlDataAdapter 类
SqlCommandBuilder 类