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 is paging in context of Memory?
Which is better session or viewstate?
You have been given the task of designing a web services to expose the data that is stored in a database on the server. In order to successfully build the web services, you need to import some namespaces. What is the minimum namespace you need to import? a) System.Web b) System.WebServices c) System.Web.Services d) System.Web.ServiceModel
How to handle error while project running on live
Difference b/w casting and boxing?
Is asp.net a programming language?
How Response.flush works in server.Execute ?
1 Answers Keane India Ltd, TCS,
How to change the form layout in ASp.net 2.0 ?
What is the difference between session.abandon() vs clear()?
What are HTTP handlers in ASP.NET?
What are the types of validation in asp net?
How can we pass info between 2 asp.net pages?
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)