private string SquirrelMemberList() { StringBuilder sb = new StringBuilder(); ExportManager oEM = new ExportManager(); DataTable dt = ExportDataDAL.SquirrelMemberList(); if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string strOutput = ""; string memberNumber = Convert.ToString(dr["MemberNumber"]) == "" ? "" : (Convert.ToString(dr["MemberNumber"]) + new string(' ', 8)); string lastNameSuffix = (Convert.ToString(dr["LastName"]) == "" ? "" : Convert.ToString(dr["LastName"])) + " " + (Convert.ToString(dr["Suffix"]) == "" ? "" : Convert.ToString(dr["Suffix"])) + new string(' ', 15); string firstMiddle = (Convert.ToString(dr["FirstName"]) == "" ? "" : Convert.ToString(dr["FirstName"])) + " " + (Convert.ToString(dr["MiddleName"]) == "" ? "" : Convert.ToString(dr["MiddleName"])) + new string(' ', 20); strOutput = memberNumber.Substring(0, 8) + "0"; strOutput += lastNameSuffix.Substring(0, 15); strOutput += firstMiddle.Substring(0, 20) + "A0" + new string(' ', 59) + "0"; sb.AppendLine(strOutput); } } return(sb.ToString()); }