Features and disadvantages of dataset ?

Question Posted / geethu

4 Answers
18155 Views
Interlink, Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Features and disadvantages of dataset ?..

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

Features and disadvantages of dataset ?..

Answer / ashbin

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

Features and disadvantages of dataset ?..

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

Features and disadvantages of dataset ?..

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

Post New Answer

More ASP.NET Interview Questions

What is the use of location tag in web.config file

2 Answers Karur Vysya Bank KVB,

What do you mean by caching in asp.net?

0 Answers

What are the data controls available in asp.net?

0 Answers

If I'm developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users?

7 Answers Syntax Softtech,

What are the 3 types of web?

0 Answers

What's the difference between Page.RegisterClientScriptBlock and Page.RegisterStartupScript ?

1 Answers

What Are Different Types of Debbugers

2 Answers Accenture, TCS, Wipro,

Which is better viewstate or session?

0 Answers

What are the different validators in asp.net?

0 Answers

What is a form tag?