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 |
describe the dataset object in ado.net.
Diff. b/w DataReader and DataSet?
How to generate a single aggregate?
Which is the best institute in hyderabad to learn DotNet?
What are all features of ADO.Net?
What is sqldatasource?
Which object is used to add relationship between two Datatables?
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,
What are the several execute methods of ado.net?
What is ole data type?
How to add a check box or a dropdown list to a column in a datagrid?
ADO and ADO.NET differences ?
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)