private void fillGrid()
{
DataTable dtTmp = new DataTable();
clsInvoiceGenration obj = new clsInvoiceGenration();
dtTmp = obj.REPV2_Invoice_Genration_MonthlyReport(ddlAcademicYear.SelectedValue, ddlAcadYear.SelectedValue, ddlMonth.SelectedValue);
try
{
if (dtTmp != null && dtTmp.Rows.Count > 0)
{
dtTmp.TableName = "Table1";
DS1.Tables.Add(dtTmp.Copy());
dtTmp = null;
lblErrorMsg.Visible = false;
GVStat.DataSource = SummaryTables();
GVStat.DataBind();
Session["dtdata"] = SummaryTables();
DTdata = (DataTable)Session["dtdata"];
}
else
{
lblErrorMsg.Visible = true;
lblErrorMsg.Text = "Record not Forund For Selected Criteria.";
tblheader.Style.Add("display", "none");
divYear.Visible = true;
}
}
catch (Exception) { }
}
private void FillAcademicYear()
{
oDT = new DataTable();
clsInvoiceGenration objAcadYear = new clsInvoiceGenration();
oDT = objAcadYear.ListAcademicYear(ddlAcademicYear.SelectedValue);
if (oDT != null && oDT.Rows.Count > 0)
{
ListItem li = new ListItem("--Select--", "-1");
ddlAcadYear.Items.Clear();
ddlAcadYear.Items.Add(new ListItem("Select Academic Year", "0"));
ddlAcadYear.DataSource = oDT;
ddlAcadYear.DataTextField = "Year";
ddlAcadYear.DataValueField = "Year";
ddlAcadYear.DataBind();
ddlAcadYear.Items.Insert(0, li);
}
}
