Interested to Buy Any Domain ? << Click Here >> for more details...
what is Execute NOn Query?
- 29 Answers
- 68698 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 |
how to add a selected row of a gridview to another gridview without reloading the page??
what are the two key events for the sql connection class? explain the differnce between the two.
What is commandbuilder in ado.net?
once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?
Which object needs to be closed?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What provider ADO.net use by default?
What is the provider being used to access oracle database?
Which object of ado contains datarow datacolumn collection?
What is row state?
What are the two fundamental objects in ADO.NET?
How to get oledb connection?
-
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)
