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.

Answer / suresh reddy

returns -1, since you can't find the how many rows effected because of your stored procedure.

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...

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

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.

Answer / pankaj shinde

Total number of rows effected.

What is connection in ado.net?

0 Answers  

What are the connected and disconnected modes in ado.net?

0 Answers  

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 can we serialize the dataset object?

0 Answers  

What providers does Ado.net uses?

0 Answers  

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

What is the executescalar method?

0 Answers  

how to display empty table to datagrid

3 Answers   LG Soft,

I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?

2 Answers  

Explain the difference between an ado.net dataset and an ado recordset?

0 Answers  

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

Write steps of retrieving data using ado.net ?

3 Answers   Keane India Ltd,