best way to read millions of record from sql server database.i have tried dataset but the performance is not good
Dataset is only really used for editing of data. If you want to only read, use a SqlDataReader and make sure you have the correct indexes on the table where needed
^^^What he said. Basically, the trick is to not deal with millions of records but rather deal with single records in succession. Which is what datareaders are for.
thanks for u r suggestion
but then how do you bind that data to data list if u use datareader
dataList.DataSource = sqlDataREader;
Then remember to close your reader afterwards or use a using() block
thanks a lot dude.