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;
}
}
