private string BlueBookRosterList() { StringBuilder sb = new StringBuilder(); ExportManager oEM = new ExportManager(); DataTable dt = ExportDataDAL.BlueBookRosterList(); if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string strOutput = ""; DateTime dtMemberDate; string memberDate = ""; if (DateTime.TryParse(Convert.ToString(dr["MemberDate"]), out dtMemberDate) == true) { memberDate = dtMemberDate.ToString("MMMM d, yyyy"); } strOutput = (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : ""); strOutput += "\t" + Convert.ToString(dr["ReportName"]).Trim(); strOutput += Convert.ToString(dr["MembershipCategoryID"]) == "9" ? " " + Convert.ToString(dr["MilitaryServiceText"]) : (" " + Convert.ToString(dr["MembershipCategoryText"])) + (Convert.ToString(dr["MemberText"]) == "" ? "" : " " + Convert.ToString(dr["MemberText"])); strOutput += "\t" + memberDate; strOutput += "\t" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"])); // dum line of code why do we need to check? - Copied from BCIS strOutput += "\t"; sb.AppendLine(strOutput); } } return(sb.ToString()); }