protected void lblget_Click(object sender, EventArgs e)
{
try
{
FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
DataTable dt = new DataTable();
dt = PettyCash.Idv_Chetana_Get_Petty_Expance_View(FromDate, ToDate, Convert.ToInt32(strFY)).Tables[0];
if (dt.Rows.Count != 0)
{
gvExp.DataSource = dt;
Visibility();
gvExp.DataBind();
gvExp.Visible = true;
}
else
{
gvExp.Visible = false;
message("No Record Found");
}
}
catch (Exception ex)
{
message(ex.Message.ToString());
}
}
public void BindPrintDC()
{
if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null)
{
DataSet ds = new DataSet();
// DataSet ds2 = new DataSet();
ds = PettyCash.Idv_Chetana_Get_Petty_Expance_View(Convert.ToString(Request.QueryString["d"].ToString().Trim()),
Convert.ToString(Request.QueryString["sd"].ToString().Trim()));
//ds2 = PettyCash.Idv_Chetana_Get_Petty_Expance_View(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()),
// Convert.ToInt32(Request.QueryString["sd"].ToString().Trim()));
DataView dv = new DataView(ds.Tables[0]);
//DataView dv1 = new DataView(ds2.Tables[0]);
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("../Report/PettyCashDetails.rpt"));
rd.Database.Tables[0].SetDataSource(dv);
//rd.Database.Tables[1].SetDataSource(dv1);
PrintPettyCash.ReportSource = rd;
}
}
