member/od2.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class member_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack && Session["lname"]!=null)
        {
            bind();
        }
    }

    // 绑定  
    private void bind()
    {
        string where = "  where c.lname='" + Session["lname"].ToString() + "' ";

        GridView1.DataSource = DbHelperSQL.Query("select a.*,b.lname,pname,pic from ordersMore a left join orders b on a.oid=b.oid left join products c on a.pid=c.pid " + where + " order by oid desc");
        GridView1.DataBind();

    }

    /// <summary>
    /// 分页事件  
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind();
    }

    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lnk_Click(object sender, EventArgs e)
    {
        LinkButton lk = (LinkButton)sender;

        //删除相应的记录
        DbHelperSQL.ExecuteSql(" delete from ordersMore where id=" + lk.CommandName);

        //重新绑定数据源
        bind();
    }
}