Answered Questions

  • Difference between data set and ADO Record set

    Star Read Best Answer

    Editorial / Best Answer


    • 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.


    • Jan 24th, 2013

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


    • 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...

  • What are the steps to connect to a database?

    Star Read Best Answer

    Editorial / Best Answer


    • 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.


    • 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.