public void PopulateGrid()
{
clsBALCommon objclsBALComm = new clsBALCommon();
string strCurQuarter = objclsBALComm.GetLatestQuarter();
string strPrevQuarter = PreviousQuarter(strCurQuarter);
clsBALUsers objclsBALUsers = new clsBALUsers();
//DataSet ds = objclsBALUsers.GetNewUsers(strCurQuarter,strPrevQuarter);
DataSet ds = objclsBALUsers.GetNewUsers(ddlQuarter.SelectedItem.Text, strPrevQuarter);
if (ds.Tables[0].Rows.Count > 0)
{
gvNewUsers.DataSource = ds;
gvNewUsers.DataBind();
Session[clsEALSession.ReportUsers] = ds;
btnExport.Visible = true;
}
else
{
gvNewUsers.DataSource = null;
gvNewUsers.DataBind();
Session[clsEALSession.ReportUsers] = null;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "aa", "javascript:alert('No records found');", true);
}
}
public void PopulateGrid()
{
clsBALCommon objclsBALComm = new clsBALCommon();
string strLatestQuarter = objclsBALComm.GetLatestQuarter();
clsBALReports objclsBALReport = new clsBALReports();
DataSet ds = objclsBALReport.GetAllRecievedReports(strLatestQuarter);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["ReportName"] != null)
{
ds.Tables[0].Rows[i]["ReportName"] = Server.HtmlEncode(ds.Tables[0].Rows[i]["ReportName"].ToString());
}
if (ds.Tables[0].Rows[i]["ApplicationName"] != null)
{
ds.Tables[0].Rows[i]["ApplicationName"] = Server.HtmlEncode(ds.Tables[0].Rows[i]["ApplicationName"].ToString());
}
}
gvRecievedReports.DataSource = ds;
gvRecievedReports.DataBind();
Session[clsEALSession.ReportData] = ds;
}