Interested to Buy Any Domain ? << Click Here >> for more details...
what is Execute NOn Query?
- 29 Answers
- 69504 Views
- Infosys, Protech, Sars Systems, SwanSoft Technologies, I also Faced
- E-Mail Answers
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 |
What are the benefits of using of ADO.NET in .NET 4.0?
Why do we need ado.net?
Which object of ado contains datarow datacolumn collection?
How many major types of connection objects in ADO.NET?
Define isolation?
Define bubbled event?
What is an ado?
What is a dynaset in access?
What are the two fundamental objects in ADO.NET?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is ado and rdo?
What are the different methods available under the sqlcommand class to access the data?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
