what is Execute NOn Query?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / kamalakannan
update Request.QueryString aslo Execute non query
Is This Answer Correct ? | 5 Yes | 9 No |
Answer / anna
it returns the no. of queries executed successfully
Is This Answer Correct ? | 40 Yes | 85 No |
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is the difference between ado.net and entity framework?
If we are not returning any records from the database, which method is to be used?
What are the advantages and disadvantages of using datalist?
How to check if a datareader is closed or opened?
How to find the count of records in a dataset?
What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?
Which object of ado contains datarow datacolumn collection?
What is ado data control?
What provider ADO.net use by default ?
5 Answers Accenture, BirlaSoft, Wipro,
What is the difference between connected environment and a disconnected environment?
Which is better entity framework or ado.net?