62,074
社区成员
发帖
与我相关
我的任务
分享
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
admange ad = new admange();
int adid=Convert.ToInt32( GridView1.DataKeys[e.RowIndex].Value.ToString());
if (ad.deltdate(adid))
{
Response.Write("删除成功!");
}
else {
Response.Write("删除失败!");
}
getdate();
}
//得到数据的getdagte
private void getdate() {
this.GridView1.DataSource = admange.getdate();
GridView1.DataKeyNames = new string[] { "adid" };
this.GridView1.DataBind();
}
//C# 返回数据的
public static DataTable getdate()
{
OleDbConnection conn = db.createDB();
conn.Open();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = new OleDbCommand("select * from admanagetable",conn);
DataSet ds = new DataSet();
oda.Fill(ds, "admanagetable");
return ds.Tables["admanagetable"];
}
//C# 删除操作
public bool deltdate(int adid) {
OleDbConnection conn = db.createDB();
conn.Open();
OleDbCommand cmd = new OleDbCommand("delete from admanagetable where adid="+adid,conn);
int num = cmd.ExecuteNonQuery();
if (num > 0)
{
return true;
}
else
{
return false;
}
}
//数据库连接在config里写着