Hello everyone,
I am working on a project that involves converting some "legacy" VB6 code to .NET. Part of the project involves having a user select a DSN from a list box, to export some data to the selected data source.
I have the following VB6 code:
What would be the .NET equivalent to the above code, especially for Line #2?
I do know that you can reference a .dll and import the ADODB namespace, but I wanted to find out if there was another way to do this.
Any questions or suggestions would be appreciated.
Thanks!
I am working on a project that involves converting some "legacy" VB6 code to .NET. Part of the project involves having a user select a DSN from a list box, to export some data to the selected data source.
I have the following VB6 code:
VB.NET:
Set TempDB = New ADODB.Connection
TempDB.Properties("Prompt") = adPromptComplete
TempDB.Open "DSN=" & DSN_NAME
What would be the .NET equivalent to the above code, especially for Line #2?
I do know that you can reference a .dll and import the ADODB namespace, but I wanted to find out if there was another way to do this.
Any questions or suggestions would be appreciated.
Thanks!