U have to read file and insert it into one datatable
int counter = 0;
string line;
DataTable table = new DataTable();
DataColumn cl = new DataColumn("Text");
table.Columns.Add(cl);
System.IO.StreamReader file =
new System.IO.StreamReader("Filepath/test.txt");
while ((line = file.ReadLine()) != null)
{
DataRow dr = table.NewRow();
Console.WriteLine(line);
dr["Text"] = line;
table.Rows.Add(dr);
counter++;
}
file.Close();
Console.ReadLine();
After inserting data into datatable apply table sorting using select
u can refer this example
DataTable table = new DataTable("Players");
table.Columns.Add(new DataColumn("Size", typeof(int)));
table.Columns.Add(new DataColumn("Sex", typeof(char)));
table.Rows.Add(100, 'f');
table.Rows.Add(235, 'f');
table.Rows.Add(250, 'm');
table.Rows.Add(310, 'm');
table.Rows.Add(150, 'm');
DataRow[] result = table.Select("Size >= 230 AND Sex = 'm'");
foreach (DataRow row in result)
{
Console.WriteLine("{0}, {1}", row[0], row[1]);
}