Ado.NET - How do you connect to SQL Server Database without using sqlclient

GeekInterview.com > Interview Questions > Microsoft > Ado.NET

Go To First | Previous Question | Next Question

Ado.NET | Question 19 of 31

How do you connect to SQL Server Database without using sqlclient

Total Answers and Comments: 5

Last Update: December 18, 2006 Asked by: Padmaja

Sponsored Links

Best Rated Answer

—

Submitted by: Kamal Kant Verma

you can connect sql using oledbname space .

Above answer was rated as good by the following members:
panusha2009, prabhukumar.r, thitnaing, PawanKum

November 07, 2006 23:33:58

Fahim

RE: How can I connect to sql without using sqlclient?(...

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

Is this answer useful? Yes | No

November 10, 2006 23:40:05

knreddy221

Member Since: November 2006 Contribution: 2

RE: How can I connect to sql without using sqlclient?(...

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

Is this answer useful? Yes | No

3 0

Overall Rating: +3

November 15, 2006 11:54:06

vikash agarwal

RE: How can I connect to sql without using sqlclient?(...

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

Is this answer useful? Yes | No

November 19, 2006 23:26:32

sriraja

RE: How can I connect to sql without using sqlclient?(...

By oledb connection sqlclient is called connection less oriented and

oledb is called connection oriented.

Is this answer useful? Yes | No

December 18, 2006 04:55:27

Kamal Kant Verma

RE: How can I connect to sql without using sqlclient?(...

you can connect sql using oledbname space .

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank