protected void lnkOrgDump_Click(object sender, EventArgs e) { //Create Tempory Table DataTable dtTemp = new DataTable(); //Creating Header Row dtTemp.Columns.Add("OrganizationName"); dtTemp.Columns.Add("CX_Code"); dtTemp.Columns.Add("MeetingDay"); dtTemp.Columns.Add("Organization.MeetingFrequency"); dtTemp.Columns.Add("MeetingTime"); dtTemp.Columns.Add("MeetingBuilding"); dtTemp.Columns.Add("MeetingRoom"); dtTemp.Columns.Add("DateProposed"); dtTemp.Columns.Add("ProposalAccepted"); dtTemp.Columns.Add("ProposalDenied"); dtTemp.Columns.Add("ConstitutionSubmitted"); dtTemp.Columns.Add("ConstitutionAccepted"); dtTemp.Columns.Add("RegistrarApproval"); dtTemp.Columns.Add("RequirementsMet"); dtTemp.Columns.Add("RequirementsMetDate"); dtTemp.Columns.Add("ConstitutionDenied"); dtTemp.Columns.Add("ConstitutionUpdated"); dtTemp.Columns.Add("CategoryName"); dtTemp.Columns.Add("StatusName"); dtTemp.Columns.Add("StartDate"); dtTemp.Columns.Add("EndDate"); dtTemp.Columns.Add("Carroll_ID"); dtTemp.Columns.Add("LastName"); dtTemp.Columns.Add("FirstName"); dtTemp.Columns.Add("MemberName"); dtTemp.Columns.Add("BeginDate"); dtTemp.Columns.Add("EndDate1"); dtTemp.Columns.Add("Session"); dtTemp.Columns.Add("Year"); dtTemp.Columns.Add("ClassOF"); dtTemp.Columns.Add("Email"); dtTemp.Columns.Add("PreferredPhone"); dtTemp.Columns.Add("Active"); dtTemp.Columns.Add("Gender"); dtTemp.Columns.Add("Major"); dtTemp.Columns.Add("Major2"); dtTemp.Columns.Add("CertifiedDriver"); dtTemp.Columns.Add("ApprovedDriver"); dtTemp.Columns.Add("GPABoard"); dtTemp.Columns.Add("GPAOrg"); dtTemp.Columns.Add("GreekGPA"); //double dSalary; //DateTime dtDate; DataRow drAddItem; var query = dataContext.sp_GetOrgAndStudentDump(); //for (int i = 0; i < dtOriginal.Rows.Count; i++) int i = 0; foreach (var r in query) { drAddItem = dtTemp.NewRow(); drAddItem[0] = r.OrganizationName; drAddItem[1] = r.CX_Code.ToString(); drAddItem[2] = r.MeetingDay; drAddItem[3] = r.MeetingFrequency; drAddItem[4] = r.MeetingTime; drAddItem[5] = r.MeetingBuilding; drAddItem[6] = r.MeetingRoom; drAddItem[7] = r.DateProposed == null ? string.Empty : Convert.ToDateTime(r.DateProposed).ToShortDateString(); drAddItem[8] = r.ProposalAccepted == null ? string.Empty : Convert.ToDateTime(r.ProposalAccepted).ToShortDateString(); drAddItem[9] = r.ProposalDenied == null ? string.Empty : Convert.ToDateTime(r.ProposalDenied).ToShortDateString(); drAddItem[10] = r.ConstitutionSubmitted == null ? string.Empty : Convert.ToDateTime(r.ConstitutionSubmitted).ToShortDateString(); drAddItem[11] = r.ConstitutionAccepted == null ? string.Empty : Convert.ToDateTime(r.ConstitutionAccepted).ToShortDateString(); drAddItem[12] = r.RegistrarApproval == null ? string.Empty : Convert.ToDateTime(r.RegistrarApproval).ToShortDateString(); drAddItem[13] = r.RequirementsMet; drAddItem[14] = r.RequirementsMetDate == null ? string.Empty : Convert.ToDateTime(r.RequirementsMetDate).ToShortDateString(); drAddItem[15] = r.ConstitutionDenied == null ? string.Empty : Convert.ToDateTime(r.ConstitutionDenied).ToShortDateString(); drAddItem[16] = r.ConstitutionUpdated == null ? string.Empty : Convert.ToDateTime(r.ConstitutionUpdated).ToShortDateString(); drAddItem[17] = r.CategoryName; drAddItem[18] = r.StatusName; drAddItem[19] = r.StartDate == null ? string.Empty : Convert.ToDateTime(r.StartDate).ToShortDateString(); drAddItem[20] = r.EndDate == null ? string.Empty : Convert.ToDateTime(r.EndDate).ToShortDateString(); drAddItem[21] = r.Carroll_ID.ToString(); drAddItem[22] = r.LastName; drAddItem[23] = r.FirstName; drAddItem[24] = r.MemberName; drAddItem[25] = r.BeginDate == null ? string.Empty : Convert.ToDateTime(r.BeginDate).ToShortDateString(); drAddItem[26] = r.EndDate1 == null ? string.Empty : Convert.ToDateTime(r.EndDate1).ToShortDateString(); drAddItem[27] = r.Session; drAddItem[28] = r.Year; drAddItem[29] = r.ClassOF; drAddItem[30] = r.Email; drAddItem[31] = r.PreferredPhone; drAddItem[32] = r.Active; if (r.Gender == true) { drAddItem[33] = "Male"; } else { drAddItem[33] = "Female"; } drAddItem[34] = r.Major; drAddItem[35] = r.Major2; drAddItem[36] = r.CertifiedDriver; drAddItem[37] = r.ApprovedDriver; drAddItem[38] = r.GPABoard; drAddItem[39] = r.GPAOrg; drAddItem[40] = r.GreekGPA; dtTemp.Rows.Add(drAddItem); ++i; } Export.ExportToExcel(dtTemp, "OrganizationDump.xlsx"); }