What is best Datareader, Dataset or DataTable?

[pankajprakash]

Hi,

I have created a Datalayer class libery. Now i need to fetch the information from the database and get it in the UI. For that i am using dataset because the fields or size table data will be increase. I just want to know what object should be better for increasing performance of my system. What should i use dataset or datareader or I should fetch the data through the datareader and add into the collection and then return to the UI.

[r035198x]

Hi,

I have created a Datalayer class libery. Now i need to fetch the information from the database and get it in the UI. For that i am using dataset because the fields or size table data will be increase. I just want to know what object should be better for increasing performance of my system. What should i use dataset or datareader or I should fetch the data through the datareader and add into the collection and then return to the UI.

Why don't you read the MSDN specs for them and get their differences. Those are so important that it really is important that you really need to read the specs for them yourself.