using System.Collections.Generic;
using System.Data.DataSetExtensions;
public static void Main()
DataTable filteredVC = new DataTable();
DataTable dt23 = new DataTable("Table1");
dt23.Columns.Add("Country", typeof(string));
dt23.Rows.Add(DBNull.Value);
var filteredrows = dt23.AsEnumerable().Where(r => !(string.IsNullOrEmpty(r.Field<string>("Country"))) && (r.Field<string>("Country").ToLower() == "ind"));
filteredVC = filteredrows.ToList().CopyToDataTable();
foreach(DataRow dtrow in filteredVC.AsEnumerable())
Console.WriteLine(dtrow["Country"]);