62,046
社区成员
发帖
与我相关
我的任务
分享
OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;Data Source=" + Server.MapPath("db/sl.mdb"));
OleDbCommand cmd = new OleDbCommand();
conn.Open();
cmd.CommandText = "delete from news where id=" + Convert.ToInt32(Request.QueryString["delid"]) + " ";
cmd.Connection = conn;
int i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
Response.Write("<script>alert('删除成功');</script>");
Response.Redirect("ado_access.aspx");
}
else
{
Response.Write("<script>alert('删除失败');</script>");
Response.Redirect("ado_access.aspx");
}
//关闭数据库连接
conn.Close();
//释放资源
conn.Dispose();