MLChuShou.aspx.cs

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

using System;
using System.Collections.Generic;
 
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class MLChuShou : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             
            GetInfo();
        }
    }
    private void GetInfo()
    {
        string Sql = "select * from TB_ChuShou";
        DataSet result = DBHelper.GetDataSet(Sql);
        this.GridView1.DataSource = result.Tables[0];
        this.GridView1.DataBind();


    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string Sql = "select * from TB_ChuShou where 1=1";
        if (!string.IsNullOrEmpty(this.TextBox1.Text))
        {
            Sql=Sql+" and DiZhi like'%"+this.TextBox1.Text+"%'";
        }  
        if (!string.IsNullOrEmpty(this.TextBox2.Text))
        {
            Sql = Sql + " or JianZhuLeiXing like'%" + this.TextBox2.Text + "%'";
        }
        if (!string.IsNullOrEmpty(this.TextBox3.Text))
        {
            Sql = Sql + " or FangJia like'%" + this.TextBox3.Text + "%'";
        }
        DataSet result = DBHelper.GetDataSet(Sql);
        this.GridView1.DataSource = result.Tables[0];
        this.GridView1.DataBind();
    }
}