Hello
which scenario we should use connected mode data base connection .
i have mostly use SqlDataAdptor for get data from data base .But i want to know to which scenario we should sqldatareader
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vincent Maverick DuranoPosted May 2, 2015, 8:54 AM
Use DataReader when you want to fetch data in read-only mode. By read only i mean if you don't need to do anything with the data like edit, update or delete. DataReader is perfect choice for simply displaying data in the page and nothing more.
I would suggest you to give this article a read: https://msdn.microsoft.com/en-us/magazine/cc188717.aspx