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?
Answers were Sorted based on User's Feedback
Answer / sandyni
Execute nonquery effects only for DML like Update delete
and insert statements only,
for select statement we have to choose ExecuteScalar or
ExecuteReader methods. these methods can return datareader
and gives the result for your query.
Is This Answer Correct ? | 18 Yes | 6 No |
Answer / suresh reddy
returns -1, since you can't find the how many rows effected because of your stored procedure.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / suraj
I don'nt have the right ans but i think the question was if
i have lot of delete stmnt, insert stmnt and update
statement...then what does execute nonquery returns in this
case? as for select we use execute reader...
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jaya tiwari
Execute non query executes a query that is associated with
sqlCommand object . sqlCommand object having a property
sqlCommandobj.CommandText in which we pass the query. so
ExecuteNonQuery will return the no of rows affected by that
command whose sqlCommand obj invokes this method .
and it can't be use for select as its return type is int
that is no of rows affected in execution of that query
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sireesha
ExecuteNonQuery() returns one one value. the return type of
ExecuteNonQuery is integer. It returns the value that are
effected by the executeNonQuery() statement.
Is This Answer Correct ? | 1 Yes | 1 No |
What provider ado.net use by default? Explain the role of data provider in ado.net?
How to find the count of records in a dataset?
Which ado.net object is very fast in getting data from the database?
can we change the data in dataset? if yes what is the process?
What is ado.net and its architecture?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
How do u implement locking concept for dataset?
Does sqlclient and oledb class share the same functionality?
What are all features of ADO.Net?
What are the benefits of using ado.net?
What is bubbled event?
Differnces between oracle 9i and sql server?
2 Answers College School Exams Tests, Microsoft,