when to use SqlDataAdapter and sqlcommand ?

Question

0.00/5 (No votes)

See more:

this code insert data in table

C#

str = "insert into table values()";
SqlCommand cmd = new SqlCommand();
cmd.Connection="connection string";
cmd.CommandText = str;
cmd.ExecuteNonQuery();

and this code also insert data in table

C#

string str = "insert into table values";
SqlDataAdapter adp = new SqlDataAdapter(str, "connection string");
DataSet ds = new DataSet();
adp.Fill(ds);

so what is diffrent between them and which one to use is good?

[Edit]Pre tag added by Jibesh[/Edit]

Posted 15-Mar-13 6:33am

Member 9784436

Updated 15-Mar-13 7:00am

Jibesh

v2

Add a Solution

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

Behno0o0oD · Accepted Answer · 2013-03-15T10:42:00

Solution 2

When you are using Dataset, in fact you are saving the table information in ram. but when using command, you are filling the physical table which is stored in hard. so when you are using dataset, you can see more speed ;)

Posted 15-Mar-13 10:42am

Behno0o0oD

Comments

Member 9784436 16-Mar-13 0:09am

ok sir i got it
and thank you so much.

Akbar Ali Hussain · Accepted Answer · 2013-03-15T06:43:00

Solution 1

Use SqlCommand to execute INSTER/UPDATE/DELETE queries and SqlDataAdapter can be used for retrieving data from the database.

The second query you provided in your question is wrong. That query should be a SELECT query rather than INSERT

Posted 15-Mar-13 6:43am

Akbar Ali Hussain

Comments

Member 9784436 15-Mar-13 12:50pm

ok sir but
String str = "update allocate set s_name='" + servr + "'where department='" + depa + "'";
ad = new SqlDataAdapter(str, Class1.con);
ds = new DataSet();
ad.Fill(ds);

i have used in my project ans still it works, so what happing with me?