Best way to read millions of record from sql server very fast

[abhijit_g23]

best way to read millions of record from sql server database.i have tried dataset but the performance is not good

[NightStalker]

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

[wwb_99]

^^^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.

[abhijit_g23]

@NightStalker_DNS

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

thanks for u r suggestion
but then how do you bind that data to data list if u use datareader

[NightStalker]

dataList.DataSource = sqlDataREader;
dataList.DataBind();

Then remember to close your reader afterwards or use a using() block

[abhijit_g23]

@NightStalker_DNS

dataList.DataSource = sqlDataREader;
dataList.DataBind();

Then remember to close your reader afterwards or use a using() block

thanks a lot dude.