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; }