好不容易把插入的问题解决了,但又来一个删除的问题:using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Wangzhiping;
public partial class test2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlConnection con = DBManager.Instance.getConnection();
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select * from aa ", con);
SqlCommandBuilder sqlcommandbuilder = new SqlCommandBuilder(adapter);
adapter.Fill(ds);
DataRow[] rowArr = ds.Tables[0].Select("a_name='1'");
foreach (DataRow row in rowArr)
{
row.Delete();
}
adapter.Update(ds);
}
}页面错误提示:
对于不返回任何键列信息的 SelectCommand,不支持 DeleteCommand 的动态 SQL 生成。create table aa
(
a_name varchar(50)
)
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Wangzhiping;
public partial class test2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlConnection con = DBManager.Instance.getConnection();
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select * from aa ", con);
SqlCommandBuilder sqlcommandbuilder = new SqlCommandBuilder(adapter);
adapter.Fill(ds);
DataRow[] rowArr = ds.Tables[0].Select("a_name='1'");
foreach (DataRow row in rowArr)
{
row.Delete();
}
adapter.Update(ds);
}
}页面错误提示:
对于不返回任何键列信息的 SelectCommand,不支持 DeleteCommand 的动态 SQL 生成。create table aa
(
a_name varchar(50)
)
lz的问题已经很清楚了 对于不返回任何键列信息的 SelectCommand,不支持 DeleteCommand 的动态 SQL 生成。 那就给他指定阿 指定主键 数据库的表中指定主键