Ado Net Seminar

[born_for seminars]

ADO.Net -
ADO.net architecture
Connected and Disconnected
Programming steps for connected and disconnected architecture
Concepts on Classes used while using either of the architecture
Difference between Datareader and Dataset.
When to use which one.


Programming steps for connected architecture
Establish connection.
Write a query using command statement and pass connection object to it.
Execute the query.
Use the datareader object if there is a return type.
Close the connection.
Close the datareader.


Programming steps for Disconnected architecture
Create a connection object.
Create a adapter object by passing query string and connection object.
Create Dataset object.
If it has return type, fill the required values into dataset object and use it.
For updation/deletion/insertion, use predefined property of adapter class
and assaign it the query string.
6. Update the adapter object and pass dataset object and table you are updating