Features and disadvantages of dataset ?
Answers were Sorted based on User's Feedback
Answer / dinesh sharma
Adv:
1)Dataset Is Disconnected Apporah
2)Dataset Is serialized Object
3)Dataset can contained More Then One Table
and We Can Done Any operation like relation ship
set,Primary Key ,retrive any colums.
Dis:
1) It is Slow then Datareader.
2) it is havey Object. so it take more space
3) Some Time it Will Not Satisafied The ACID Prop. Proprly
| Is This Answer Correct ? | 13 Yes | 0 No |
DisAdvantages:
1.Data is loaded into DataSet if other Client will update
the data same time in DBServer the updated Data will not
reflect automatically in DataSet.
2.Slower in comparision to DataReader
Advantages:
1.No network Traffic while communicating DBServer.
2.Mapping of Mutiple tables in DataSet make ,Relations
also.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / j_baghla
Features:-
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.
Disadvantages:-
It is somewhat like local database.In other words if we
want to update the values thru dataset into database then
first we have to update the values in the datatset then we
will update the DB by calling update method of dataset
which is quite long task.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kannan
Features:
DataSet is XML oriented, so serailization is possible.
Disconnected architecture.
Disadvantages:
Occupies more space. Because Column and its collection, Row
and its collection, Constraint collection.
If not for updating database after modification than avoid
using dataset.
| Is This Answer Correct ? | 3 Yes | 1 No |
Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
what is the exact purpose of http handlers and interfaces?
Why do we use datasource in asp.net?
What are the action filters available in asp.net mvc
Describe a bubbled event and how it is used ?
How would you implement inheritance using c#?
If iam developing an application that must accomodate multiple security levels though secure login and my asp.net web appplication is spanned across three web-servers (using round-robbin load balancing) what would be the best approach to maintain login-in state for the users?
What is difference between machine.config and Web.Config?
4 Answers Accenture, BirlaSoft, Le Logiciel,
What is data control in asp.net?
What is diff. Between abstract class and an interface?
I have a method written in WebForm (means .aspx page) & now I want to call this method in WebUserControl (means .ascx page) what should I have to do?
How can you register a custom server control to a web page?
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)