JiFen_List.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 JiFen_List : System.Web.UI.Page
{
    
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            InitData();
        }
    }
    protected void InitData()
    {
        string SQL = "select * from TB_XiaoFei";
        DataSet ds = DBHelper.GetDataSet(SQL);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
    }
 
    protected void Button2_Click(object sender, EventArgs e)
    {
        string SQL = "select * from TB_XiaoFei where 1=1";
        if (!string.IsNullOrEmpty(this.TextBox1.Text))
        {
            SQL = SQL + " and KaHao='"+this.TextBox1.Text+"'";
        }

        if (!string.IsNullOrEmpty(this.TextBox2.Text))
        {
            SQL = SQL + " and ShiJian>='" + this.TextBox2.Text + "'";
        }


        if (!string.IsNullOrEmpty(this.TextBox3.Text))
        {
            SQL = SQL + " and ShiJian<='" + this.TextBox3.Text + "'";
        }
        DataSet ds = DBHelper.GetDataSet(SQL);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();

    }
}