protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { } else { btnsubmit_Click(null, null); } } protected void btnsubmit_Click(object sender, EventArgs e) { try { con.Open(); SqlCommand cmd = new SqlCommand("select * from employeedetails ", con); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); da = new SqlDataAdapter(cmd); rdoc.Load(Server.MapPath("~/EmpReports/SalaryofMonth.rpt")); dt.Clear(); da.Fill(dt); rdoc.SetDataSource(dt); rdoc.SetParameterValue("month", ddlmonth.SelectedItem.Text); rdoc.SetParameterValue("cmpname", ddlcompanyname.SelectedItem.Text); CrystalReportViewer1.ReportSource = rdoc; CrystalReportViewer1.DataBind(); con.Close(); } catch (Exception) { } } protected void CrystalReportViewer1_Unload1(object sender, EventArgs e) { rdoc.Close(); rdoc.Dispose(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)