Anupam Rai

• Jun 8th, 2007

 

System.Data.OleDB
 It contains the objects that we  use to connect to a data source via an OleDB provider , such as OleDbConnection,  OleDBCOmmand
 

System.Data.SqlClient
It contains objects that we use to connect to a data source via Tabular data stream interface provided by Microsoft Sql Server. This can be generally used to provide better performance because it removes some of the intermediate layers required by the OleDB provider. 

itgirl

 Profile Answers by itgirl 

• Dec 14th, 2007

 

Executenonquery does not return any value unlike executequery which return values for select, insert, update

developeramit.net

 Profile Answers by developeramit.net 

• Feb 15th, 2008

 

system.oledb or system.sqlclient both are use for connectvity to database


execute query returns value its uses selct statement
executenon query not return value through this we insert, update,delete ,statement performed

vinaymoodnur

 Profile Answers by vinaymoodnur 

• Mar 6th, 2008

 

imports.system.sqlclient is used when using sql server as database
imports.system.sqlclient is used when using access as database
executenonquery is used when executing DML (insert, update delete operations).
hope this answers the question adequately

Diptikanta

 Profile Answers by Diptikanta 

• Apr 3rd, 2008

 

Imports system.sqlclient is used only for MSSqlserver database.
Imports system.oledb is used for any other databases including MSSqlserver.

Executenonquery is used for Insert,Update,Delete command. And It returns an integer value that number of records affected.

And Executequery is used for select command and it returns an result object.

pradhib.l

 Profile Answers by pradhib.l 

• Aug 20th, 2008

 

There are two methods used for disconnected architecture one is
1) Execute Scaler
2) execute nonquery

Execute Scalar: It is for math functions (min,max,add,sub)

Execute Nonquery: It is used for insert,update,delete operations.