private string BlueBookListOf50List() { StringBuilder sb = new StringBuilder(); ExportManager oEM = new ExportManager(); DataTable dt = ExportDataDAL.BlueBookListOf50List(); 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 = "/1" + (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : ""); strOutput += "/2" + Convert.ToString(dr["ReportName"]).Trim(); strOutput += "/3" + memberDate; strOutput += "/4" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"])); strOutput += "/5"; sb.AppendLine(strOutput); } } return(sb.ToString()); }