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