?using System;
using System.Data;
using System.Data.SqlClient;
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 jhdcx : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //初始化日期范圍        
            this.TextBox1.Text = DateTime.Today.ToShortDateString();
            this.TextBox2.Text = DateTime.Today.ToShortDateString();
           
            bindgrig();
        }

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //查詢符合條件的銷售單，默認第一頁
        GridView1.PageIndex = 0;
        bindgrig();

    }

    void bindgrig()
    {
        SqlConnection Conn;

        // 設置數據庫連接
        string strConn = ConfigurationManager.AppSettings["conn"];
        Conn = new SqlConnection(strConn);

        //從數據庫取查詢結果
        SqlDataAdapter Cmd = new SqlDataAdapter("select a.銷售單編號,a.日期,b.商品名稱,a.數量 from 銷售單 a,商品庫存 b where a.商品編號=b.商品編號 and a.日期 >=convert(smalldatetime,'" + this.TextBox1.Text + "',120) and a.日期 <=convert(smalldatetime,'" + this.TextBox2.Text + "',120) and  a.商品編號 like '%" + this.TextBox3.Text + "%' order by a.銷售單編號", Conn);

            DataSet Ds = new DataSet();
        Cmd.Fill(Ds, "銷售單");

        //指定數據源
        GridView1.DataSource = new DataView(Ds.Tables[0]);
        //數據綁定
        GridView1.DataBind();
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //改變顯示頁面
        GridView1.PageIndex = e.NewPageIndex;
        bindgrig();

    }
}