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 the advantages of using Master Pages?
How to limit table cell size with long strings?
What are validator? Name the validation controls in asp.net?
What is the difference between GridView and Repeater controls in ASP.NET?
What is the parent class of all the web server control?
after which page life cycle event all properties of control will be "fully loaded "
What is MSIL?
what is the uses Of Global.asax
What symbol specifies the beginning of a query string?
What is the difference between cookie and session?
Features in ASP.NET?
Why does a user need nothing more than a Web browser to view 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)