62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class UserManage2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = DB.createDB();
con.Open();
SqlCommand cmd = new SqlCommand("select * from Users", con);
SqlDataReader sdr = cmd.ExecuteReader();
GridView1.DataSource = sdr;
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string commandName = e.CommandName;
int nUserID = -1;
if (int.TryParse(e.CommandArgument.ToString(), out nUserID) == false)
{
return;
}
if (commandName == "delete")
{
SqlConnection con = DB.createDB();
con.Open();
SqlCommand cmd = new SqlCommand("delete from Users where UserID="+nUserID, con);
int result = 0;
result=cmd.ExecuteNonQuery();
if (result > 0)
{
Response.Write("<script>alert('恭喜您,删除成功!')</script>");
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
}
}
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
'避免操作头行或者尾行
If e.Row.RowType = DataControlRowType.DataRow Then
Dim lb As LinkButton
lb = e.Row.FindControl("LinkButton1")
lb.Attributes.Add("onclick", "javascript:return confirm('您准备删除这条记录吗?')")
End If
End Sub
protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
//避免操作头行或者尾行
if (e.Row.RowType == DataControlRowType.DataRow) {
LinkButton lb = default(LinkButton);
lb = e.Row.FindControl("LinkButton1");
lb.Attributes.Add("onclick", "javascript:return confirm('您准备删除这条记录吗?')");
}
}