using System.Collections.Generic;
public static void Main()
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("CID", typeof(string));
dt.Columns.Add("CountryName", typeof(string));
dt.Rows.Add(new object[] { 1, "0000", "UK" });
dt.Rows.Add(new object[] { 2, "1111", "JAPAN" });
dt.Rows.Add(new object[] { 3, "2222", "CHINA" });
dt.Rows.Add(new object[] { 4, "3333", "SRI LANKA" });
dt.Rows.Add(new object[] { 5, "4444", "AUSI" });
dt.Rows.Add(new object[] { 6, "5555", "USA" });
Dictionary<string, string> dict = GetDictionary(dt);
foreach (KeyValuePair<string, string> author in dict)
Console.WriteLine("Key: {0}, Value: {1}",
author.Key, author.Value);
public static Dictionary<string, string> GetDictionary(DataTable dt)
.ToDictionary<DataRow, string, string>(row => row.Field<string>(1),
row => row.Field<string>(2));