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 |
What are HTTP handlers in ASP.NET?
Asp.net and asp ? differences?
Explain how to prepare culture-specific formatting in .net.
Is global asax mandatory?
What is the best Macanism to clear the Cache in asp.net
Explain serialization and deserialization?
What is the base class from which web forms are inherited?
Explain different types of validators in asp.net?
What are the types of validation in asp net?
please can any describe 'Master Page' in ASP.Net 2.0
Explain the differences between managed and unmanaged code?
How will you write a web service for secure socket layer? What is secure socket? Have you done any socket programming? What is single thread and multi thread? What are the differences between .NET 1.1 and .NET 2.2? What is the command to connect to a StoredProcedure? How many types of Adapters are available in ADO.NET? Why DataAdapters are important? What is DataSet? It's important to compile the ASP.NET application before using it? What protocol you use to stream the audio and Video data? What are the different kind of network protocols? Write how will you connect to a database using DataSet? Why we use AJAX? What AJAX can do which JavaScript can't do? In a page using Windows Media API, if we press a button and in succession quickly press another button, what do you think will happen? Will the application wait for the first button response and then execute the second one or directly second button command will execute. What is the architecture of your application? What is connection pooling in SQL? Tell some functions of Windows Media API? How you will detect, whether the ActiveX is installed in the system before accessing it? What are validators are available in ASP.NET? What are the basic concepts of OOPS? What is abstraction?
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)