SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open() ;
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM T_order", conn); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); DataSet thisDataSet = new DataSet();
adapter.Fill(thisDataSet, "t_order");
thisDataSet.Tables["t_order"].Rows[1][1] = "22";
adapter.Update(thisDataSet, "t_order");
conn.Close();adapter.Update(thisDataSet, "t_order");这一句时出错
"22"类型与表中是否匹配
对于不返回任何键列信息的 SelectCommand,不支持 UpdateCommand 的动态 SQL 生成。