C# Corner
Tech
News
Videos
Forums
Trainings
Books
Events
More
Interviews
Jobs
Live
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
Java
Learn iOS Programming
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
2
Reply
DataReader and Data Set
Shashi Ray
17y
5.3k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
Perfect One more Data reader is not serlizable so it can’t be returned from a webservice where as Dataset is serlizable.
Raj Mishra
17y
0
DataReader 1. The data retrieved through a DataReader is read-only. 2. A DataReader lasts as long as the connection to the database is open. It can’t be persisted in a cookie or a session variable. Data Reader is connection oriented. 3. A DataReader is faster than a Dataset. 4. Data in a DataReader can be read forward only. 5. Can’t update a data source through a DataReader. DataSet 1. The data retrieved through a DataSet is read and write. 2. A DataSet lasts only until the page is reloaded (posted back) unless it’s somehow persisted (for example, in a session variable). Dataset is not connection oriented. 3. A DataSet is slower than a DataReader. 4. Data in a Dataset can be read in both forward and backward direction. 5. Can make changes to data in a DataSet and then upload those changes back to the data source.
Shashi Ray
17y
0
Which controls do not have events?
What is the maximum size of the textbox?
Message