using System.Collections.Generic;
static void Main(string[] args)
DataTable dt = new DataTable();
string csvData = File.ReadAllText(@"C:\Users\HP\Desktop\RPA.csv");
foreach (string row in csvData.Split('\n'))
if (!string.IsNullOrEmpty(row))
foreach (string cell in row.Split(','))
if (!string.IsNullOrEmpty(row))
foreach (string cell in row.Split(','))
dt.Rows[dt.Rows.Count - 1][i] = cell;
if (!string.IsNullOrEmpty(row))
foreach (string cell in row.Split(','))
dt.Rows[dt.Rows.Count - 1][i] = cell;
foreach (DataRow dataRow in dt.Rows)
foreach (var item in dataRow.ItemArray)
DataRow[] rows = dt.Select("Name = Rakesh");