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 : 1330 | 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
How to close the respective modal dialog when switch over to other modal dialog without overlapping
how to save and use variable in jquery
How to add Parameterized Image in RDLC report?
How to Solve this Hosting Issues.
How do i get payment status in redirect page using bitpay?
What is autocomplete in input tag ?
How to pass parameters from html page to constructor of a class in C#
DropDownList Validation not working inside Gridview