protected void ButtonCSV_Click(object sender, EventArgs e) { try { #region Session Declaration //Palash string reportname = Convert.ToString(Session["reportname"]); string numberOfRows = Convert.ToString(Session["numberOfRows"]); string pageIndex = Convert.ToString(Session["pageIndex"]); string sortColumnName = Convert.ToString(Session["sortColumnName"]); string sortOrderBy = Convert.ToString(Session["sortOrderBy"]); string BannerID = Convert.ToString(Session["BannerID"]); string NAME = Convert.ToString(Session["NAME"]); string StudentOID = Convert.ToString(Session["StudentOID"]); string TERM = Convert.ToString(Session["TERM"]); string FullPart = Convert.ToString(Session["FullPart"]); string GPA = Convert.ToString(Session["GPA"]); string CreditAttempted = Convert.ToString(Session["CreditAttempted"]); string EarnedCredit = Convert.ToString(Session["EarnedCredit"]); string Prealgebra = Convert.ToString(Session["Prealgebra"]); string Algebra = Convert.ToString(Session["Algebra"]); string Writting = Convert.ToString(Session["Writting"]); string Reading = Convert.ToString(Session["Reading"]); string English = Convert.ToString(Session["English"]); string Math = Convert.ToString(Session["Math"]); string ReadingScore = Convert.ToString(Session["ReadingScore"]); string ScienceScore = Convert.ToString(Session["ScienceScore"]); DateTime TestingDate = Convert.ToDateTime(Session["TestingDate"]); string HighSchool = Convert.ToString(Session["HighSchool"]); DateTime HS_GRAD_DATE = Convert.ToDateTime(Session["HS_GRAD_DATE"]); string ADDR1 = Convert.ToString(Session["ADDR1"]); string ADDR2 = Convert.ToString(Session["ADDR2"]); string ADDR3 = Convert.ToString(Session["ADDR3"]); string CITY = Convert.ToString(Session["CITY"]); string STATE = Convert.ToString(Session["STATE"]); string ZIP = Convert.ToString(Session["ZIP"]); DateTime ImportDate = Convert.ToDateTime(Session["ImportDate"]); string PPGMIND = Convert.ToString(Session["PPGMIND"]); string MAJOR = Convert.ToString(Session["MAJOR"]); string Email = Convert.ToString(Session["Email"]); string Phone = Convert.ToString(Session["Phone"]); //Palash #endregion int totalRecords; string aoid = Request.QueryString["aid"].ToString(); string SortOrSearchFlag = "Search"; string query = Hiddenquery.Value; string strParameter = HttpUtility.UrlDecode(query); string MultipleSearch = ""; string SearchColName = ""; string SearchVal = ""; SortOrSearchFlag = "Search"; MultipleSearch = SearchColName; if (!strParameter.Equals(string.Empty)) { foreach (string str in strParameter.Substring(1).Split('&')) { string[] str1 = str.Split('='); if (str1.Length > 0) { MultipleSearch = MultipleSearch + str1[0] + ","; SearchVal = SearchVal + str1[1] + ","; } } MultipleSearch = MultipleSearch.Substring(0, MultipleSearch.Length - 1); SearchVal = SearchVal.Substring(0, SearchVal.Length - 1); } Assessment ass = new Assessment(); string output = ass.GetAssessmentResult(Convert .ToInt32 ( aoid), numberOfRows, pageIndex, out totalRecords, MultipleSearch, SearchVal, sortColumnName, sortOrderBy, BannerID, MAJOR, NAME, SortOrSearchFlag); //Collection<Student> students = SearchStudent(reportname, numberOfRows, pageIndex, sortColumnName, sortOrderBy, out totalRecords, Convert.ToInt32("0"), request["NAME"], request["StudentOID"], request["TERM"], request["FullPart"], Convert.ToDouble(request["GPA"]), Convert.ToDouble(request["CreditAttempted"]), Convert.ToDouble(request["EarnedCredit"]), request["Prealgebra"], request["Algebra"], request["Writting"], request["Reading"], request["English"], request["Math"], request["ReadingScore"], request["ScienceScore"], Convert.ToDateTime(request["TestingDate"]), request["HighSchool"], Convert.ToDateTime(request["HS_GRAD_DATE"]), request["ADDR1"], request["ADDR2"], request["ADDR3"], request["CITY"], request["STATE"], request["ZIP"], Convert.ToDateTime(request["ImportDate"]), request["PPGMIND"], request["MAJOR"], request["Email"], request["Phone"]); Collection<Student> students = SearchStudent(reportname, numberOfRows, pageIndex, sortColumnName, sortOrderBy, out totalRecords, Convert.ToInt32("0"), NAME, StudentOID, TERM, FullPart, GPA, CreditAttempted, EarnedCredit, Prealgebra, Algebra, Writting, Reading, English, Math, ReadingScore, ScienceScore, TestingDate, HighSchool, HS_GRAD_DATE, ADDR1, ADDR2, ADDR3, CITY, STATE, ZIP, ImportDate, PPGMIND, MAJOR, Email, Phone); DataTable studentReportDt = this.ConvertListToDataTable(students); string reportOIDStr = Request.QueryString["ReportOID"].ToString(); ExportToExcel.ExportToSpreadsheet(studentReportDt, reportOIDStr, "CSV"); } catch (Exception ex) { } }