what is Execute NOn Query?
Answers were Sorted based on User's Feedback
Answer / madhulatha
ExecuteNonQuery() ia command object method,is for
insert,update and delete statements.i.e for the statements
which does'nt returns any value after the execution.return
type of ExecuteNonQuery is int,we can return no of affected
rows.
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / mahesh
ExecuteNonQuery() ia command object method,is for
insert,update and delete statements.i.e for the statements
which does'nt returns any value after the execution.return
type of ExecuteNonQuery is int,we can return no of affected
rows.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / gazillionaire
Executes a Transact-SQL statement against the connection and
returns the number of rows affected.
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / seenivasagan
Execute non Query DataBase Used in Insert,UpDate,Delete...
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / mona
Execute non Query is used to execute more than one
command
at the time (it is used for insert ,delete ,update)
it returns the no. of queries executed successfully
exeuate non Query DataBase Used in Insert,UpDate,Delete...
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / balaji rajasekaran
ExecuteNonQuery method is used for
==================================
Sending SQL Insert statements to a database.
Sending SQL Update statements to a database.
Sending SQL Delete statements to a database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pradeep mishra
ExcuteNoNquery is a method that is work to check(insert,delete update) query executed or not
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sandip karsariya
ExecuteNonQuery() is one of the most frequently used method
in SqlCommand Object and is used for executing statements
that do not return result set. ExecuteNonQuery() performs
Data Definition tasks as well as Data Manipulation tasks
also. The Data Definition tasks like creating Stored
Procedures and Views perform by ExecuteNonQuery() . Also
Data Manipulation tasks like Insert , Update and Delete
perform by ExecuteNonQuery().
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / akira
execute Non Query (), Is for insert,delete and update
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / basheer
Command.ExecuteNonqurey is used to Execute querys which
actually does not query Database table to give back
something (Like Select) but commnads DB table to do
something.(Insert,Update or Delete)
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the benefits of using ado.net?
What is the use of SqlCommand object?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is method to get XML and schema from Dataset? getXML() and get Schema ()
What are the types of databinding?
What is adodb dll?
Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?
What is the provider being used to access oracle database?
What do you know about ADO.NET's objects and methods?
What is ado.net object model?
Define the data provider classes that is supported by ado.net?
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)