SearchResult.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;
using System.Data.SqlClient;
public partial class SearchResult : System.Web.UI.Page
{
    DataAccess MarketBase = new DataAccess();
    DataTable GetKeyInfo = new DataTable();
    string sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string KeyWords = Request["KeyWords"];
          
            string SortType = Request["sort"];
           
           
                SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
                conn.Open();
                if (SortType == "13")
                {
                    sql = "select * from Info where InfoTitle like'%" + KeyWords + "%'";
                    GetKeyInfo = MarketBase.DisPlayList_Ds(sql, conn);
                }
             
                else
                {
                    sql = "select * from Info where Infotitle like '%" + KeyWords + "%' and TypeID='" + SortType + "' ";
                    GetKeyInfo = MarketBase.DisPlayList_Ds(sql, conn);
                }
            
            
            
            searchreusltgv.DataSource = GetKeyInfo.DefaultView;
            searchreusltgv.DataBind();
        }
    }
    protected void searchreusltgv_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        searchreusltgv.PageIndex = e.NewPageIndex;
        searchreusltgv.DataSource = GetKeyInfo.DefaultView;
        searchreusltgv.DataBind();
    }
}