这样删除一条记录为何不行....?

[delphiyesterday]

String strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Inetpub\\wwwroot\\WebApplication_crm\\Data\\ASP.mdb;";
OleDbConnection OleConn=new OleDbConnection(strConn);

String strSQL="SELECT * FROM khxx";
OleDbDataAdapter objAdapter=new OleDbDataAdapter(strSQL,OleConn);
DataSet objDataSet=new DataSet();

objAdapter.Fill(objDataSet,"dtkhxx");
OleConn.Close();

DataTable objDataTable=objDataSet.Tables["dtkhxx"];
int Pid=Convert.ToInt32(e.Item.ItemIndex);
objDataTable.PrimaryKey=new DataColumn[]{objDataTable.Columns[Pid]};

DataRow row=objDataTable.Rows.Find(Pid);
row.Delete();

OleDbCommandBuilder cb=new OleDbCommandBuilder(objAdapter);
OleConn.Open();
objAdapter.Update(objDataSet,"dtkhxx");
OleConn.Close();
提示:"未将对象引用设置到对象的实例。"
通不过的行在:row.Delete();

[neodotnet]

换个顺序看看

OleDbDataAdapter objAdapter=new OleDbDataAdapter(strSQL,OleConn);
OleDbCommandBuilder cb=new OleDbCommandBuilder(objAdapter);

[delphiyesterday]

结果一样.

[neodotnet]

e.Item.ItemIndex
这不是某行的索引吗??你怎么又把他当做主键的字段啦??

[ZYY123456]

DataRow row=objDataTable.Rows.Find(Pid); FIND方法有问题，可能是一BUG

[delphiyesterday]

高手帮下呵.

[steveson]

需要增加以下的代码（可能需要调整一下位置）：

const string insertCustSQL = "INSERT INTO TableName(...) VALUES (@...)";
const string updateCustSQL = "UPDATE TableName SET .. = @.. WHERE KeyID = @oldKeyID ";
const string deleteCustSQL = "DELETE FROM TableName WHERE KeyID = @oldKeyID ";

//添加插入、更新和删除命令
objAdapter.InsertCommand = new SqlCommand(insertCustSQL, OleConn);
buildInsertParams(objAdapter.InsertCommand);
objAdapter.UpdateCommand = new SqlCommand(updateCustSQL, OleConn);
buildUpdateParams(objAdapter.UpdateCommand);
objAdapter.DeleteCommand = new SqlCommand(deleteCustSQL, OleConn);
buildDeleteParams(objAdapter.DeleteCommand);

//应用更新
objAdapter.Update(objDataSet, "TableName");

private void buildInsertParams(SqlCommand workCommand)
{
SqlParameter workParam = null;
workParam =
workCommand.Parameters.Add(new SqlParameter("@KeyID", SqlDbType.NChar, 5));
workParam.Direction = ParameterDirection.Input;
workParam.SourceColumn = "KeyID";

......
}

并类似构造
private void buildUpdateParams(SqlCommand workCommand)
private void buildDeleteParams(SqlCommand workCommand)

[steveson]

还有一点，你只需要Delete相关部分，其他的可以不要。

[yonghuan]

zyy123456的看法对
DataRow row=objDataTable.Rows.Find(Pid); FIND方法有问题，可能是一BUG

但未必是BUG，可能找不到行，所以row没有对象。