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 is data adapter in ado.net with example?
Describe connection object in ado.net
What is ole db and odbc?
How to retrieve the user id which is provided while windows authentication?
What is ado.net in mvc?
How to you declare connection strings and how to you make use of web.config ?
What is a column variable?
Why do we serialize data?
What connected data?
suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.
2 Answers Fulcrum Logic, Satyam,
How is it possible to get 2 tables of data at a time by using data reader?
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)