|
Connection String with SQL Server Security Authentication (needs to include UserID and Password of d....
|
Category:
ADO.Net
|
Date:
12/2/2009 12:23:20 AM
|
|
|
|
When .Net application connects to a database or a data file, ADO.Net uses a connection provider spec....
|
Category:
ADO.Net
|
Date:
12/2/2009 12:04:03 AM
|
|
|
|
This object represents an SQL statement that is executed while connected to the database. Following ....
|
Category:
ADO.Net
|
Date:
10/15/2009 5:03:07 AM
|
|
|
|
DataSet object provides following methods to generate XML: 1) ReadXML Reads a XML schema and data i....
|
Category:
ADO.Net
|
Date:
10/8/2009 3:49:37 AM
|
|
|
|
Step-1: Open the database connection by creating a Connection object. We can load the connection str....
|
Category:
ADO.Net
|
Date:
10/8/2009 3:16:53 AM
|
|
|
|
DataSet.Clone(): It only copies structure, does not copy data. DataSet.Copy(): Copies both structur....
|
Category:
ADO.Net
|
Date:
10/6/2009 6:37:58 AM
|
|
|
|
We use ExecuteReader method of Command object to get the DataReader object. This ExecuteReader metho....
|
Category:
ADO.Net
|
Date:
10/6/2009 6:34:42 AM
|
|
|
|
Use a DataSet when you need to do following: 1) Navigate between multiple discrete tables of resul....
|
Category:
ADO.Net
|
Date:
10/6/2009 5:56:34 AM
|
|
|
|
Following are some major differences between DataSet and DataReader: 1) DataReader provides forward....
|
Category:
ADO.Net
|
Date:
10/6/2009 5:47:03 AM
|
|
|
|
DataReader object provides a read-only, forward-only stream of data from a database. The DataReader ....
|
Category:
ADO.Net
|
Date:
10/6/2009 5:35:46 AM
|
|
|
|
ADO.Net offers following benefits: 1) XML is the format for transmitting datasets across the networ....
|
Category:
ADO.Net
|
Date:
10/6/2009 5:17:57 AM
|
|
|
|
ADO.Net relies on Data Providers to provide access to a particular data source. Each Data Provider e....
|
Category:
ADO.Net
|
Date:
9/30/2009 3:59:34 AM
|
|
|
|
DataSet object is an in-memory, relational data representation. The DataSet object contains a collec....
|
Category:
ADO.Net
|
Date:
9/12/2009 7:26:46 AM
|
|
|
|
Connecting to a database server typically consists of several time-consuming steps. ADO.Net uses an ....
|
Category:
ADO.Net
|
Date:
9/4/2009 7:05:56 AM
|
|
|
|
1) ADO works only with connected architecture while ADO.Net works in both connected as well as disco....
|
Category:
ADO.Net
|
Date:
9/4/2009 6:56:11 AM
|
|
|