微信幸运九宫格抽奖源码/51wsb_wxjgg/admin/jgglist.aspx.cs

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace wxjgg.admin
{
    public partial class jgglist : System.Web.UI.Page
    {
        public string weburl = "";
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                try
                {
                    ViewState["username"] = Request.Cookies["site"]["adminame"];
                    binder();
                    weburl = System.Configuration.ConfigurationSettings.AppSettings["weburl"].ToString();
                }
                catch
                {
                    Response.Redirect("login.aspx");
                }
            }
        }
        public void binder()
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqldb"].ToString());
            SqlCommand cmd = new SqlCommand("select *,(select count(*) from zjlist where hdid=jgglist.id) as allcount from jgglist order by id desc", con);
            DataSet ds = new DataSet();
            ds.Clear();
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(ds, "jgglist");
            DataGrid1.DataSource = ds.Tables[0].DefaultView;
            DataGrid1.DataKeyField = "id";
            DataGrid1.DataBind();
            con.Close();
        }
        protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            DataGrid1.CurrentPageIndex = e.NewPageIndex;
            binder();
        }
    }
}