private void SelectOutstandingReport() { try { OutstandingBLL consume = new OutstandingBLL(); List <STP_OutstandingReportResult> lst = consume.SearchOutstanding(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); if (lst != null) { lbl.Text = "Outstanding Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; DataTable dt = ListConverter.ToDataTable(lst); dt.Columns.Add("colSrNo"); DataColumn dcol = new DataColumn(); if (dt.Rows.Count > 0) { int count = 1; foreach (DataRow dr in dt.Rows) { dr["colSrNo"] = count; count++; } } dgvTestParameter.DataSource = dt; dgvTestParameter.DataBind(); Session["OutstandingReport"] = dt; //txtBillDate.Text = string.Empty; //txtToDate.Text = string.Empty; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
private void SelectOutstandingReport() { try { OutstandingBLL consume = new OutstandingBLL(); List <STP_SupplierOutstandingReportResult> lst = consume.SearchSupplierOutstanding(Convert.ToDateTime(txtBillDate.Text), Convert.ToDateTime(txtToDate.Text)); if (lst != null) { lbl.Text = "Supplier Outstanding Report"; lblFrom.Text = txtBillDate.Text; lblTo.Text = txtToDate.Text; dgvTestParameter.DataSource = lst; dgvTestParameter.DataBind(); Session["SuppOutstand"] = ListConverter.ToDataTable(lst); txtBillDate.Text = string.Empty; txtToDate.Text = string.Empty; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }