admin/product.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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 admin_product : System.Web.UI.Page
{
    String SqlStr;
    DB db = new DB();
    DataSet Ds = new DataSet();
    String full_name;
    int PageSize;
    int RecordCount;
    int PageCount;
    int CurrentPage;
    public void BookType_DataBind()
    {
        SqlStr = "select 品牌名称 from 手机类型表";
        Ds = db.GetDataTableBySql(SqlStr);
        try
        {
            for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
            {
                DropDownList_BookType.Items.Add(Ds.Tables[0].Rows[i][1].ToString());
            }
        }
        catch (Exception)
        {
            Response.Write("<script>alert('没有获得数据！')</script>");
        }

    }
    public void DataListBind()
    {
        PageSize = 10;
        try
        {
            int StartIndex = CurrentPage * PageSize;
            String SqlStr = "select * from 手机信息视图";
            DataSet Ds = new DataSet();
            SqlConnection con = new SqlConnection();
            con.ConnectionString = db.GetConnectionString();
            con.Open();
            SqlDataAdapter Da = new SqlDataAdapter(SqlStr, con);
            Da.Fill(Ds, StartIndex, PageSize, "手机信息视图");
            this.DataList1.DataSource = Ds.Tables["手机信息视图"].DefaultView;
            this.DataList1.DataBind();
            this.PreviousLB.Enabled = true;
            this.NextLB.Enabled = true;
            if (CurrentPage == (PageSize - 1))
                this.NextLB.Enabled = false;
            if (CurrentPage == 0)
                this.PreviousLB.Enabled = false;