can i specify row in datatable

first thanks for respond my dear
i have rows in sqltable
i have to select the row by it's row index in the base table of sql
so i tried to selec t all the rows to the datatable after that i tried to add the row by it's index in the datatable
do you have another idea or suitable query to do it in sql directly ?

hi,

DataReader object provides a read only, forward only, high performance mechanism to retrieve data from a data store, so i think you cannot move data from datatable to datareader.

but it may possible to move datarow from datareader to datatable.

SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
if (reader.Read())
{
    dt.Load(reader);
}

please refer

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=628
http://www.dotnetcurry.com/ShowArticle.aspx?ID=143

hope this will help you.