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

Do you use stored procedure in ado.net?

794


Does ado.net use odbc?

727


What is ado or jdbc?

720


What is the full form of ado.net?

764


What are the methods of XML dataset object?

824


What are the benefits of using of ADO.NET in .NET 4.0?

761


What is the difference between statement and preparedstatement interface?

788


What is the difference between data reader and data adapter?

802


What is the difference between Data adaptor and Data set?

817


What is an example of ordinal data?

758


Define Execute Reader?

849


Can datareader hold data from multiple tables?

887


Why do we use sqldataadapter?

739


What is DataRowCollection?

857


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2153