Connection String Builder

  • Thread starter Thread starter Ahmed Hashish
  • Start date Start date
A

Ahmed Hashish

Dear Sir
I have a UserControl with a property called 'ConnectionString', How I
could trigger the connection string builder to allow users to generate that
string in the property sheet.

Thanks
Ahmed
 
Ahmed,

Are you looking for something this ?
\\\
Dim strMake As New System.Text.StringBuilder
strMake.Append(StrText)
mStrMake = strMake.ToString
///

I hope this will help a little bit?

Cor
 
Dear Cor
Thanks for replay
I mean how to trigger the wizard that build the database connection
string.
I'm building UserControl that connect to a database, and I created a
property called 'ConnectionString' . The users of that control will enter
the database connection string in the property sheet. I want to add a build
button for this property in the property sheet to open the wizard that build
the database connection string.

Thanks
Ahmed
 
This works in VB6:

set a reference to Microsoft OLEDB Service Component 1.0 Type Library.
then in code:
Dim x As New MSDASC.DataLinks
Debug.Print x.PromptNew

I tried it in .NET and the wizard comes up, but I haven't yet figured
out how to retrieve the connection string.

Hope this helps

Gary
 
Back
Top