Results 1 to 3 of 3

Thread: Any controls to show data source selection?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2000
    Posts
    1,091

    Any controls to show data source selection?

    I want to include the ability for the end user to create connections to different databases using the same (or similar) dialogs that are available at design time, such as the Connection String builder, Selection Data Source (ODBC) screen, etc. Is this something built into .NET or only available via third party/custom controls?

    Any help would be appreciated.

    Visual Studio 2010

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,222

    Re: Any controls to show data source selection?

    It would be fairly simply to create your own dialogue for setting connections properties. If you have SQL Server installed then you could probably use SMO to display the inbuilt dialogues. As for the Data Link Properties dialogue, that is part of Windows. You can open that by creating a file with a ".udl" extension and opening it by calling Process.Start. When the dialogue is closed, the file will contain the connection string.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2000
    Posts
    1,091

    Re: Any controls to show data source selection?

    Quote Originally Posted by jmcilhinney View Post
    It would be fairly simply to create your own dialogue for setting connections properties. If you have SQL Server installed then you could probably use SMO to display the inbuilt dialogues. As for the Data Link Properties dialogue, that is part of Windows. You can open that by creating a file with a ".udl" extension and opening it by calling Process.Start. When the dialogue is closed, the file will contain the connection string.
    Interesting about the udl file. I'll give that a shot, thanks!

    Visual Studio 2010

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width