Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Could you help me understand in what conditions should we use DataReader or DataSet? [Resolved]
on 7/1/2011 |
| Views : 1342 | Status :
| Replies : 1
Write New Post
Un Answered Posts
Could you help me understand in what conditions should we use DataReader or DataSet?
Reply with Attachment
* when we are using database operations only for taking data and displaying the resords and doesnot involve any insertion and updation and deletion statements and other manipulations.that is when we are reading the data only ,then we have to use the datareader.data reader supports connected architecture,it is forward only.here connected architecture means the database connection is open until the dabse operation are performed.
*data adapter is used with insertion,updation,deletion statement and using it as a return type from a web service,we have to use the data set.data adapter automatically opens and closes the connectin when required.
Have a nice day.....srinath kaithoju
, if this helps please
Mark As Answer
Login to post response
ChEaP K-i-T-c-H-e-N-s FoR SaLe Trafford
select checkbox in datalist with out select link
what scenario using code first or entity framework
How to Fix this Issue Permanently in Sql Server
How to Restrict following Records in sql server
What is The Use of Method Hiding In C# although we having method overriding ?
Count the hit of website
how to compile two objects having same class in c# ?