private Reports.GeneralReport GetData(DateTime start, DateTime end)
{
string conString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Bookings WHERE BookingFrom>=@Start AND BookingFrom<=@End+1"))
{
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
cmd.Parameters.AddWithValue("@Start", start);
cmd.Parameters.AddWithValue("@End", end);
using (Reports.GeneralReport dsBookings = new Reports.GeneralReport())
{
try
{
sda.Fill(dsBookings, "Bookings");
return(dsBookings);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
}
}
private void BindReport()
{
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/GeneralReport.rdlc");
Reports.GeneralReport dsBookings = GetData(Convert.ToDateTime(starting_date.Text, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat), Convert.ToDateTime(ending_date.Text, System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat));
ReportDataSource datasource = new ReportDataSource("GeneralReport", dsBookings.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}
