Features and disadvantages of dataset ?

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 autopostback in dropdownlist in asp net?

0 Answers  


what are configuration files?

0 Answers  


To which side ( server ? client) does the user input data validation occur? Explain the reasons for it?

1 Answers   Siebel,


What does it mean your session has timed out?

0 Answers  


How do you create a master page?

0 Answers  






HI, I have a very important query in mind. Please help me regarding this. I don't have any real time exp in .net. But I have a knowledge it .net. I got an offer from an MNC company as a software developer has I had kept 2 years of fake exp. Even though for this job I had worked hard to crack interview for more then a year. So, I would like to know how difficult it will be for working in real time as I don't have real time exp. Please tell me as soon as possible bcoz I need to join by next month. Can i sustain over there for a longer time or not. And also let me know how to work pressure will be over there. Please help me regarding this. I'm getting tension thinking about it. Thank you.

1 Answers   CTS,


what is the difference b/w .net 1.1 and 2.0 ?

2 Answers   Polaris,


What are the new navigation controls in asp.net 2.0?

0 Answers  


how can u display multi language (i.e english,spanish...) web site?

2 Answers  


What is the difference between trace and debug in asp.net?

0 Answers  


I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.

0 Answers  


What is the difference between application object and session object?

4 Answers   IBS,


Categories