Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

explain connection less and with connection?diference
between data reader,data set,data adapter? can we use data
reader,data set in a single application? if yes explain
with simple code,if no explain?

Question Posted / raghu_113

Answers were Sorted based on User's Feedback



explain connection less and with connection?diference between data reader,data set,data adapter? c..

Answer / kavitha

in connection less architecture connection to the database
need not be persist till the end of the process.after
fetching the data form database it is pushed in database
object called dataset and connection object need not to be
persist and its closed. and the data will be available from
the dataset.


data reader - ADO.NET DataReader to retrieve a read-only,
forward-only stream of data from a database. Using the
DataReader can increase application performance and reduce
system overhead because only one row at a time is ever in
memory.Connection to the database is maintained till the
end.it is simply like an ado object.it contains only one
table at a time.it is much faster than dataset.


dataset - is used to hold the data from the database along
with their relation. it is connection less object.it also
persist the value which are retrieved form the database.
it is a bit bulky object.it gives both forward and backward
access to data. it uses XML.it can consist more than one
table.we have atrribtes for the dataset


dataset
datatable
datarow
datacolumn

an adapter object is used to fill the data from the database.

dataadapter - dataadapter is a database object which
used to fill the dataset object with data from the database.

Is This Answer Correct ?    35 Yes 2 No

explain connection less and with connection?diference between data reader,data set,data adapter? c..

Answer / prabhat saxena(lmp)

above exp. is excellent for connection less and connection
oriented.
data adapter performs almost five steps
1- open(create)connection
2- fatch the data
3- generate xml file of data
4- fill xml data file into the dataset by fill()method
5- closed the connection.

Is This Answer Correct ?    19 Yes 0 No

explain connection less and with connection?diference between data reader,data set,data adapter? c..

Answer / bapu thore

connection less vs connection oriented

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

5 Answers   HCL,

What is dataset object? Explain the various objects in dataset.

0 Answers  

How to add an aggregate column?

0 Answers  

What is the use of Dataview?

0 Answers  

Why is ADO.NET serialization slower than ADO ?

0 Answers   NA,

What is XML serialization

0 Answers   Digital GlobalSoft,

what is the syntax code for oldb to connect oracle

3 Answers   IBM,

Explain how to pass multiple tables in datasets simultaneously?

0 Answers  

Which keyword is used to accept variable number of parameters?

0 Answers  

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

How do you update database through dataset?

0 Answers  

Is it possible to load multiple tables in a Dataset?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories