Read Best Answer

Editorial / Best Answer

ramakrishnag1982  

 Profile Answers by ramakrishnag1982 Questions by ramakrishnag1982

• Member Since Nov-2006 | Aug 12th, 2007

---

1) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.

2) A DataSet is designed to work without any continuing connection to the original data source; Recordset maintains the contentious connection with the original data source.

3) There's no concept of cursor types in a DataSet, They are bulk loaded, while Recordset work with cursors and they are loaded on demand.

4) DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.

Kishore

• Jan 24th, 2013

Please need some more related information about the each topic..It is not sufficient to answer in Interviews.

sathin

 Profile Answers by sathin Questions by sathin

• Oct 29th, 2009

To get the data from a database and put it on a data control In ADO they used recordset In ADO.Net they used dataset Record set is a connection oriented architecture whereas dataset supports a c...

Improve Answer

Read Best Answer

Editorial / Best Answer

nishant2200  

 Profile Answers by nishant2200 Questions by nishant2200

• Member Since Jan-2007 | Jan 7th, 2007

---

1. Create a connection. This requires a connection string, which can be given declaratively or put in a well defined place like the .config files. Advantage of keeping in .config files is that it enables use of Connection Pooling by .Net framework, else even one small change in connection string will cause CLR to think it's not the same connection and will instantiate new connection for other request.

2. Open the connection and keep it open until done, typically done as using (con) { //use }

3. If using connected data model, create a SqlCommand object, decorate it with desired command, command type (stored procedure for eg), add any parameters and their values to the command, and then consume the command by using ExcuteReader or ExecuteScalar. In case of ExecuteReader, we will get back a handle to a fast-forward, read only pointer to the recordset. We can also decorate Command object with multiple recordsets in 2.0 and execute one by one (MARS - Multiple Active Record Sets)

4. If using disconnected data model, create a DataAdapter object, decorate it with desired SELECT, INSERT, UPDATE, DELETE commands, add parameters as necessary and then fill up a DataSet or DataTable using the DataAdapter. Subsequent  SQL can be executed using insert, update, delete commands on the dataset.

ushalakshmi

 Profile Answers by ushalakshmi Questions by ushalakshmi

• Apr 17th, 2008

TO Connect to a DatabaseFirst we need to have a namespace like System.Data.Sqlclientthen connect to database as follows1.Create connection using SqlConnection Sqlconnection con=new sqlconnection(...

johnjustin

 Profile Answers by johnjustin Questions by johnjustin

• Apr 8th, 2008

1. Implements the base class for data access2. Create a connection3. Open that connection4. Create a data reader and execute the data reader with proper sql statements You can get the values of the record using the methods GetString, GetInt32 ....etc.

Improve Answer