关于SqlDataAdapter.update的问题！

[sanshisong]

protected void Page_Load(object sender, EventArgs e)
{
string source = "Data Source=SERVER;Initial Catalog=aaaa;User Id=sa;Password=beyond";
SqlConnection conn = new SqlConnection(source);
DataSet ds = new DataSet();
string sql = "select * from am";
SqlDataAdapter Dp = new SqlDataAdapter(sql, conn);
Dp.Fill(ds,"am");
DataRow dr = ds.Tables["am"].Rows[0];
dr.Delete();
Dp.Update(ds, "am");
DataGrid1.DataSource = ds.Tables["am"].DefaultView;

DataGrid1.DataBind();

}

－－
当传递具有已删除行的 DataRow 集合时,更新要求有效的 DeleteCommand

代码如上，我刚学ASP.NET请大家帮下忙，回答下

[3tzjq]

//...
SqlDataAdapter Dp = new SqlDataAdapter(sql, conn);
SqlCommandBuilder scd = new SqlCommandBuilder(Dp);
//...

[jimu8130]

你设置下dataadapter的DeleteCommand属性啊

[amandag]

string source = "Data Source=SERVER;Initial Catalog=aaaa;User Id=sa;Password=beyond";
SqlConnection conn = new SqlConnection(source);
DataSet ds = new DataSet();
string sql = "select * from am";
SqlDataAdapter Dp = new SqlDataAdapter(sql, conn);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
Dp.Fill(ds,"am");
DataRow dr = ds.Tables["am"].Rows[0];
dr.Delete();
Dp.Update(ds, "am");
DataGrid1.DataSource = ds.Tables["am"].DefaultView;

DataGrid1.DataBind();

[Eddie005]

System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection("连接字符串");
System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand();
cm.Connection = cnn;
cm.CommandText = "select top 10 * from table1";
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cm);

DataTable dt = new DataTable();
da.Fill(dt);
da.FillSchema(dt,System.Data.SchemaType.Mapped);//这是必须的，要载入数据表结构


//下面遍历和更新数据
foreach(DataRow row in dt.Rows)
row["theDate"] = DateTime.Now;

//下面重新写会数据库
System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(da);//这句看起来没什么作用，但实际上很关键，如果没有这个就不能用da.Update方法
cnn.Open();
da.Update(dt);
cnn.Close();

[amandag]

//上面错了
protected void Page_Load(object sender, EventArgs e)
{
string source = "Data Source=SERVER;Initial Catalog=aaaa;User Id=sa;Password=beyond";
SqlConnection conn = new SqlConnection(source);
DataSet ds = new DataSet();
string sql = "select * from am";
SqlDataAdapter Dp = new SqlDataAdapter(sql, conn);
//加这句
SqlCommandBuilder cmd = new SqlCommandBuilder(Dp);
Dp.Fill(ds,"am");
DataRow dr = ds.Tables["am"].Rows[0];
dr.Delete();
Dp.Update(ds, "am");
DataGrid1.DataSource = ds.Tables["am"].DefaultView;

DataGrid1.DataBind();

}