How can I display a database open dialog?

Question

Is there a way to display database open dialog from SQL server in my .NET application (the same way I can display a file open dialog, or font dialog) ?

Answer 1

you can always write custom. I don't think that there is one like open file open dialog, because last one is build into OS.

Answer 2

There is a class called SQLDataSourceEnumerator that should be the best option for you to get a list of available SQL instances (not sure if it works with named instances in SQL Express)

Also, as long as you can connect to an instance of SQL and have access to the master DB, yo ucan use any number of methods in articles on the web to enumerate DBs:

CodeProject

C# Online

Good luck