Display a ConnectionString dialog

The data connection dialog component linked to in this answer is no longer available for download.

However, a (apparently somewhat altered) DataConnectionDialog component has since become available on NuGet.

Installation:

Add the component to your Visual Studio project via the NuGet package manager console:

Install-Package DataConnectionDialog

Usage example:

// using Microsoft.Data.ConnectionUI;// using System.Windows.Forms;bool TryGetDataConnectionStringFromUser(out string outConnectionString){    using (var dialog = new DataConnectionDialog())    {        // If you want the user to select from any of the available data sources, do this:        DataSource.AddStandardDataSources(dialog);        // OR, if you want only certain data sources to be available        // (e.g. only SQL Server), do something like this instead:         dialog.DataSources.Add(DataSource.SqlDataSource);        dialog.DataSources.Add(DataSource.SqlFileDataSource);        …        // The way how you show the dialog is somewhat unorthodox; `dialog.ShowDialog()`        // would throw a `NotSupportedException`. Do it this way instead:        DialogResult userChoice = DataConnectionDialog.Show(dialog);        // Return the resulting connection string if a connection was selected:        if (userChoice == DialogResult.OK)        {             outConnectionString = dialog.ConnectionString;            return true;        }        else        {            outConnectionString = null;            return false;        }    }}

Note: The dialog component referred to below is no longer available for download. Unless you have retrieved it in the past, you will probably not get this answer's sample code to work.

Alternative: There is now a different DataConnectionDialog available on NuGet. See this answer for details.

"Data Connection Dialog" on MSDN Archive Gallery (broken as of 1 Sept. 2015)

The data connection dialog is a database tool component released with Visual Studio. It allows users to build connection strings and to connect to specific data sources. try this..

C# Sample:

static void Main(string[] args){    DataConnectionDialog dcd = new DataConnectionDialog();    DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);    dcs.LoadConfiguration(dcd);    if (DataConnectionDialog.Show(dcd) == DialogResult.OK)    {        // load tables        using (SqlConnection connection = new SqlConnection(dcd.ConnectionString))        {            connection.Open();            SqlCommand cmd = new SqlCommand("SELECT * FROM sys.Tables", connection);            using (SqlDataReader reader = cmd.ExecuteReader())            {                while (reader.Read())                {                    Console.WriteLine(reader.HasRows);                }            }        }    }    dcs.SaveConfiguration(dcd);}

Here source code also available. we can integrate and redistribute the source code with our application according to license.

Yes and no.

Yes, it is technically possible, but I urge you not to; that dialog is part of Visual Studio and is lot listed in "redist". My interpretation is that you are not free to redistribute this dll.