Foxpro's seeks search in c# datatable

Hi Amit Mohanty,

Thanks for sharing,

Let me check

Regards

Shehzad

Check this

// assume you have a DataTable with a column named "Id" that is indexed
DataTable table = new DataTable();
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Name", typeof(string));
table.Rows.Add(1, "Amit");
table.Rows.Add(2, "Alok");
table.Rows.Add(3, "Nagaraj");
table.Rows.Add(4, "Ranjit");

// Create an index on the "Id" column
DataView dataView = new DataView(table);
dataView.Sort = "Id";

// Perform a binary search for the row with Id = 3
int searchId = 3;
int index = dataView.Find(searchId);
if (index == -1)
    Console.WriteLine("Row with Id = {0} not found", searchId);
else
{
    DataRow row = table.Rows[index];
    Console.WriteLine("Found row with Id = {0} and Name = {1}", row["Id"], row["Name"]);
}

Hi Naimish Makwana,

Thanks for sharing,

Actually .Select will scan whole table to select record based on criteria.

I am looking for index based binary search on in-memory datatable.

Regards

Shehzad

Hello Shehzad,

You can use DataTable.Select() method.

The Select() method returns an array of DataRow objects that match a specified condition.

Example : 

DataRow[] rows = dt.Select("ID = 2");

Or Refer below link

https://stackoverflow.com/a/16767083/3054222

Thanks

Naimish Makwana