query.aspx.cs

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

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 query : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] != null)
            { bind(); }
            else
            {
                bind1();
            }
        }
    }
    void bind()
    {
        string str;
        if (Request.QueryString["id"] == "1")
        {
            str = "SELECT * FROM news where  news_title like '%" + Request.QueryString["nid"] + "%'  order by id desc";

        }
        else
        {
            str = "SELECT * FROM news where news like '%" + Request.QueryString["nid"] + "%' order by id desc";
        }
        GridView1.DataSource = access.GDS(str);
        GridView1.DataBind();
    }
    void bind1()
    {
        string sql;
        sql = "select * from news";
        GridView1.DataSource = access.GDS(sql);
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind1();
    }
}