Programming Posts

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

using System;
using System.Linq;
using System.Data;

namespace DataTableColumnCommaSeperated
{
    class Program
    {
        static void Main(string[] args)
        {
            //Printing Dictionary
            Console.WriteLine("\n*** www.programmingposts.com ***\n");
            Console.WriteLine("\n>>> C# Program to Get Comma Separated String from DataTable Column Values <<<\n");

            DataTable dt = getDepartments();

            //Generating string array from DataTable Column DeptId
            string[] strArr = dt.AsEnumerable().Select(r => Convert.ToString(r["DeptId"])).ToArray();

            //Generating CommaSeperated string from String Array
            string strCommaSeperated = string.Join(",", strArr);

            //Generating CommaSeperated string with single quoted values from String Array
            string strCommaSeperatedWithSingleQuotes = string.Join(",", strArr.Select(r => "'" + r + "'"));

            Console.WriteLine("Printing Comma Seperated String ");
            Console.WriteLine(strCommaSeperated);

            Console.WriteLine("Printing Comma Seperated String with single quoted values");
            Console.WriteLine(strCommaSeperatedWithSingleQuotes);

            Console.ReadLine();
        }

        /// <summary>
        /// returns sample DataTable
        /// </summary>
        /// <returns></returns>
        private static DataTable getDepartments()
        {
            DataTable dtDept = new DataTable();
            dtDept.Columns.Add("DeptId", typeof(Int32));
            dtDept.Columns.Add("DeptName", typeof(String));
            dtDept.Columns.Add("DeptEmpCount", typeof(Int32));
            DataRow dr;

            for (int i = 1; i <= 5; i++)
            {
                dr = dtDept.NewRow();
                dr["DeptId"] = i;
                dr["DeptName"] = "Dept" + i.ToString();
                dr["DeptEmpCount"] = (i * 10);
                dtDept.Rows.Add(dr);
            }
            return dtDept;
        }
    }
}