Answer / satish v itagi

ExecuteNonQuery is used to inserts, updates, deletes.
ExecuteScaler is used to return values at a stretch; and
can do data modifications too.
ExecuteReader is forward only reading of row by row.

The number of readers that can be open at a time has
limitation (255)

Execute Scaler has no such restriction. You can use
sqlparameters (output) to get more than one field value,
you can use multiple queries to get more than one result.

Because of less overheads, ExecuteReader has a slight
performance advantage but has limitations.

Do not forget to close Readers!

Answer / kriss

Execue reader

Answer / anirudh g

Scalar will be faster that the execute reader and execute
non query. As scalar only fetch one column single row.
Whereas execute reader may return numbers of record and
though non-query will not return any records it will take
time to identify the data types to validate be4 inserting
the data

Answer / kamlesh sharma

most of the above answers are wrong

write answer is execute reader

Answer / xc v

execute reader

Answer / peter

What is faster:

ExecuteNonQuery("INSERT INTO...; INSERT INTO...; INSERT
INTO");

or

ExecuteNonQuery("INSERT INTO...")
ExecuteNonQuery("INSERT INTO...")
ExecuteNonQuery("INSERT INTO...")

I hope you see my point. Of course it is not a matter of
only three inserts, but maybe 200 - and then I would like
to know if I can save time by adding the INSERT-strings to
one big string and only fire off one ExecuteNonQuery.

I was thinking of coding a test to check, but if some of
you have already done this or just know which is faster,
please let me know.

Thanks

Answer / ftryttuyhg

execute non query

Answer / ranjitha

Execute Non query

What is the difference between session object and application object?

0 Answers  

what is loosely coupled solution? How it can be used?

0 Answers   Siebel,

What are the different types of Caching techniques in ASP.NET?

0 Answers  

What is the difference between web config and machine config files?

0 Answers  

What is a postback url?

0 Answers  

Guys can anobody tell what is Conditional Bloating in asp.net ??

1 Answers  

How to implement caching?

2 Answers   Infosys, Microsoft,

In the Repeater control which way you can edit?

0 Answers   Siebel,

Describe the difference between a Thread and a Process?

4 Answers  

Suppose, I have 3 pages, Page1.aspx, Page2.aspx, Page3.aspx. All pages are in diff. server. When user req. for a page, Page1.aspx opens Ist & a session established. If user req. for IIn page, second session established. Similarly, 3rd session established if user req. 3rd page. In this scenario, tot. 03 sessions are established. How we can minimize it so that it will work with only one session?

3 Answers   TCS, Wipro,

What is machine.config and web.config ?

5 Answers   Digital GlobalSoft,

how to update data set?

3 Answers   IBM, TCS,