private void ShowReport()
{
DataSet ds = new DataSet();
StringBuilder strTable = new StringBuilder();
ObjRPT.UserName = Membership.GetUser().UserName.ToString();
ObjRPT.Fromdate = Convert.ToDateTime(ddlMonth.SelectedValue + "/01/" + ddlYear.SelectedValue);
ObjRPT.Todate = ObjRPT.Fromdate.AddMonths(1);
if (ChkIsBranch.Checked)
{
ObjRPT.IsBranchWise = true;
}
else
{
ObjRPT.IsBranchWise = false;
}
ds = ObjRPT.FetchReport();
if (ds.Tables[0].Rows.Count > 0)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
GrdReport.DataSource = ds;
GrdReport.DataBind();
ds.Dispose();
GrdReport.Dispose();
}
