private void btnConnection_Click(object sender, EventArgs e)
{
Microsoft.Data.ConnectionUI.DataConnectionDialog _dialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
Microsoft.Data.ConnectionUI.DataSource.AddStandardDataSources(_dialog);
Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(_dialog);
txtString.Text = "ConnectionString: " + _dialog.ConnectionString;
}
public static String getConnect()
{
String curentDirectory = Directory.GetCurrentDirectory();
String path = Directory.GetCurrentDirectory() + @"\config.txt";
if (!File.Exists(path))
{
Microsoft.Data.ConnectionUI.DataConnectionDialog _dialog = new
Microsoft.Data.ConnectionUI.DataConnectionDialog();
Microsoft.Data.ConnectionUI.DataSource.AddStandardDataSources(_dialog);
Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(_dialog);
if (_dialog.DialogResult.ToString().Equals("OK"))
{
using (FileStream fs = new FileStream(path, FileMode.Create))
{
using (StreamWriter writer = new StreamWriter(fs, Encoding.UTF8))
{
String connec = _dialog.ConnectionString;
writer.WriteLine(connec);
writer.Close();
}
}
}
try
{
FileStream stream = new FileStream(path, FileMode.Open);
StreamReader reader = new StreamReader(stream);
result = reader.ReadLine();
reader.Close();
}
catch (FileNotFoundException ex) { }
}
else
{
FileStream stream = new FileStream(path, FileMode.Open);
StreamReader reader = new StreamReader(stream);
result = reader.ReadLine();
reader.Close();
}
return(result);
}
/// <summary>
/// Gets VS.NET comes with a database connection dialog database connection information
/// </Summary>
/// <param name = "conn" > initialize the connection string </param>
/// The<returns> database connection</returns>
public static string GetDatabaseConnectionString(string conn)
{
var connString = string.Empty;
var connDialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
// Add a data source list, you can add their own procedures required type of data source to the window must increase the following in any of eleven
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.AccessDataSource); // Access
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.OdbcDataSource); // ODBC
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.OracleDataSource); // Oracle
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.SqlDataSource); // Sql Server
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.SqlFileDataSource); // Sql Server File
// Initialize
connDialog.SelectedDataSource = Microsoft.Data.ConnectionUI.DataSource.SqlDataSource;
connDialog.SelectedDataProvider = Microsoft.Data.ConnectionUI.DataProvider.SqlDataProvider;
connDialog.ConnectionString = conn;
// Can only through DataConnectionDialog class static method Show dialog box
// Use Dialog.Show, (),, or dialog.ShowDialog() to render the dialog box
if (Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(connDialog) == DialogResult.OK)
{
connString = connDialog.ConnectionString;
}
return(connString);
}
// 首先添加对Microsoft.Data.ConnectionUI.Dialog.dll的引用，这个assembly在VS2005的安装目录下，
// D:\Program Files\Microsoft Visual Studio 8\Common7\IDE下边，我的VS安装在D盘，下面是代码：
//引用 Microsoft.Data.ConnectionUI.Dialog.dll 文件
//using System;
//using System.Collections.Generic;
//using System.Text;
//using Microsoft.Data.ConnectionUI;
//using System.Windows.Forms;
/// <summary>
/// 获取VS.NET 自带的数据库连接对话框的数据库连接信息
/// </summary>
/// <param name="conn">初始化连接字符串</param>
/// <returns>数据库连接</returns>
public string GetDatabaseConnectionString(String conn)
{
string connString = String.Empty;
Microsoft.Data.ConnectionUI.DataConnectionDialog connDialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
// 添加数据源列表，可以向窗口中添加自己程序所需要的数据源类型 必须增加以下几项中任一一项
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.AccessDataSource); // Access
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.OdbcDataSource); // ODBC
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.OracleDataSource); // Oracle
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.SqlDataSource); // Sql Server
connDialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.SqlFileDataSource); // Sql Server File
// 初始化
connDialog.SelectedDataSource = Microsoft.Data.ConnectionUI.DataSource.SqlDataSource;
connDialog.SelectedDataProvider = Microsoft.Data.ConnectionUI.DataProvider.SqlDataProvider;
connDialog.ConnectionString = conn;
//只能够通过DataConnectionDialog类的静态方法Show出对话框
//不同使用dialog.Show()或dialog.ShowDialog()来呈现对话框
if (Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(connDialog) == DialogResult.OK)
{
connString = connDialog.ConnectionString;
}
return connString;
}
