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