interview questions

Recordset contains result of a database query, It is not used to display the data from the database. We use recordset in ADO technology.

Datagrid is used to only display data from database not to contain data.


Above answer was rated as good by the following members:
satyanis1
Sorting Options
Page 1 of 2 « First 1 2 > Last »
December 02, 2005 00:42:15 #1
praveenkatragadda Member Since: December 2005 Contribution: 1
RE: what is main difference between ado and ado.net
ado is connected mode and ado.net is disconnected mode

Is this answer useful? Yes | No
December 21, 2005 02:12:01 #2
sachin
Qn
Please tell me the diff b/w recordset and datagrid

Is this answer useful? Yes | No
December 30, 2005 05:12:21 #3
Suvesh Sonker
RE: what is main difference between ado and ado.net

ADO and ADO.NET are different in several ways:

· ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time. This is barring, of course, you programming special routines to pull all your data into temporary tables.

ADO.NET uses data in a disconnected fashion. When you access data, ADO.NET makes a copy of the data using XML. ADO.NET only holds the connection open long enough to either pull down the data or to make any requested updates. This makes ADO.NET efficient to use for Web applications. It's also decent for desktop applications.

· ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data, although you can join tables to create a new set of records. With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object will actually allow you to store the relational model of your database. This allows you to pull up customers and their orders, accessing/updating the data in each related table individually.

· ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors. In ADO.NET, classes actually handle the work of cursors. This allows the developer to decide which is best. For Internet development, this is crucial in creating efficient applications.

· Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate your data using XML as the primary means. This is nice when you are working with other business applications and also helps when you are working with firewalls because data is passed as HTML and XML.


Is this answer useful? Yes | No
February 08, 2006 16:08:02 #4
Shree Member Since: October 2005 Contribution: 3
RE: what is main difference between ado and ado.net
There is one more point I would like to add:In Ado.net, Data Binding (linking data source to data consumer) is possible with the help of DataGrids and DataLists.This makes organizing and displaying data faster and more efficient.

Is this answer useful? Yes | No
July 22, 2006 06:50:19 #5
somesh
RE: what is main difference between ado and ado.net
ADO's are stateful(TCP/IP), ADO.NET's are stateless(internet)

Is this answer useful? Yes | No
September 02, 2006 00:23:05 #6
meezan
RE: what is main difference between ado and ado.net

Recordset contains result of a database query, It is not used to display the data from the database. We use recordset in ADO technology.

Datagrid is used to only display data from database not to contain data.


Is this answer useful? Yes | No Answer is useful 1 Answer is not useful 0 Overall Rating: +1
September 05, 2006 00:50:30 #7
Murugan
RE: what is main difference between ado and ado.net
1. Ado.net is a disconnected architecture

Ado is not support to disconnected architecture

2. ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors.

3. Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate your data using XML as the primary means



Is this answer useful? Yes | No
December 21, 2006 02:20:45 #8
vikram,dhaval,saurabh
RE: what is main difference between ado and ado.net
ADO works with connected Architechture and ADO.net works with Both Connected as well as disconnected.Ado.Net navigate data with XML. ADO Not nevigate.

Is this answer useful? Yes | No
March 14, 2007 14:27:52 #9
Praveen Gorantla
RE: what is main difference between ado and ado.net
Table lockings is Possible in ADO and Table Lockings is not Possible in ADO.Net

Is this answer useful? Yes | No
March 31, 2007 22:33:53 #10
galaxy
RE: what is main difference between ado and ado.net


I need a clarrification. If ADO.NET is disconnected, ie., if data from database is moved to DATASET using DATAADAPTER's FILL method, if any other user / from some other apps data updated to the same table, how do the DATASET get the UPDATED data from database.

In simple, how to ADO.NET handles database concurrency....???

RE: list all the classes those are used for database c...

1.SqlClientPermission - Enables the .NET Framework Data Provider
for SQL Server to help ensure that a user has a security level adequate to access a data source.

2.SqlClientPermissionAttribute - Associates a security action
with a custom security attribute.

3. SqlCommand - Represents a Transact-SQL statement
or stored procedure to execute against a SQL Server database. This class cannot be inherited.

4.SqlCommandBuilder - Automatically generates
single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.

5. SqlConnection - Represents an open connection
to a SQL Server database. This class cannot be inherited.

6.SqlDataAdapter - Represents a
set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.

7.SqlDataReader - Provides a means of reading a forward-only stream of rows from a SQL Server database. This
class cannot be inherited.

8.SqlError - Collects information relevant
to a warning or error returned by SQL Server. This class cannot be inherited.

9.SqlErrorCollection - Collects all errors generated by the .NET Framework Data Provider
for SQL Server. This class cannot be inherited.

10.SqlException - The exception that
is thrown when SQL Server returns a warning or error. This class cannot be inherited.

11.SqlInfoMessageEventArgs - Provides data
for the InfoMessage event. This class cannot be inherited.

12.SqlParameter - Represents a parameter
to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.

13.SqlParameterCollection - Represents a collection of parameters relevant
to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.

14.SqlRowUpdatedEventArgs - Provides data
for the RowUpdated event. This class cannot be inherited.

15.SqlRowUpdatingEventArgs- Provides data
for the RowUpdating event. This class cannot be inherited.

16. SqlTransaction - Represents a Transact-SQL transaction
to be made in a SQL Server database. This class cannot be inherited.
What are the Advantages of ADO.Net?

1. ADO.NET Does Not Depend On Continuously Live Connections
2. Database Interactions Are Performed Using Data Commands
3. Data Can Be Cached in Datasets
4. Datasets Are Independent of Data Sources
5. Data Is Persisted as XML
6. Schemas Define Data Structures