protected void btngetreport_Click(object sender, EventArgs e) { try { if (Rdboutward.SelectedValue == "Outward") { DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "Outward", "G", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0]; GrdOD.DataSource = dt; GrdOD.DataBind(); }//[Idv_Chetana_Get_OutwardDetails] else if (Rdboutward.SelectedValue == "Invoice") { DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "ss", "I", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0]; GrdOD.DataSource = dt; GrdOD.DataBind(); } else { DataTable dt = OutwardDetail.Get_OutwardDetails(txtoutwardno1.Text.ToString().Trim(), "ss", "D", Convert.ToInt32(strFY), Convert.ToDateTime("2011/2/2"), Convert.ToDateTime("2012/3/3")).Tables[0]; GrdOD.DataSource = dt; GrdOD.DataBind(); } } catch { } }
public void BindOutWard() { if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null) { DataTable dt = OutwardDetail.Get_OutwardDetails(Request.QueryString["d"].ToString().Trim(), Request.QueryString["sd"].ToString().Trim(), Request.QueryString["IOD"].ToString().Trim() , Convert.ToInt32(Request.QueryString["FY"].ToString().Trim())).Tables[0]; DataView dv = new DataView(dt); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("../Report/OutWardReport.rpt")); rd.Database.Tables[0].SetDataSource(dv); Printoutward.ReportSource = rd; } }