friendinfo.aspx.cs

来自「邮件发送系统」· CS 代码 · 共 43 行

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class FriendInfo : System.Web.UI.Page
{
    //生成公共类SqlOperate的一个对象，以调用其方法
    SqlOperate sqlBind = new SqlOperate();
    //========================页面加载事件=====================================
    protected void Page_Load(object sender, EventArgs e)
    {
        string sqlstr = "select * from tb_Friend";
        gvFriendInfo.DataKeyNames = new string[] { "FriendID" };
        sqlBind.gvBind(gvFriendInfo, sqlstr);
    }
    protected void gvFriendInfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from tb_Friend where FriendID='" + gvFriendInfo.DataKeys[e.RowIndex].Value + "'";
        sqlBind.DataCom(sqlstr);
        Response.Redirect("FriendInfo.aspx"); 
    }
    protected void gvFriendInfo_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ((LinkButton)(e.Row.Cells[4].Controls[0])).Attributes.Add("onclick", "return confirm('确定删除吗？')");
        }
    }
    protected void gvFriendInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvFriendInfo.PageIndex = e.NewPageIndex;
        gvFriendInfo.DataBind();
    }
}