Fahim

• Nov 7th, 2006

 

You can use the methodsd and function available in the System.OleDB class instead, to get the SQL connection.

knreddy221

 Profile 

• Nov 10th, 2006

 

Using System.Oledb;OledbConnection con= new OledbConnection ("Provider=SQLOLEDB.1;User Id=sa;Database=Northwind");OledbCommand cmd= new OledbCommand ("select * from table1",con);oledbdatareader dr= new oledbdatareader ();dr= cmd.ExecuteReader();datagrid1.datasource=dr;datagrid1.databind();

vikash agarwal

• Nov 15th, 2006

 

using oledbnamespacesystem.data. olebd dim con as new oledbconnection(" provider=sqloledb.1;.............. ")

sriraja

• Nov 19th, 2006

 

 Hi

    By oledb connection  sqlclient is called connection less oriented and

oledb is called connection oriented.

Kamal Kant Verma

• Dec 18th, 2006

 

you can connect sql using oledbname space .

lata negi

 Profile Answers by lata negi 

• Nov 4th, 2011

 

We have 4 Data Providers to connect to our database:
SqlClient = Used only for Sql Server database.
OracleClient = Used only for Oracle database.
Oledb = Used for any kind of databases either new or old.
Odbc = User for older databases.

So, to connect to SQL Server Database without using sqlclient, we can use OLEDB Data Provider.

Using System.Oledb;

OledbConnection conn= new OledbConnection ("Provider=SQLOLEDB.1;User Id=sa;Database=Northwind");
OledbCommand cmd= new OledbCommand ("select * from employee", conn);

Code
Using System.Oledb;


 


OledbConnection conn= new OledbConnection ("Provider=SQLOLEDB.1;User Id=sa;Database=Northwind");


OledbCommand cmd= new OledbCommand ("select * from employee", conn);