protected void Button1_Click(object sender, EventArgs e) { con.Open(); SqlCommand cmd = new SqlCommand("sp_RptRouteWiseNetSaleDetails", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); CrystalReportViewer1.RefreshReport(); ReportDocument rpdoc = new ReportDocument(); rpdoc.Load(Server.MapPath("RouteWiseNetSaleDetailsByDate.rpt")); rpdoc.SetDataSource(dt); rpdoc.SetParameterValue("@intFlag", TextBox1.Text); rpdoc.SetParameterValue("@Code", Convert.ToString(TextBox2.Text)); rpdoc.SetParameterValue("@dtpFrom", Convert.ToDateTime(TextBox3.Text).ToShortDateString()); rpdoc.SetParameterValue("@dtpTo", Convert.ToDateTime(TextBox4.Text).ToShortDateString()); CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.ReportSource = rpdoc; CrystalReportViewer1.DataBind(); con.Close(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)