protected void Button1_Click(object sender, EventArgs e) { ReportViewer1.ProcessingMode = ProcessingMode.Local; //ReportViewer1.ZoomMode = Microsoft.Reporting.WebForms.ZoomMode.PageWidth; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/ContractIns.rdlc"); InsContract dsCustomers = GetData(); ReportDataSource datasource = new ReportDataSource("DataSet1", dsCustomers.Tables[0]); ReportParameter rp = new ReportParameter("Startdate", txtfrmdate.Text.ToString()); ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp }); ReportParameter rp1 = new ReportParameter("Enddate", txttodate.Text.ToString()); ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 }); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); }
private InsContract GetData() { string listvalue = ""; foreach (ListItem item in SKT.Items) { if (item.Selected) { listvalue += item.Value + ","; } } string Productvalue = ""; foreach (ListItem item1 in PPS.Items) { if (item1.Selected) { Productvalue += item1.Value + ","; } } string customertypevalue = ""; foreach (ListItem item2 in customertype.Items) { if (item2.Selected) { customertypevalue += item2.Value + ","; } } string conString = ConfigurationManager.ConnectionStrings["ConnectionString_master"].ConnectionString; SqlCommand cmd = new SqlCommand("allDepotDailySalerepor_Contractual_ins"); using (SqlConnection con = new SqlConnection(conString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB");//dd/MM/yyyy DateTime from = Convert.ToDateTime(txtfrmdate.Text); DateTime to = Convert.ToDateTime(txttodate.Text); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@startdate", from.ToString("MM/dd/yyyy HH:mm:ss")); cmd.Parameters.AddWithValue("@endate", to.ToString("MM/dd/yyyy HH:mm:ss")); //cmd.Parameters.AddWithValue("@customercode", Customercode.Text.Trim()); //cmd.Parameters.AddWithValue("@customertype", customertypevalue); //cmd.Parameters.AddWithValue("@Billno", BillNo.Text.Trim()); //cmd.Parameters.AddWithValue("@SKT", listvalue); //cmd.Parameters.AddWithValue("@HQ", HQ.Text.Trim()); //cmd.Parameters.AddWithValue("@pps", Productvalue); //cmd.Parameters.Add("@message", SqlDbType.VarChar, 300); //cmd.Parameters["@message"].Direction = ParameterDirection.Output; sda.SelectCommand = cmd; using (InsContract dsCustomers = new InsContract()) { sda.Fill(dsCustomers, "DataTable1"); //lblstatus.Text = cmd.Parameters["@message"].Value.ToString(); return(dsCustomers); } } } }