Question

datalist中实现删除一条数据的方法

在datalist中添加一个linkButton 点击删除对应的一条数据

Answer 1

aspx页面
LinkButton 包含在datalist中

<asp:LinkButton ID="lbtnDelete" runat="server"OnCommand="lbtnDelete_Command" Style="position:relative" CommandArgument='<%#DataBinder.Eva(Container.DataItem,"ID")%>'>删除</asp:LinkButton>

aspx.cs 页面
protected void lbtnDelete_Command(object sender, CommandEventArgs e)
{
//string userID = Request.QueryString["userID"]; //不好传送,试了N遍
string userID = e.CommandArgument.ToString();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = db.createCon();
cmd.CommandText = "delete from guest where ID='"+userID+"'";
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("<script>alert('删除成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('删除失败！');window.location=window.location;</script>");
}
}

Answer 2

直接写sql语句就行了！

Answer 3

这么抠?

Answer 4

aspx页面
LinkButton
包含在datalist中
<asp:LinkButton
ID="lbtnDelete"
runat="server"OnCommand="lbtnDelete_Command"
Style="position:relative"
CommandArgument='<%#DataBinder.Eva(Container.DataItem,"ID")%>'>删除</asp:LinkButton>
aspx.cs
页面
protected
void
lbtnDelete_Command(object
sender,
CommandEventArgs
e)
{
//string
userID
=
Request.QueryString["userID"];
//不好传送,试了N遍
string
userID
=
e.CommandArgument.ToString();
OleDbCommand
cmd
=
new
OleDbCommand();
cmd.Connection
=
db.createCon();
cmd.CommandText
=
"delete
from
guest
where
ID='"+userID+"'";
if
(cmd.ExecuteNonQuery()
>
0)
{
Response.Write("<script>alert('删除成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('删除失败！');window.location=window.location;</script>");
}
}