private DataSource GetDataSourceFromDataProvider(DataProvider p) { if (p == Microsoft.Data.ConnectionUI.DataProvider.SqlDataProvider) return Microsoft.Data.ConnectionUI.DataSource.SqlDataSource; else if (p == Microsoft.Data.ConnectionUI.DataProvider.OdbcDataProvider) return Microsoft.Data.ConnectionUI.DataSource.OdbcDataSource; else if (p == Microsoft.Data.ConnectionUI.DataProvider.OleDBDataProvider) return Microsoft.Data.ConnectionUI.DataSource.OdbcDataSource; else if (p == Microsoft.Data.ConnectionUI.DataProvider.OracleDataProvider) return Microsoft.Data.ConnectionUI.DataSource.OracleDataSource; else return null; }
public string Change(string connString = "") { string tempConnString = !string.IsNullOrEmpty(connString) ? connString : this.ConnString; try { if (string.IsNullOrEmpty(tempConnString)) return this.GetConnString(); if (tempConnString.Equals(this.Dialog.ConnectionString)) return this.GetConnString(); if (tempConnString.ToLower().Contains("provider")) { if (tempConnString.ToLower().Contains("msdaora")) { this.DataSource = DataSource.OracleDataSource; } else { this.DataSource = DataSource.SqlDataSource; } this.Provider = DataProvider.OleDBDataProvider; } else { this.DataSource = tempConnString.ToLower().Contains("unicode") ? DataSource.OracleDataSource : DataSource.SqlDataSource; this.Provider = tempConnString.ToLower().Contains("unicode") ? DataProvider.OracleDataProvider : DataProvider.SqlDataProvider; } if (!Dialog.DataSources.Contains(this.DataSource)) Dialog.DataSources.Add(this.DataSource); Dialog.SelectedDataSource = this.DataSource; foreach (DataProvider objDataProvider in Dialog.SelectedDataSource.Providers) { if (objDataProvider.Name == "System.Data.OleDb" && this.Provider.Equals(DataProvider.OleDBDataProvider)) { Dialog.SelectedDataProvider = objDataProvider; break; } if (objDataProvider.Name == "System.Data.OracleClient" && this.Provider.Equals(DataProvider.OracleDataProvider)) { Dialog.SelectedDataProvider = objDataProvider; break; } if (objDataProvider.Name == "System.Data.SqlClient" && this.Provider.Equals(DataProvider.SqlDataProvider)) { Dialog.SelectedDataProvider = objDataProvider; break; } } if (!string.IsNullOrEmpty(tempConnString)) { Dialog.ConnectionString = tempConnString; } } catch { } return this.GetConnString(); }
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; } }
public string GetConnString() { if (DataConnectionDialog.Show(this.Dialog) == DialogResult.OK) { this.ConnString = Dialog.ConnectionString; this.DataSource = Dialog.SelectedDataSource; this.Provider = Dialog.SelectedDataProvider; } return this.ConnString; }