Home
Manage Your Code
Snippet: Create a comma delimited list (C#)
Title: Create a comma delimited list Language: C#
Description: This converts rows returned from a reader into a comma-delimited string. Views: 659
Author: John Caruso Date Added: 9/25/2007
Copy Code  
1        private string GetCommaDelimitedList(IDataReader reader)
2        {
3            string list = string.Empty;
4            StringBuilder sb = new StringBuilder();
5
6            while (reader.Read())
7                sb.AppendFormat(",{0}", reader[0]);
8
9            if (sb.Length > 0)
10                list = sb.ToString(1, sb.Length - 1);
11
12            return list;
13        }