Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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?

Question Posted / divyaanumod

Answers were Sorted based on User's Feedback



Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

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

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, de..

Answer / pankaj shinde

Total number of rows effected.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More ADO.NET Interview Questions

How many major types of connection objects in ADO.NET?

0 Answers   MCN Solutions,

What is ole db and odbc?

0 Answers  

How to check if the Dataset has records ?

0 Answers   NA,

How does entity framework work?

0 Answers  

how Sequence to connect and retrieve data from database using dataset?

0 Answers  

What are all features of ADO.Net?

0 Answers  

Does executenonquery return a value?

0 Answers  

What is untyped dataset?

0 Answers  

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers  

What is the Magic Tables in Sqlserver2000?

7 Answers   IBM, SQL Star,

What is dataset and datatable in ado.net?

0 Answers  

What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,

For more ADO.NET Interview Questions Click Here
Categories