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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data access pattern?

675


What are the ado.net components?

758


Explain how can we load multiple tables in to dataset?

700


What is ole access?

709


What is sqlconnection and sqlcommand?

727


What are typed and untyped dataset?

778


What are the advantages using ado.net?

751


How we can provide data to ado.net?

757


What is the difference between OLEDB Provider and SqlClient?

725


What is the difference between sqldatareader and sqldataadapter?

717


What is openquery?

726


Explain the two fundamental objects in ado.net?

684


Can we connect two dataadapters to same data source using single connection at same time?

749


Explain sqlconnection object?

766


What is the current version of entity framework?

678