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);
}
protected void ShowDCD(DataConnectionDialog dcd, Label lab)
{
if (DataConnectionDialog.Show(dcd, this) == DialogResult.OK)
{
lab.Text = dcd.DisplayConnectionString;
}
}
public DataConnectionSourceDialog(DataConnectionDialog mainDialog)
: this()
{
Debug.Assert(mainDialog != null);
_mainDialog = mainDialog;
}
public string EditConnectionString(string odbcConnectionString) {
do {
using (var dlg = new DataConnectionDialog()) {
DataSource.AddStandardDataSources(dlg);
dlg.SelectedDataSource = DataSource.SqlDataSource;
dlg.SelectedDataProvider = DataProvider.SqlDataProvider;
try {
dlg.ConnectionString = (odbcConnectionString.OdbcToSqlClient()
?? _odbcConnectionString.OdbcToSqlClient())
?? _defaultSqlConnectionString;
var result = DataConnectionDialog.Show(dlg);
switch(result) {
case DialogResult.Cancel:
return null;
case DialogResult.OK:
_odbcConnectionString = dlg.ConnectionString.SqlClientToOdbc();
break;
}
break;
} catch (ArgumentException) {
if (_coreShell.ShowMessage(Resources.Error_ConnectionStringFormat, MessageButtons.YesNo) == MessageButtons.No) {
break;
}
_odbcConnectionString = _defaultSqlConnectionString.SqlClientToOdbc();
}
}
} while (true);
return _odbcConnectionString;
}
public string GetConnectionString(string connection)
{
string connectionString = connection;
try
{
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
DataConnectionDialog dcd = new DataConnectionDialog();
//EF CONN STR to SQL CONNECTION
EntityConnectionStringBuilder efstr = new EntityConnectionStringBuilder(connection);
dcs.LoadConfiguration(dcd);
dcd.ConnectionString = efstr.ProviderConnectionString;
if (DataConnectionDialog.Show(dcd) == System.Windows.Forms.DialogResult.OK)
{
connectionString = dcd.ConnectionString;
}
dcs.SaveConfiguration(dcd);
//SQL CONNECTION TO EF CONN STR
SqlConnectionStringBuilder sqlstr = new SqlConnectionStringBuilder(dcd.ConnectionString);
efstr.ProviderConnectionString = sqlstr.ConnectionString;
connectionString = efstr.ConnectionString;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return connectionString;
}
private static string EditConnectionString(string odbcConnectionString) {
var sqlConnectionString = odbcConnectionString.OdbcToSqlClient();
do {
using (var dlg = new DataConnectionDialog()) {
DataSource.AddStandardDataSources(dlg);
dlg.SelectedDataSource = DataSource.SqlDataSource;
dlg.SelectedDataProvider = DataProvider.SqlDataProvider;
try {
dlg.ConnectionString = sqlConnectionString ?? DefaultSqlConnectionString;
var result = DataConnectionDialog.Show(dlg);
switch (result) {
case System.Windows.Forms.DialogResult.Cancel:
return null;
case System.Windows.Forms.DialogResult.OK:
return dlg.ConnectionString.SqlClientToOdbc();
}
} catch (ArgumentException) {
if (MessageBox.Show(Strings.ConnectionStringFormatIncorrect, Strings.ProductTitle, MessageBoxButton.YesNo) == MessageBoxResult.No) {
return odbcConnectionString;
}
sqlConnectionString = DefaultSqlConnectionString;
} catch (InvalidOperationException ex) {
MessageBox.Show(ex.Message);
break;
}
}
} while (true);
return null;
}
private void button2_Click(object sender, EventArgs e)
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
textBox2.Text = dcd.ConnectionString;
connectionString = dcd.ConnectionString;
comboBox1.Enabled = true;
using (SqlCeConnection con = new SqlCeConnection(connectionString))
{
comboBox1.Items.Clear();
con.Open();
using (SqlCeCommand command = new SqlCeCommand("SELECT table_name FROM INFORMATION_SCHEMA.Tables", con))
{
SqlCeDataReader reader = command.ExecuteReader();
while (reader.Read())
{
comboBox1.Items.Add(reader.GetString(0));
}
}
}
//textBox1.Text = dcd.SelectedDataSource.DisplayName;
}
dcs.SaveConfiguration(dcd);
}
public AddPropertyDialog(DataConnectionDialog mainDialog)
: this()
{
Debug.Assert(mainDialog != null);
_mainDialog = mainDialog;
}
private static DataConnectionDialog CreateDataConnectionDialog()
{
var dialog = new DataConnectionDialog();
dialog.DataSources.Add(DataSource.SqlDataSource);
// TODO: русские названия кнопок
return dialog;
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataSource.AddStandardDataSources(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
connection = dcd.ConnectionString;
label5Connection.Text = connection ?? ConfigurationManager.ConnectionStrings["LogsDB"].ConnectionString;
}
}
public static string GetConnectionStringFromDialog()
{
DataConnectionDialog dcd = new DataConnectionDialog();
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
return dcd.ConnectionString;
}
return string.Empty;
}
/// <summary>
/// 手动选择数据源和数据提供程序
/// </summary>
/// <returns>返回连接字符串</returns>
public static string GetConnectionString()
{
string connection = null;
DataConnectionDialog dialog = new DataConnectionDialog();
DataSource.AddStandardDataSources(dialog);
if (DataConnectionDialog.Show(dialog) == DialogResult.OK)
{
connection = dialog.ConnectionString;
}
return connection;
}
public DataConnectionAdvancedDialog(IDataConnectionProperties connectionProperties, DataConnectionDialog mainDialog)
: this()
{
Debug.Assert(connectionProperties != null);
Debug.Assert(mainDialog != null);
_savedConnectionString = connectionProperties.ToFullString();
this.propertyGrid.SelectedObject = connectionProperties;
_mainDialog = mainDialog;
}
public CommonConnectionStringDialog()
{
this._connectionDialog = new DataConnectionDialog();
this._connectionDialog.DataSources.Add(DataSource.OdbcDataSource);
this._connectionDialog.DataSources.Add(DataSource.SqlDataSource);
this._connectionDialog.SelectedDataSource = DataSource.SqlDataSource;
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(_connectionDialog);
}
private void buttonMakeString_Click(object sender, EventArgs e)
{
var d = new DataConnectionDialog();
DataSource.AddStandardDataSources(d);
var result = DataConnectionDialog.Show(d);
if (result == System.Windows.Forms.DialogResult.OK)
{
textBoxConnection.Text = d.ConnectionString;
var provider = d.GetSelectedDataProvider(d.SelectedDataSource);
textBoxProvider.Text = provider.Name;
}
}
public frmOptionsDialog( EmdrConfig _cfg)
{
dcd = new DataConnectionDialog();
InitializeComponent();
dcd.ConnectionString = _cfg.Attr.DataSource;
tbDataBaseConnName.Text = _cfg.Attr.DataSource;
tbHistTrimDays.Text = _cfg.Attr.TrimHistDays.ToString();
tbOrdTrimDays.Text = _cfg.Attr.TrimOrdersDays.ToString();
cbEmdrServer.Text = _cfg.Attr.EMDRServer;
cbMergeDuplicates.Checked = _cfg.Attr.MergeDuplicates;
}
private void GetConnectionDetails()
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
DataConnectionDialog.Show(dcd);
m_GuiDbProviderTextBox.Text = dcd.SelectedDataProvider.Name;
m_GuiConnectionString.Text = dcd.ConnectionString;
//m_DbConnectionType = dcd.SelectedDataProvider.TargetConnectionType.ToString();
miscSettingsModelBindingSource.EndEdit();
}
// Обработчики сообщений.
private void connectionsBtn_Click(object sender, EventArgs e)
{
DataConnectionDialog connectionDlg = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(connectionDlg);
if (DataConnectionDialog.Show(connectionDlg) == DialogResult.OK)
{
this.connectionStringTxt.Text = connectionDlg.ConnectionString;
}
dcs.SaveConfiguration(connectionDlg);
sqlStorage = new SQLResultStorage(new ConnectionStringSettings("temporaryconnection",
this.connectionStringTxt.Text, "System.Data.SqlClient"));
}
private void btChoose_Click(object sender, EventArgs e)
{
DataConnectionDialog dialog = new DataConnectionDialog();
dialog.DataSources.Add(DataSource.SqlDataSource);
dialog.DataSources.Add(DataSource.OracleDataSource);
dialog.DataSources.Add(DataSource.OdbcDataSource);
dialog.DataSources.Add(DataSource.AccessDataSource);
dialog.DataSources.Add(DataSource.SqlFileDataSource);
dialog.SelectedDataSource = DataSource.SqlDataSource;
dialog.SelectedDataProvider = DataProvider.SqlDataProvider;
if (DataConnectionDialog.Show(dialog) == DialogResult.OK)
{
this.connectionString = dialog.ConnectionString;
this.dbProvider = dialog.SelectedDataProvider;
}
}
private void AddConnection_Click(object sender, EventArgs e)
{
dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (dcd.SelectedDataProvider != null && dcd.SelectedDataSource != null)
{
dcd.ConnectionString = ConnectionString;
}
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
textBoxConnStr.Text = dcd.ConnectionString;
}
dcs.SaveConfiguration(dcd);
}
public void LoadConfiguration(DataConnectionDialog dialog)
{
dialog.DataSources.Add(DataSource.SqlDataSource);
dialog.DataSources.Add(DataSource.SqlFileDataSource);
dialog.DataSources.Add(DataSource.OracleDataSource);
dialog.DataSources.Add(DataSource.AccessDataSource);
dialog.DataSources.Add(DataSource.OdbcDataSource);
dialog.DataSources.Add(SqlCe.SqlCeDataSource);
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.SqlDataProvider);
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.OracleDataProvider);
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.OleDBDataProvider);
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.OdbcDataProvider);
dialog.DataSources.Add(dialog.UnspecifiedDataSource);
this.dataSources = new Dictionary<string, DataSource>();
this.dataSources.Add(DataSource.SqlDataSource.Name, DataSource.SqlDataSource);
this.dataSources.Add(DataSource.SqlFileDataSource.Name, DataSource.SqlFileDataSource);
this.dataSources.Add(DataSource.OracleDataSource.Name, DataSource.OracleDataSource);
this.dataSources.Add(DataSource.AccessDataSource.Name, DataSource.AccessDataSource);
this.dataSources.Add(DataSource.OdbcDataSource.Name, DataSource.OdbcDataSource);
this.dataSources.Add(SqlCe.SqlCeDataSource.Name, SqlCe.SqlCeDataSource);
this.dataSources.Add(dialog.UnspecifiedDataSource.DisplayName, dialog.UnspecifiedDataSource);
this.dataProviders = new Dictionary<string, DataProvider>();
this.dataProviders.Add(DataProvider.SqlDataProvider.Name, DataProvider.SqlDataProvider);
this.dataProviders.Add(DataProvider.OracleDataProvider.Name, DataProvider.OracleDataProvider);
this.dataProviders.Add(DataProvider.OleDBDataProvider.Name, DataProvider.OleDBDataProvider);
this.dataProviders.Add(DataProvider.OdbcDataProvider.Name, DataProvider.OdbcDataProvider);
this.dataProviders.Add(SqlCe.SqlCeDataProvider.Name, SqlCe.SqlCeDataProvider);
DataSource ds = null;
string dsName = this.GetSelectedSource();
if (!String.IsNullOrEmpty(dsName) && this.dataSources.TryGetValue(dsName, out ds))
{
dialog.SelectedDataSource = ds;
}
DataProvider dp = null;
string dpName = this.GetSelectedProvider();
if (!String.IsNullOrEmpty(dpName) && this.dataProviders.TryGetValue(dpName, out dp))
{
dialog.SelectedDataProvider = dp;
}
}
private void GetConnectionSettings()
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
#region set the text boxes according to the connection settings
if (dcd.SelectedDataSource != null)
{
if (dcd.SelectedDataSource == dcd.UnspecifiedDataSource)
{
if (dcd.SelectedDataProvider != null)
{
m_GuiDbProviderTextBox.Text = dcd.SelectedDataProvider.DisplayName;
}
else
{
m_GuiDbProviderTextBox.Text = null;
}
}
else
{
m_GuiDbProviderTextBox.Text = dcd.SelectedDataSource.DisplayName;
if (dcd.SelectedDataProvider != null)
{
if (dcd.SelectedDataProvider.ShortDisplayName != null)
{
m_GuiDbProviderTextBox.Text = String.Format("{0} ({1})", m_GuiDbProviderTextBox.Text, dcd.SelectedDataProvider.ShortDisplayName);
}
}
}
}
else
{
m_GuiDbProviderTextBox.Text = null;
}
m_GuiConnectionStringTextBox.Text = dcd.ConnectionString;
ChangeStateToDirty();
#endregion
}
}
void item_Click(object sender, EventArgs e)
{
try
{
DataSource sqlDataSource = new DataSource("MicrosoftSqlServer", "Microsoft SQL Server");
sqlDataSource.Providers.Add(DataProvider.SqlDataProvider);
DataConnectionDialog dcd = new DataConnectionDialog();
dcd.DataSources.Add(sqlDataSource);
dcd.SelectedDataProvider = DataProvider.SqlDataProvider;
dcd.SelectedDataSource = sqlDataSource;
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
string connectionString = dcd.ConnectionString;
string fileName;
ToolStripMenuItem item = (ToolStripMenuItem)sender;
Scope scope = (Scope)item.Tag;
SaveFileDialog fd = new SaveFileDialog();
fd.AutoUpgradeEnabled = true;
fd.Title = "Save generated database script as";
fd.Filter = "SQL Server Compact Script (*.sqlce)|*.sqlce|SQL Server Script (*.sql)|*.sql|All Files(*.*)|";
fd.OverwritePrompt = true;
fd.ValidateNames = true;
if (fd.ShowDialog() == DialogResult.OK)
{
fileName = fd.FileName;
using (IRepository repository = new ServerDBRepository(connectionString))
{
var generator = new Generator(repository, fd.FileName);
System.Windows.Forms.MessageBox.Show(generator.ScriptDatabaseToFile(scope));
}
}
}
}
catch (System.Data.SqlClient.SqlException sql)
{
Connect.ShowErrors(sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public DialogResult ShowDialog()
{
ConnectionData = new ConnectionData();
using (DataConnectionDialog dcd = new DataConnectionDialog())
{
DataSource.AddStandardDataSources(dcd);
dcd.SelectedDataSource = DataSource.SqlDataSource;
dcd.SelectedDataProvider = DataProvider.SqlDataProvider;
var dialogResult = DataConnectionDialog.Show(dcd);
if (dialogResult == DialogResult.OK)
{
ConnectionData = new ConnectionData(dcd.ConnectionString);
}
return dialogResult;
}
}
static void Main(string[] args)
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(dcd.SelectedDataProvider.Name);
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = dcd.ConnectionString;
connection.Open();
var command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM INFORMATION_SCHEMA.TABLES";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader["name"]);
}
}
}
// 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);
}
/// <summary>
/// 枚举格式
/// </summary>
/// <param name="dataSourceType">数据提供类型 VS2008Dlg.DataSourceType</param>
/// <returns>返回连接字符串</returns>
public static string GetConnectionString(DataSourceType dataSourceType)
{
string connection = null;
DataConnectionDialog dialog = new DataConnectionDialog();
DataSource.AddStandardDataSources(dialog);
dialog.SelectedDataSource = ConvertToDaSource(dataSourceType);
if (ConvertToDaProvider(dataSourceType) != null)
{
dialog.SelectedDataProvider = ConvertToDaProvider(dataSourceType);
}
if (DataConnectionDialog.Show(dialog) == DialogResult.OK)
{
connection = dialog.ConnectionString;
}
return connection;
}
public void LoadConfiguration(DataConnectionDialog dialog, DatabaseServerType serverType)
{
this._dataSources = new Dictionary<string, DataSource>();
this._dataProviders = new Dictionary<string, DataProvider>();
switch (serverType)
{
case DatabaseServerType.Oracle:
dialog.DataSources.Add(DataSource.OracleDataSource);
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.OracleDataProvider);
this._dataSources.Add(DataSource.OracleDataSource.Name, DataSource.OracleDataSource);
this._dataProviders.Add(DataProvider.OracleDataProvider.Name, DataProvider.OracleDataProvider);
break;
case DatabaseServerType.SqlServer:
dialog.DataSources.Add(DataSource.SqlDataSource);
this._dataSources.Add(DataSource.SqlDataSource.Name, DataSource.SqlDataSource);
this._dataProviders.Add(DataProvider.SqlDataProvider.Name, DataProvider.SqlDataProvider);
break;
default:
dialog.UnspecifiedDataSource.Providers.Add(DataProvider.OleDBDataProvider);
this._dataProviders.Add(DataProvider.OleDBDataProvider.Name, DataProvider.OleDBDataProvider);
dialog.DataSources.Add(dialog.UnspecifiedDataSource);
this._dataSources.Add(dialog.UnspecifiedDataSource.DisplayName, dialog.UnspecifiedDataSource);
break;
}
DataSource ds = null;
string dsName = this.GetSelectedSource();
if (!String.IsNullOrEmpty(dsName) && this._dataSources.TryGetValue(dsName, out ds))
{
dialog.SelectedDataSource = ds;
}
DataProvider dp = null;
string dpName = this.GetSelectedProvider();
if (!String.IsNullOrEmpty(dpName) && this._dataProviders.TryGetValue(dpName, out dp))
{
dialog.SelectedDataProvider = dp;
}
}
//Hàm mở connection dialog
public static void OpenConnDialog()
{
string path = Directory.GetCurrentDirectory() + @"\config.txt";
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();
}
}
}
}
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
{
if (((context != null) && (context.Instance != null)) && (provider != null))
{
DataConnectionDialog dialog = new DataConnectionDialog();
dialog.DataSources.Add(DataSource.SqlDataSource);
dialog.DataSources.Add(DataSource.OracleDataSource);
dialog.DataSources.Add(DataSource.OdbcDataSource);
dialog.DataSources.Add(DataSource.AccessDataSource);
dialog.SelectedDataSource = DataSource.SqlDataSource;
dialog.SelectedDataProvider = DataProvider.SqlDataProvider;
IWindowsFormsEditorService service = provider.GetService(typeof(IWindowsFormsEditorService)) as IWindowsFormsEditorService;
if (DataConnectionDialog.Show(dialog) == DialogResult.OK)
{
value = dialog.ConnectionString;
}
}
if (LoggingService.IsDebugEnabled)
{
LoggingService.DebugFormatted("设置的数据库连接字符串是:{0}", new object[] { value });
}
return value;
}
public static bool TryGetDatabaseConnection(ref Type connectionType, ref string connectionString)
{
DialogResult dialogResult;
Type _connectionType = connectionType;
using (DataConnectionDialog dataConnectionDialog = new DataConnectionDialog())
{
DataConnectionConfiguration dataConnectionConfiguration;
dataConnectionConfiguration = new DataConnectionConfiguration(null);
dataConnectionConfiguration.LoadConfiguration(dataConnectionDialog);
//dataConnectionDialog.ConnectionString = connectionString ?? string.Empty;
/*var useThisOne = dataConnectionDialog.DataSources.Where(ds => (object)ds.DefaultProvider != null && ds.DefaultProvider.TargetConnectionType == _connectionType).Select(ds => new { DataSource = ds, DataProvider = ds.DefaultProvider }).SingleOrDefault();
if ((object)useThisOne != null)
{
dataConnectionDialog.SelectedDataProvider = useThisOne.DataProvider;
dataConnectionDialog.SelectedDataSource = useThisOne.DataSource;
dataConnectionDialog.ConnectionString = connectionString ?? string.Empty;
}*/
dialogResult = DataConnectionDialog.Show(dataConnectionDialog);
if (dialogResult == DialogResult.OK)
{
connectionString = dataConnectionDialog.ConnectionString;
if ((object)dataConnectionDialog.SelectedDataSource != null &&
(object)dataConnectionDialog.SelectedDataSource.DefaultProvider != null)
connectionType = dataConnectionDialog.SelectedDataSource.DefaultProvider.TargetConnectionType;
}
}
return dialogResult == DialogResult.OK;
}
