connnection without database

Question

1.00/5 (1 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

karthikeyan9966

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Anurag Sinha V · Answer 1 · 2012-12-05T20:16:00

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 magician..lol..:P:P

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...:):)

Surendra0x2 · Answer 2 · 2012-12-05T20:39:00

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.

Sarrrva · Answer 3 · 2012-12-05T21:06:00

hi,

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

SQL

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.

regards
sarva

Krunal Rohit · Answer 4 · 2012-12-05T20:07:00

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 ....

Posted 5-Dec-12 20:07pm

Krunal Rohit

Updated 5-Dec-12 21:12pm

v2

connnection without database

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0