Use Microsoft.Data.DataConnectionDialog in your projects to retrieve connection string
28-May-1414 Leave a comment
This is the use of the Visual Studio connection dialog in your own projects, for instance tool kits to inspect databases. Steps are:
- NuGet
- Search and add Data Connection (Windows Forms)
- Add code, sample is in VB, but C# is similar
Imports Microsoft.Data.ConnectionUI Private Sub GetDataConnection() Dim dcd As New DataConnectionDialog DataSource.AddStandardDataSources(dcd) dcd.SelectedDataSource = DataSource.SqlDataSource If DataConnectionDialog.Show(dcd) = Windows.Forms.DialogResult.OK Then Select Case dcd.SelectedDataProvider.Name Case DataProvider.SqlDataProvider.Name Dim cn As New SqlClient.SqlConnection(dcd.ConnectionString) DataSourceToolStripTextBox.Text = cn.DataSource DatabaseDefaultToolStripTextBox.Text = cn.Database 'MessageBox.Show(String.Concat("Found SQL: ", cn.ConnectionString)) Case Else MessageBox.Show(dcd.ConnectionString) End Select End If End Sub
See also
http://wildermuth.com/2007/1/29/Using_the_Visual_Studio_Connection_String_Dialog