How do you connect to SQL Server Database without using sqlclient

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

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();

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

 Hi

    By oledb connection  sqlclient is called connection less oriented and

oledb is called connection oriented.

you can connect sql using oledbname space .

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);