can i use sqldataadapter to make sql operation like and read vallues in textbox like

Question

0.00/5 (No votes)

See more:

we use command class and datareader for retrieving the data

can i use sqldataadapter and datareader for the same purpose to read only single row value

Posted 23-Nov-11 23:14pm

syedkhaleel

Add a Solution

3 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)

Eduard Lu · Answer 1 · 2011-11-24T18:52:00

Solution 3

Of course you can. But using datareader is more efficient and faster.

Regards.

Posted 24-Nov-11 18:52pm

Eduard Lu

srinivas vadepally · Answer 2 · 2011-11-23T23:21:00

Solution 1

Hi syed,
SqlDataAdapter and DataReader[^]
I hope it clears your doubt.
If you need more, send me a query.

Posted 23-Nov-11 23:21pm

srinivas vadepally

rajeevcapgeminiindia · Answer 3 · 2011-11-23T23:29:00

DataReader:

You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. Results are returned as the query executes, and are stored in the network buffer on the client until you request them using the Read method of the DataReader. Using the DataReader can increase application performance both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory, reducing system overhead.

DataAdapter:

A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source. The DataAdapter uses the Connection object of the .NET Framework data provider to connect to a data source, and it uses Command objects to retrieve data from and resolve changes to the data source.

More deatils you can find from here

http://msdn.microsoft.com/en-us/library/ms254931.aspx[^]