表aa中就一列aa,修改aa=7为5,报错为:Update 无法找到 TableMapping['Table'] 或 DataTable“Table”。实在搞不懂啊,高手留个答案谢谢拉!
protected void Button1_Click(object sender, EventArgs e)
{
string conStr = "Data Source=TONY;Initial Catalog=SiteDB;Persist Security Info=True;User ID=sa;Password=1";
SqlConnection cn = new SqlConnection(conStr);
cn.Open();
string sql = "select aa from aa where aa='7'";
SqlDataAdapter da = new SqlDataAdapter(sql, cn);
SqlCommandBuilder myBuilder = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "aa");
DataRow add = ds.Tables["aa"].Rows[0];
add.BeginEdit();
add[0] = "5";
add.EndEdit();
da.Update(ds);
cn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string conStr = "Data Source=TONY;Initial Catalog=SiteDB;Persist Security Info=True;User ID=sa;Password=1";
SqlConnection cn = new SqlConnection(conStr);
cn.Open();
string sql = "select aa from aa where aa='7'";
SqlDataAdapter da = new SqlDataAdapter(sql, cn);
SqlCommandBuilder myBuilder = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "aa");
DataRow add = ds.Tables["aa"].Rows[0];
add.BeginEdit();
add[0] = "5";
add.EndEdit();
da.Update(ds);
cn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货