can i specify row in datatable

Question

how to give row from datatable to datareader or how to specify row in datatable and move between datatable rows?

ahmed fahd · Answer

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 ?

Jignesh Trivedi · Answer

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.