Difference between datareader and dataset ?
Answers were Sorted based on User's Feedback
Answer / j_baghla
Datareader is used for readonly-forward only data.We can't
update the database by datareader.We can store more than
one resultset in the datareader so we can't create the
relations between the tables.There is no record pointer to
read the data in the datareader.We can read the datat from
the datareader by using reader method.
Dataset can contain more than one table and we can create
relationships among those tables.we can read the data by
for each loop.Dataset can contain data from different
datasources like oracle,sqlserver,access etc.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / jagadeesh naidu
Datareader is used for readonly-forward only data.We can't
update the database by datareader.We can store more than
one resultset in the datareader so we can't create the
relations between the tables.There is no record pointer to
read the data in the datareader.We can read the datat from
the datareader by using reader method.
Dataset can contain more than one table and we can create
relationships among those tables.we can read the data by
for each loop.Dataset can contain data from different
datasources like oracle,sqlserver,access etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anita
datareader is component of connected environment is used to
retreive the value from datasource ,on the otherhand dataset
is the component of disconnected environment.it contain
datatable s .
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / harsh v m
DataReader acts like Readerset of ADO.In ADO.NET we make
use of Datasets & in ADO, Readersets are used.
DataReader is read only,forward only type and Dataset is
disconnected type that can store more than one table.Hence
Datareaders are used for reading some data from database
only,but not for updating the data.Whereas Datasets can be
used for later purpose.
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the question mark in a url?
What is a web server? What are the load limits in it?
i have a register form & in that form i have a 2 textboxes for entering name&age.my doubt is that how can i provide error message like "invalid entry" when user enter a invalid name/age(eg:user enter name as #%%%##daff,and age as 1000.)in that textboxes.I want code.
Which is better viewstate or session?
What is the difference between ASP and ASP.NET?
4 Answers Sans Pareil IT Services, TCS,
About friend and Protected friend ?
Define session in asp.net.
Can the validation occurs in server-side or client-side? If the validation occurs why should we do?
Caching techniques in .NET?
Which is the namespace used to write error message in event Log File?
what is generics?
What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)