list.aspx.cs

来自「一个简单的聊天代码」· CS 代码 · 共 56 行

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;

public partial class List : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }
    }
    void Bind()
    {
        string sql;
        sql = "select * from Spclass";
        if (Request.QueryString["Cid"] == null && Request.QueryString["Spcs"] == null && Request.QueryString["Ser"] == null)
        { 
            sql = "select *,(select name from Spclass where id= Info.sort) as SortName  from Info order by id desc"; }
        else if (Request.QueryString["Cid"]!= null&& Request.QueryString["Spcs"] == null && Request.QueryString["Ser"] == null)
        {
            string Cid = spstr.tosql(Request.QueryString["Cid"]);
            sql = "select *,(select name from Spclass where id= Info.sort) as SortName from Info where sort =" + Cid + " order by id desc";
        }


        else if ( Request.QueryString["Spcs"] != null && Request.QueryString["Ser"] != null)
        {
           string  Spcs = spstr.tosql(Request.QueryString["Spcs"]);
           string  Ser = spstr.tosql(Request.QueryString["Ser"]);
           sql = "select *,(select name from Spclass where id= Info.sort) as SortName from Info where sort =" + Spcs + " and title like '%" + Ser + "%'";
        }
       

        DataSet ds = Spbase.GreatDs(sql);
        GridView1.DataSource = ds;
        GridView1.DataBind();

    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
        Bind();
    }
}