disconnected connection

[sachin_himcs]

sir

how we can say DataSet is disconnected and ado.net use disconnected connection.

[handshakeit]

Hello sachin

ADO.Net works on both connected and disconnected environment,
DataSet works on Disconnected environment.
Disconnected means there is no connection with the database.
Disconnected approach is better as it reduces the server overload, in disconnected approach you connect to database and do your transaction ant after completing close the connection, while in connected environment the connection to database is established and kept untill the aplication is terminated.
DataSet is the control that enables the ADO.Net's Disconnected capability, you establish connection to database, runn ur query, fill the result to dataset, and close the connection.
then in application you changes in dataset and to save changes to databse again open connection, save changes, and close connection

[Malith]

the best practice is pl use seperate class for database connection.

then open the coonection and (it is in side the TRY CATCH case ) then cose the connection is side the finally (TRY , CATCH and FINALLY)

then
the database coonection automatically close.

i this is not a answer but u can get some thing.

Cheers :thumbsup: