Click here to Skip to main content
12,948,566 members (62,029 online)
Rate this:
Please Sign up or sign in to vote.
See more:
i wanted to know without connecting to database how can we retrieve data.
what is connected architecture and disconnected architecture,what is the difference between these.
Posted 5-Dec-12 19:58pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Nice question Mr. Karthikeyan but I am afraid you can't retrieve data without even connecting to a DB until and unless you are a

the next part of ur question has probabale answers.
Connected architecture refers to being connected to the server evry single instant of time to retrieve real time data and stats...for ex:In a railway reservation system, you would have to be connected to the server everytime to knw the status or your own booking and stuffs....
Coming to .NET POV, open the connection, work and process ur dataset and then close the connection.

In case of disconnected architecture, you dont nee to be connected to the server evrytime.Open the connection,retreive the dataset from the server,close the connection,work on the datset and process it....Its just like a local copy on ur system..

And btw..there are numerou articles on MSDN or even here to make use of..

Hope it helps...:):)
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

May Be You Asking About SQL dataadapter which works in disconneted manner we need not to open or close sql connection

but SQL datareader works in connected manner here we have to open and close the sql connection.

and it can't be possible to fetch data without connection string or connection.
Rate this: bad
Please Sign up or sign in to vote.

Solution 4


i dont know the way of your first Question. becoz thats impossible. but i can say answer for your second question that is,

In Disconnected architecture DataSet is used for retriewing data from database. Then no need for maintaining the connection also. All the operations can be performed with the data once retriewed. It wont cause traffic problem while working with database.
In connected architecture DataReader is used for retriewing data from database. Here a connection is always maintained. Update, Delete, Read and Select operations can be performed on each time at database.., so tat a connection must be needed to be maintained.. so it cause traffic problems.

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

No you can't.. Its not possible..
Assume that, I'm askhin' for 5$ and you don't have it, So how'd you give me 5$ ??
Same way, for database transaction you must have open connection.. :) but ya except SqlDataAdapter ....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,419
CHill60 3,275
Maciej Los 2,778
Jochen Arndt 1,935
ppolymorphe 1,795

Advertise | Privacy | Mobile
Web01 | 2.8.170524.1 | Last Updated 6 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100