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