كود :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
using Microsoft.Reporting.WebForms;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
private void ShowReport()
{
rptViewer.Reset();
DataTable dt = GetData(DateTime.Parse(txtFrom.Text), DateTime.Parse(txtTo.Text));
ReportDataSource rds = new ReportDataSource("", dt);
rptViewer.LocalReport.ReportPath = "Data.rdlc";
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("fromDate", txtFrom.Text),
new ReportParameter("toDateDate", txtTo.Text)
rptViewer.LocalReport.Refresh()
};
}
private DataTable GetData(DateTime dateTime, DateTime dateTime)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Data"].ConnectionString);
{
SqlCommand cmd = new SqlCommand("GetOrderByDate", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters .Add ("@From", SqlDbType.DateTime).Value = fromDate;
cmd.Parameters .Add ("@To", SqlDbType.DateTime).Value = toDate;
SqlDataAdapter adp = new SqlDataAdapter (cmd);
adp.Fill(dt);
}
return (dt);
}
}