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

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.

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.

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.

Why do we use Option Explicit?

2 Answers   Microsoft,

---

What is asp net application object?

0 Answers  

---

What is data cache in sql server?

0 Answers  

---

Create the Output by mearging 2 tables and taking common column sid from both you should not use database create table and data in it Randomly table 1 sid sname saddress 1 sa ampt 2 na hyd 3 ha hyd table 2 sid dno dname 1 12 stats 2 23 phy 3 12 stats OutPUt sid sname saddress did dname 1 sa ampt 12 stats 2 na hyd 23 phy 3 ha hyd 12 stats

1 Answers  

---

what is AutoEventWireUp and what is the use of This property explain in details?

0 Answers   ITC Infotech,

---

How do I open an ashx file?

0 Answers  

---

Explain Factory pattern?

2 Answers   Microsoft,

---

In SP has contains 10 query,By Using Dataset Object I need to fetch 8th query of records? How?

5 Answers  

---

How to count the number of objects present in a web page? How to count the number of radio buttons in a web page?

0 Answers   HCL,

---

Can you explain the importance of finalize method in .net?

0 Answers  

---

State Management (viewstate, session etc)

2 Answers   Syntel,

---

ASP.NET uses event driven programming model.Justify.

2 Answers  

---