报表服务 在客户端提交参数

首先我们提供一个SQL查询语句：select <br>(case sexcode when '1' then '男'<br>when '2' then '女' end )<br>as 'sex',<br>[name],mobilephone<br>from dbo.P_PersonBase<br>where dayofbirth between <font color="#ff0000">@bt </font>and <font color="#ff0000">@et</font><br>order by sexcode<br>其中@bt和@et为需要从客户端传递的参数<br>构建一个Winform窗体 拖放两个时间控件和一个Button控件<br>在按钮的onclick事件中写如下代码<br> private void simpleButton1_Click_1(object sender, EventArgs e)<br> {<br> DateTime StartTime = System.Convert.ToDateTime(this.dateEdit1.Text);<br> DateTime EndTime = System.Convert.ToDateTime(this.dateEdit2.Text);<br> ReportParameter[] Parameters = new ReportParameter[2];<br> Parameters[0] = new ReportParameter("bt", StartTime.ToShortDateString());<br> Parameters[1] = new ReportParameter("et", EndTime.ToShortDateString());<br> reportViewer1.ServerReport.SetParameters(Parameters);<br> reportViewer1.RefreshReport();<br><br> }<br><br>