SearchXQ.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 SearchXQ : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = " 基于B/S的家教信息管理系统";
        this.PageCtrl1.gridView = GridView1;


        string Sql = ""; //查询语句

        string KeMU = Request.QueryString["KeMU"].ToString();
        string sex = Request.QueryString["sex"].ToString();
        string Titles = Request.QueryString["Titles"].ToString();
        string FeiYong = Request.QueryString["FeiYong"].ToString();//接受参数的值
        Sql = "select    * from [XuQiu] where  1=1";



        if (KeMU != "")
        {
            Sql += " and   KeMU   like   '%" + KeMU + "%'   ";

        }
        if (sex != "")
        {
            Sql += " and   sex   like   '%" + sex + "%'   ";
        }
        if (Titles != "")
        {
            Sql += " and   Titles   like   '%" + Titles + "%'   ";
        }
        if (FeiYong != "")
        {
            Sql += " and   FeiYong   like   '%" + FeiYong + "%'   ";
        }




        SqlDataSource1.SelectCommand = Sql;//将SQL赋给数据源的SelectCommand参数，根据SQL的语句查询数据库

    }
}