Access查询时间段案例

 try
        {
            if (tbxStartTime.Text != "" || tbxEndTime.Text != "")
            {
                string strCn = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=D:\\WorkSpace\\PrintTable\\DB\\db.mdb";
                OleDbConnection OleCn = new OleDbConnection(strCn);
                string strCmd = "select * from (select * from PrintData where NowDateTime between #" + tbxStartTime.Text.ToString() + "# and #" + tbxEndTime.Text.ToString() + "#  order by NowDateTime asc) where DeleteShow = false";
                OleDbCommand OleCmd = new OleDbCommand(strCmd, OleCn);
                OleDbDataAdapter OleAda = new OleDbDataAdapter(OleCmd);
                DataTable ds = new DataTable();
                OleCn.Open();
                OleAda.Fill(ds);
                OleCn.Close();
                this.gvShow.DataSource = ds;
                this.gvShow.DataBind();
                int i = ds.Rows.Count;
                decimal Sum = Decimal.Parse(ds.Compute("Sum(Money)", "").ToString());
                string strSum = Sum.ToString();
                lblSumTime.Text = strSum;
                lblErrorMse.Text = "";
            }
            else
            {
                getData();
                lblErrorMse.Text = "";
            }
        }
        catch
        {
            lblErrorMse.Text = "没有符合条件的数据，或条件输入错误！请重新输入";