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?
Answer Posted / 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 |
Post New Answer View All Answers
How can we check that some changes have been made to dataset since it was loaded?
What is meant by executenonquery?
What is sqldatareader?
What is maximum pool size in ado.net connection string?
What does adodb stand for?
What are the uses of Stored Procedure?
Which parameter of ConnectionString is used to specify the name of the database?
What is Data Provider?
Explain how do you connect to sql server database without using sqlclient?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is Serialization in .NET? what are the types of Serialization?
What are the essential features of ado.net?
List all the steps in order, to access a database through ado.net?
What is ado.net object model?
What are three methods for displaying data in a syncfusion datagrid