ado.net connected vs ado.net disconnected

[amro_ka]

hello all.

iam new here well ill say directly what i wanna know

what is the diffrance between connected and disconnected techniuques in ado.net and and when to use disconnected and when to use connected in your application and if you application is gonna rrun on a LAN and and you have many instannts of your application connecting to the same tables and deal with it (insert,delete & update) which is better connected or disconnected and plz give me examples where the connected and disconnected modes in applications are used

Thanx alot

amro

[Robby]

Connected would be a DataReader, it is forward only and read only, DataSets and the like are all disconnected.

 

First of all; insert,delete & update should be done using Stored Procs. (If your DB permits)

 

If you have many table to select then you can fill a datset with these many dataTables, this way you're only hitting the DB once.