Answer / umamahadevan

DataSet

Data set can be said as a temporary data base which works
on disconnected architecture which stores schema and data
in application memory area..It fetches all data at a time..
DML is entertained here

DataReader

Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any
transaction on them. DataReader will be the best choice
where we need to show the data to the user which requires
no transaction ie reports. Due to DataReader is forward
only we cannot fetch the data randomly. .NET Dataproviders
optimizes the datareaders to handle the huge amount of data.

Answer / satish

The DataSet consists of a collection of DataTable objects
that you can relate to each other with DataRelation
objects. A DataSet can read and write data and schema as
XML documents..The DataReader object is the ADO.NET
counterpart of the read-only, forward-only default ADO
cursor

Answer / payal

1)Data set is work in diconnected architure.
Datareader is work in connected architure.

2)according to speed datareader is faster than dataset.

3)In case of dataset it contain all
tables,relations,constriants which is not in datareader so
that speed of datareader is fast.

4)Data set can persist records where datareader is not.

5)we can save ,update data in dataset and save using
acceptchanges method where datareader cannot.

6)datareader is forward only.where dataset is not.

Answer / kamlesh sharma

The DataSet consists of DataTable objects
that you can relate to each other with DataRelation
objects (and dataset is disconnected data model)

The datareader is connected model(connection must be open
while operation performs)
and it is state forward read only counter part of ADO.net

What is the role of global.asax?

10 Answers   Infosys,

---

Is it possible to create web application with both webforms and mvc?

0 Answers  

---

What is custom tag in web.config ?

2 Answers   Accenture, BirlaSoft,

---

What are main return types supported in Web API?

0 Answers  

---

What is the < machinekey > element and what two ASP.NET technologies is it used for ?

1 Answers  

---

What are validator? Name the validation controls in asp.net? How do you disable them? Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?

0 Answers  

---

I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the clent?s code ?

1 Answers   Microsoft, Satyam, Wipro,

---

What is a windows service?

0 Answers  

---

what are the ihttphandler and ihttphandlerfactory interfaces ?

0 Answers  

---

How to execute a stored procedure.and how to call it form a asp page

2 Answers  

---

Suppose you want an asp.net function (client side) executed on the mouseover event of a button. Where do you add an event handler?

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&#65533;&#65533;&#65533;&#435;&#65533;Â&#65533;&#65533;&#436;&#65533;Ã&#65533;&#65533;&#438;&#65533;Å&#65533;&#65533; al&#65533;&#65533;&#65533;&#435;&#65533;Â&#65533;&#65533;&#436;&#65533;Ã&#65533;&#65533;&#438;&#65533;Å&#65533;&#65533; Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.

0 Answers  

---