d selectCmd=con.CreateCommand();

selectCmd.CommandText="select * from publishers where pub_id like '99%'";



SqlCommand deleteCmd=con.CreateCommand();

deleteCmd.CommandText="delete from publishers where pub_id=@pub_id";

SqlParameter PubIdPar=new SqlParameter("@pub_id",SqlDbType.Char,4,"pub_id");

PubIdPar.SourceVersion=DataRowVersion.Original;

deleteCmd.Parameters.Add(PubIdPar);



SqlDataAdapter sqlAdapter=new SqlDataAdapter();

sqlAdapter.SelectCommand=selectCmd;

sqlAdapter.DeleteCommand=deleteCmd;



DataSet ds=new DataSet();

con.Open();

sqlAdapter.Fill(ds,"publishers");

DataTable table=new DataTable();

table=ds.Tables["publishers"];

table.PrimaryKey=new DataColumn[]//定义主键，便于查找

{

table.Columns["pub_id"]

};

DataRow row=table.Rows.Find(e.Item.Cells[2].Text);

row.Delete();

sqlAdapter.Update(table);

con.Close();



this.DataGrid1.EditItemIndex=-1;

this.BindGrid();

}



private void DataGrid1_Disposed(object sender, System.EventArgs e)

{



}

}

}

上一页  [1] [2] [3] [4] [5] [6] [7] 

在google里搜索更多(ASP.NET)修改和删除DataGrid行——数据库访问

	Web www.51ec.org

上一篇信息学院： .Net的Outofmemory异常及大内存使用

下一篇信息学院： ASP.NET中使用Server.Transfer()方法在页间传值