Last post Apr 14, 2010 06:33 PM by ashwani2kumar
Apr 14, 2009 02:40 PM|kapilbharat|LINK
Good evening all,
I want to know what is actually Connected and Disconnected mode in ado.net.
please explain me with practical.
Thanks all of you.
Apr 14, 2009 04:15 PM|mmeisinger|LINK
hm... how to explain this practicaly...
when "connected" the connection to the server (or database) is maintained in state
when "disconnected" the connection to the server is not maintained and the changes must be transmitted back to the server to "reconnect" and save the changes to the database
so think of a client/server app like a win form or something
if you are "connected" then the data being moved between the client and the server are being done with an active connection or in "real-time"
if you are "disconnected" then the data is sent to the client where it lives on the client as a datasource. the client can make changes, add new data, delete data, etc...
when the client "reconnects" the data is sent back to the server (either as a diff or as a whole) where the server will save the changes back to the database or datasource
Apr 14, 2009 04:27 PM|mudassarkhan|LINK
DataReader is connected architecture since it keeps conneection open untill all records are fetched
DataSet is disconnected architecture gets all records at once and closes connection and are available even after connection is closed
Apr 14, 2009 04:44 PM|sumitd|LINK
Refer below articles and few of them talks about best practices also and few of them talks about which one you should use:
Apr 14, 2009 05:52 PM|raghav_khunger|LINK
The Same thing is discussed at
Please Reefer that .
Aug 01, 2009 03:05 PM|Haansi|LINK
You have described Disconnected and connected very nice.
Kindly explain me a point.
1. Suppose we get data from db in a dataset and attach this ds to a grid. now how I can play with this dataset. I want to make changes in dataset like update records or delete records from dataset and on day close I update this dataset to the server, how
it can be done, plz guide me this snario.
2. Is it possible to place dataset on client machine ? I do not want to keep it on server. This way again user will have to go to server again and again.
3. Is there any such approach that we get data downloaded in some dataset / some other datastructure/ or a small db on user machine. He works all day and on closing update dataset/data structure or db back to the db server ?
Thanks in anticipation for sharing,
Aug 01, 2009 07:08 PM|RickNZ|LINK
I answered this same question in the other thread.
Apr 14, 2010 06:33 PM|ashwani2kumar|LINK
i have one question, aprt from this question...
i have a database and database have 3 tables...
i want the table data show in asp:table not in grid view....
like in frid view we a doing simple wizard mode to fetch data from database... But in my query i want show data in <asp:Table> ..
For example in this table
data from sql