What is the difference between excute query and excute
nonquery.?
Answers were Sorted based on User's Feedback
Answer / riddhi
excute nonquery :-- use when insert,update,delete will fire.
excute query:-- when non dml query is used.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / shreekant
execute qurey is used for a select statement
ex:"select * from employees";
execute nonquery is used when insert, update,delete statement.
ex:insert into employees values("yourrecirds");
delete from employees
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rina baranwal
use ExecuteQuery with "select" query but we use Execute
NonQuery with Update,insert and delete query.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / bhagwat prasad sharma
1)>>> when we insert data into database, delete data from database, update data from database than use ExecuteNonQuery
statement .
but when we select data from database than use ExecuteQuery
statement . that solves
| Is This Answer Correct ? | 3 Yes | 0 No |
What are demand-paging and pre-paging?
What is voluum?
How to Page Execute in asp.net(inside browser)
What are the event handlers that can be included in the Global.asax file?
Explain managed code an un-managed code.
What is the asp.net mvc folder conventions? : asp.net mvc
How do we make a poperty read only?
What is meant by role based security? when we use this one
What is application variable?
What are ASHX files?
What is the difference between file-based dependency and key-based dependency?
What is the compiled object?
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)