Connection box in ADO.NET

[Guest]

Hi there

ODBC as well as ADO have connection boxes that allow to set up connection strings (pick providers or ODBC drivers etc.). Is there something that is equivalent for ADO.NET. Does ADO.NET still use OLE DB providers or is there something different with the .NET providers and therefore a different connection setup box

Thanks in advance
Confused and Learning.

 

[William Ryan eMVP]

Drag a connection from the Data tab onto your form..OleDb, SqlClient ,
Oracle etc. you can click in the properties grid in teh Connection String
and ti will pop up for you.

Hi there,

ODBC as well as ADO have connection boxes that allow to set up connection

strings (pick providers or ODBC drivers etc.). Is there something that is
equivalent for ADO.NET. Does ADO.NET still use OLE DB providers or is there
something different with the .NET providers and therefore a different
connection setup box?

 

[Guest]

What about dynamic connection string setup from the program. The user needs to see a connection box that allows him/her to select a provider and then to connect to a specific database (choose the database, fill in the user id and password etc.) weather it's oracle, sql server etc. Is there a connection setup box like that for .NET Windows Forms applications?

 

[JLW]

Probably best off making a pop-up window and build the connection on the fly
like that. It also allows you to force a user to type in a
username/password. Just a thought.

JLW

What about dynamic connection string setup from the program. The user

needs to see a connection box that allows him/her to select a provider and
then to connect to a specific database (choose the database, fill in the
user id and password etc.) weather it's oracle, sql server etc. Is there a
connection setup box like that for .NET Windows Forms applications?