I want to get a specific row on an asp.net DataTable and move it to be the first one onto this DataTable base on a column column1 value. My Datatable dt1 is populated via a DB query and the value to search is via another query from another DB so I don't know the value to search at the dt1 select time.

// I use this variable to search into
// DataTable
string valueToSearch = "some value";

So I need to search the value some value into my DataTable in the column column1. and then move the entire row to the first position.

Thank you.

Edit
Report