我如何在C#win应用程序中显示从日期到日期的报告 [英] how can i disply report with from date to to date formate in C# win app

问题描述

我的代码在这里

my Code is here

public partial class frmRep1 : Form
   {
       public frmRep1()
       {
           InitializeComponent();
       }
       _Class.OLEDCon ConRep1 = new printing._Class.OLEDCon();
       private void button1_Click(object sender, EventArgs e)
       {
           crystalReportViewer1.RefreshReport();
           crystalReportViewer1.SelectionFormula = "{StockAvail.Date}>='" + cmbFromDate.Text + "'and {StockAvail.Date}<='" + cmbToDate.Text + "'";
           crystalReportViewer1.RefreshReport();

       }

       private void frmRep1_Load(object sender, EventArgs e)
       {
           OleDbDataAdapter da = new OleDbDataAdapter("Select distinct[Date] from StockAvail", ConRep1.Conn);
           DataSet ds = new DataSet();
           da.Fill(ds);
           if (ds.Tables[0].Rows.Count > 0)
           {
               for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
               {
                   cmbFromDate.Items.Add(ds.Tables[0].Rows[i]["Date"]);
                   cmbToDate.Items.Add(ds.Tables[0].Rows[i]["Date"]);
               }
           }
       }
   }

但是选择公式中的代码有错误，存在需要日期时间"

but there is error in code in selection formula there is "A Date time Required"

推荐答案

使用 # 而不是 '' .更改此行.

use # instead of ''. change this line.

crystalReportViewer1.SelectionFormula = 
"{StockAvail.Date}>=#" + cmbFromDate.Text + "# and {StockAvail.Date}<=#" + cmbToDate.Text + "#";

这篇关于我如何在C#win应用程序中显示从日期到日期的报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！