Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

what is Execute NOn Query?

Question Posted / thirushakar

Answers were Sorted based on User's Feedback



what is Execute NOn Query?..

Answer / nandu

ExecuteNonQuery

Use: when we are talking about a single database record - in Update, Insert, Delete and Get by Id. In all these cases we can use input/output/input-output parameters. Please note that from the application architecture point of view it is also good practices when your Insert and Update stored procedure returns changed record exactly like Get By Id method does.

Conclusion

Always use ExecuteNonQuery except: when you have a set of records - use ExecuteReader and when you have a single output value that cannot be defined as a parameter - use ExecuteScalar. Hope this helped to clarify something.

Is This Answer Correct ?    1 Yes 0 No

what is Execute NOn Query?..

Answer / mouli

Execute non Query is used to execute any SQL statement
(insert ,delete ,update) or a stored procedure

Is This Answer Correct ?    1 Yes 0 No

what is Execute NOn Query?..

Answer / anuj katiyar

Return the no of affected roh in databse

Is This Answer Correct ?    1 Yes 1 No

what is Execute NOn Query?..

Answer / pavan

This function is used to execute the DMLcommands. It return
int value resulting number of rows get affected.

Is This Answer Correct ?    1 Yes 1 No

what is Execute NOn Query?..

Answer / parag

Execute non Query is used to execute more than one command
at the time like in DML command.

Is This Answer Correct ?    0 Yes 0 No

what is Execute NOn Query?..

Answer / suman zalodiya

ExecuteNonQuery() is used when you run rhe query that
doesn't return anything.For example insert,update,delete
etc.

Is This Answer Correct ?    0 Yes 2 No

what is Execute NOn Query?..

Answer / kamalakannan

update Request.QueryString aslo Execute non query

Is This Answer Correct ?    5 Yes 9 No

what is Execute NOn Query?..

Answer / anna

it returns the no. of queries executed successfully

Is This Answer Correct ?    40 Yes 85 No

what is Execute NOn Query?..

Answer / r

Execute NOn Query

Is This Answer Correct ?    25 Yes 88 No

Post New Answer

More ADO.NET Interview Questions

If we are not returning any records from the database, which method is to be used?

0 Answers  

Define connection string?

0 Answers  

Why sql Data Reader object not created

9 Answers   Matrix,

What is execute reader in ado.net?

0 Answers  

Define Execute Scalar?

0 Answers   UGC Corporation,

Can we bind one datareader wid two dropdown list?

5 Answers  

What is Dataset Object?

0 Answers  

What is ado full form?

0 Answers  

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

What is the Magic Tables in Sqlserver2000?

7 Answers   IBM, SQL Star,

What is the difference between the clone() and copy() methods of the dataset class?

0 Answers  

What do you know about ADO.NET's objects and methods?

0 Answers   NA,

For more ADO.NET Interview Questions Click Here
Categories