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 |
Explain the difference between web user control and web custom control?
What is the meaning of TestApi?
Which library is used by the testers and developers to develop automated tests and create testing tools?
How do you implement postback with a text box?
Explain what a diffgram is and a good use for one?
1 Answers Siebel Systems, Syntax Softtech,
What is GAC in ASP.NET 2.0
what is the difference between primary key and foreign key?
What are cao and sao.
Why is mvc better than asp.net?
Whta are the Various steps taken to optimize a web based application (caching, stored procedure etc.) ?
What is MSIL?
Differentiate between namespace and assembly.
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)