B.venkateswara Rao

• Jun 26th, 2005

 

executequery applies for commands and execute nonquery for insert,update and delete.

vvabbu

• Jul 22nd, 2005

 

 
ExecuteQuery from command Object 
 
we can use the ExecuteNonQuery to perform catalog operations (Insert,Delete,Update) 
 
ExecuteNonQuery does not return any rows, any output parameters or return values mapped to parameters are populated with data. 
 

yerva

 Profile Answers by yerva 

• Aug 18th, 2006

 

executeQuery() is for command objects i.e., this method will send "select statement" to database and returns value given by the database.

Moreover the executeQuery() is not used in .net but it is used in JAVA.

executeNonQuery() uses the "Insert/Update/Delete/Stored subprogram"  , this method will return number of records effected by the database table

kk

• Feb 9th, 2007

 

false, it returns rows affected

Gunjan Arora

• Apr 7th, 2007

 

ExecuteQuery() method is in Java and returns SQLServerResultSet object.
SqlCommand.ExecuteNonQuery Method executes a Transact-SQL statement against the connection and returns the number of rows affected.

venkatesan

• Jul 20th, 2007

 

Execute Query is the Command object. It returns query affected datas,  Execute Non Query is also command object. But It returns No of affected rows value.

ruchigoyal85

 Profile Answers by ruchigoyal85 

• Dec 30th, 2007

 

There is no object like ExecuteQuery

Lavanyaaru

 Profile Answers by Lavanyaaru Questions by Lavanyaaru

• Feb 5th, 2008

 

In ADO.net for Command Object you have 3 methods
1.ExecuteReader - Select statements
2.ExecuteNonQuery - DML statements(Insert,Update and Delete)
3.ExecuteScalar - Returns a single value from Aggragate functions like SUM,AVG,COUNT etc

amitkumar316

 Profile Answers by amitkumar316 

• Feb 15th, 2008

 

Execute non-query always returns an integer value which is the number of rows affected by the query.

bpdhyani

 Profile Answers by bpdhyani 

• May 21st, 2008

 

• executenonquery is use select,create type of query like

1. select table,create table

• executequery is used for

1. insert,update,alter,procedure etc.
   
   

bb.geetha

 Profile Answers by bb.geetha 

• Jun 6th, 2008

 

we can use the ExecuteNonQuery to perform catalog operations (Insert,Delete,Update)

ExecuteNonQuery does not return any rows, any output parameters or return values mapped to parameters are populated with data.

executeQuery() is for command objects i.e., this method will send "select statement" to database and returns value given by the database.

srinivasulu.p

 Profile Answers by srinivasulu.p 

• Dec 10th, 2009

 

In ADO.NET we are not using execute query but execute non query is used, when SQL stmt is
 DDL (Create, Alter, Drop stmts), DML (Insert, Delete, Update), stored sub program .

Vimlesh Kumar

 Profile Answers by Vimlesh Kumar 

• Sep 8th, 2011

 

In ADO.net for Command Object you have 3 methods
1.ExecuteReader - Select statements
2.ExecuteNonQuery - DML statements(Insert,Update and Delete) - Returns Number of rows affected
3.ExecuteScalar - Returns a single value from Aggregate functions like SUM,AVG,COUNT etc

sheetal maheshwari

• Nov 24th, 2011

 

: execute query is used for DDL commands whereas execute nonquery for DML.