private string OwlWorksMemberList() { StringBuilder sb = new StringBuilder(); ExportManager oEM = new ExportManager(); DataTable dt = ExportDataDAL.OwlWorksMemberList(); if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { string strOutput = ""; string strData = ""; DateTime datDate = new DateTime(); string memberId = ""; foreach (DataColumn dc in dt.Columns) { if (dc.Ordinal > 0) { strOutput += "\t"; } strOutput += dc.Caption; } sb.AppendLine(strOutput); foreach (DataRow dr in dt.Rows) { strOutput = ""; foreach (DataColumn dc in dt.Columns) { strData = Convert.ToString(dr[dc.Ordinal]); switch (dc.Caption) { case "BirthDate": case "MemberDate": case "ProbationaryDate": case "ApplicationDate": case "EWLDate": case "WhiteAppApprovedDate": case "WhiteAppReceivedDate": { if (DateTime.TryParse(strData, out datDate) == true) { strData = datDate.ToString("MM/dd/yyyy"); } else { strData = ""; } break; } case "YearsInClub": memberId = Convert.ToString(dr["MemberID"]); strData = oEM.GetYearsInClub(memberId).ToString(); break; default: break; } if (dc.Ordinal > 0) { strOutput += "\t"; } strOutput += strData; } sb.AppendLine(strOutput); } } return(sb.ToString()); }