private void frmGenerate_Load(object sender, EventArgs e)
{
// Load previous settings
if (!string.IsNullOrEmpty(Properties.Settings.Default.LastDropFolder))
{
this.txtFolder.Text = Properties.Settings.Default.LastDropFolder;
}
this.chkCreateIndex.Checked = Properties.Settings.Default.LastIndexChoice;
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
Globals.ConnectionString = dcd.ConnectionString;
// Populate the table list
LoadTableList();
}
else
{
this.Close();
}
}
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);
}
/// <summary>
/// Connection (and reconnection) to the database using Microsoft's native interface
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void connect(object sender, EventArgs e)
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcc = new DataConnectionConfiguration(null);
dcc.LoadConfiguration(dcd);
// Initialize connection string from current or previous (saved) connection string
if (mySqlServer1.ConnectionPool.GetConnection(0) != null && mySqlServer1.ConnectionPool.GetConnection(0).State == ConnectionState.Open)
{
dcd.ConnectionString = mySqlServer1.ConnectionPool.GetConnection(0).ConnectionString;
}
else if (!string.IsNullOrEmpty(AppSettings.Default.LastConnectionString))
{
dcd.ConnectionString = AppSettings.Default.LastConnectionString;
}
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
AppSettings.Default.LastConnectionString = dcd.ConnectionString;
AppSettings.Default.Save();
dcc.SaveConfiguration(dcd);
var succ = mySqlServer1.RefreshServers(dcd.ConnectionString);
if (succ)
{
DatabaseBrowserDockForm.RefreshObjects();
}
}
}
public DataConnectionSourceDialog()
{
InitializeComponent();
DbWorkarounds.SNILoadWorkaround();
DataConnectionConfiguration config = new DataConnectionConfiguration();
_dataSources = config.DataSources;
}
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);
}
/// <summary>
/// Create connection string using Microsoft's ConnectionUI class
/// </summary>
/// <param name="DataSource">Default catalog</param>
/// <param name="SaveConfiguration">true to save, false not to save</param>
/// <returns></returns>
public bool GetConnection(ref string DataSource, bool SaveConfiguration = false)
{
var success = false;
var dcd = new DataConnectionDialog();
var 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;
ConnectionString = connection.ConnectionString;
DataSource = connection.DataSource;
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM INFORMATION_SCHEMA.TABLES";
var dt = new DataTable();
dt.Load(cmd.ExecuteReader());
TableNames = dt.AsEnumerable()
.Select(row => row.Field <string>("table_name"))
.OrderBy(field => field)
.ToList();
}
var builder = new SqlConnectionStringBuilder()
{
ConnectionString = dcd.ConnectionString
};
ServerName = builder.DataSource;
InitialCatalog = builder.InitialCatalog;
if (SaveConfiguration)
{
dcs.SaveConfiguration(dcd);
}
if (TableNames.Count > 0)
{
success = true;
}
}
return(success);
}
private void BuildConnStringBtn_Click(object sender, RoutedEventArgs e)
{
var connectionDialog = new DataConnectionDialog();
var connectionConfig = new DataConnectionConfiguration(null);
connectionConfig.LoadConfiguration(connectionDialog);
System.Windows.Forms.DialogResult result = DataConnectionDialog.Show(connectionDialog);
if (result == System.Windows.Forms.DialogResult.OK)
{
_dataContext.ConnectionString = connectionDialog.ConnectionString;
}
}
private void browseButton_Click(object sender, EventArgs e)
{
var dcd = new DataConnectionDialog();
var dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) != DialogResult.OK)
{
return;
}
conTextBox.Text = dcd.ConnectionString;
_setting.ConnectionString = dcd.ConnectionString;
}
private DataConnectionDialog GetDataConnectionDialog()
{
DataConnectionDialog connectionDialog = new DataConnectionDialog();
connectionDialog.DataSources.Add(DataSource.OdbcDataSource);
connectionDialog.DataSources.Add(DataSource.SqlDataSource);
connectionDialog.SelectedDataSource = DataSource.SqlDataSource;
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(connectionDialog);
return(connectionDialog);
}
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 string GetConnectionString()
{
string connectionString = null;
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
connectionString = dcd.ConnectionString;
}
dcs.SaveConfiguration(dcd);
return(connectionString);
}
private void выборПодключенияToolStripMenuItem_Click(object sender, EventArgs e)
{
string connectionString = null;
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
connectionString = dcd.ConnectionString;
}
dcs.SaveConfiguration(dcd);
File.WriteAllText(@"connectionsString.connstr", connectionString);
}
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);
}
private void DestButton_Click(object sender, EventArgs e)
{
_connection2 = null;
DataConnectionDialog dialog = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dialog);
if (DataConnectionDialog.Show(dialog) == DialogResult.OK)
{
_connection2 = new SqlConnection(dialog.ConnectionString);
_connection2.Open();
toolTip1.SetToolTip(DestButton, _connection2.ConnectionString);
RefreshTables(_connection2, lst2);
}
}
private void LoadConfiguration()
{
var config = ConfigurationManager.OpenExeConfiguration("ClearOffice.exe");
ConnectionStringsSection section = config.ConnectionStrings;
var setting = section.ConnectionStrings["ClearOfficeEntities"];
var dcd = new DataConnectionDialog();
var dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
var conString =
"metadata=res://*/ClearOfficeModel.csdl|res://*/ClearOfficeModel.ssdl|res://*/ClearOfficeModel.msl;provider=System.Data.SqlClient;provider connection string=\"";
conString += dcd.ConnectionString;
conString += ";multipleactiveresultsets=True;App=EntityFramework\"";
setting.ConnectionString = conString;
config.Save(ConfigurationSaveMode.Modified);
}
}
public static bool Initialize()
{
ApplicationSettings.Initialize();
while (true)
{
//TODO: Get rid of this try. Not sure what I was doing originally.
//This is completely broken and just (predictably) fails if it can't connect to the database or what have you.
//Kinda makes it hard for someone to set this up if they don't know what I was doing, which if I'm being honest, I didn't.
try
{
ParagonDataContext ctx = new ParagonDataContext();
//TODO: Pretty sure this fails everytime if the database doesn't exist so go me, this is very helpful. Idiot.
if (!ctx.DatabaseExists())
{
ctx.CreateDatabase();
}
_userAccessor = new UserAccessor();
return(true);
}
catch (Exception)
{
//So I just spent like 3 hours trying to get a SQL Server running and this never popped up once. I have no idea what I was doing.
using (DataConnectionDialog dialog = new DataConnectionDialog())
{
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dialog);
if (DataConnectionDialog.Show(dialog) != DialogResult.OK)
{
return(false);
}
string connectionString = dialog.ConnectionString;
ApplicationSettings.ConnectionString = connectionString;
}
}
}
}
private void OnConnectionStringButtonClick(object sender, EventArgs e)
{
// Using the microsoft connection dialog as used in visual studio
// http://archive.msdn.microsoft.com/Connection/Release/ProjectReleases.aspx?ReleaseId=3863
var dialogResult = DialogResult.Cancel;
var connectionString = string.Empty;
var dcd = new DataConnectionDialog();
try
{
var dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd, Connection.Type);
CaptureConnection();
if (Connection.ConnectionString != GetDefaultConnectionStringForServerType(Connection.Type))
{
dcd.ConnectionString = Connection.ConnectionString;
}
dialogResult = DataConnectionDialog.Show(dcd);
connectionString = dcd.ConnectionString;
}
catch (ArgumentException)
{
dcd.ConnectionString = string.Empty;
dialogResult = DataConnectionDialog.Show(dcd);
}
finally
{
if (dialogResult == DialogResult.OK)
{
Connection.ConnectionString = connectionString;
BindData();
}
}
}
private void NewConnectionButton_Click(object sender, RoutedEventArgs e)
{
try
{
DataConnectionDialog dataConnectionDialog = new DataConnectionDialog();
DataConnectionConfiguration dataConnectionSetting = new DataConnectionConfiguration(null);
dataConnectionSetting.LoadConfiguration(dataConnectionDialog);
if (DataConnectionDialog.Show(dataConnectionDialog) == System.Windows.Forms.DialogResult.OK)
{
string connString = dataConnectionDialog.ConnectionString;
string provName = dataConnectionDialog.SelectedDataProvider.Name;
ModelItem.Properties["ConnectionString"].SetValue(new InArgument <string>(connString));
ModelItem.Properties["ProviderName"].SetValue(new InArgument <string>(provName));
if (ModelItem.Properties["ExistingDbConnection"] != null)
{
ModelItem.Properties["ExistingDbConnection"].SetValue(null);
}
}
}
catch { }
}
private void btnConnectToDatabase_Click(object sender, EventArgs e)
{
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
var tables = SqlUtils.GetAllTables(dcd.ConnectionString);
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.ConnectionString = dcd.ConnectionString;
dbName = builder.InitialCatalog;
serverName = builder.DataSource;
connectionString = dcd.ConnectionString;
TreeNode rootNode = new TreeNode(builder.InitialCatalog, 1, 1);
TreeNode tablesNode = rootNode.Nodes.Add("Tables", "Tables", 2, 2);
tablesNode.Tag = dcd.ConnectionString;
foreach (string table in tables)
{
TreeNode tableNode = tablesNode.Nodes.Add(table, table, 3, 3);
tableNode.Tag = "table";
}
tvTables.Nodes.Add(rootNode);
tvTables.ExpandAll();
}
}
private void OnConnectionStringButtonClick(object sender, EventArgs e)
{
// Using the microsoft connection dialog as used in visual studio
// http://archive.msdn.microsoft.com/Connection/Release/ProjectReleases.aspx?ReleaseId=3863
var dialogResult = DialogResult.Cancel;
var connectionString = string.Empty;
var dcd = new DataConnectionDialog();
try
{
var dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd, Connection.Type);
CaptureConnection();
if (Connection.ConnectionString != GetDefaultConnectionStringForServerType(Connection.Type))
{
dcd.ConnectionString = Connection.ConnectionString;
}
dialogResult = DataConnectionDialog.Show(dcd);
connectionString = dcd.ConnectionString;
}
catch (ArgumentException)
{
dcd.ConnectionString = string.Empty;
dialogResult = DataConnectionDialog.Show(dcd);
}
finally
{
if (dialogResult == DialogResult.OK)
{
Connection.ConnectionString = connectionString;
BindData();
}
}
}
bool IObfuscationDocumentView.TryGetDatabaseConnection(ref Type connectionType, ref string connectionString)
{
return(DataConnectionConfiguration.TryGetDatabaseConnection(ref connectionType, ref connectionString));
}
private void chooseDatabaseBtn_Click(object sender, EventArgs e)
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
databaseTxt.Text = dcd.ConnectionString;
connectionString = dcd.ConnectionString;
dataSourceType = dcd.SelectedDataSource.DisplayName;
Console.WriteLine("here it is :" + dataSourceType);
switch (dataSourceType)
{
//case "Microsoft SQL Server Compact 3.5":
// try
// {
// using (SqlCeConnection con = new SqlCeConnection(connectionString))
// {
// tableTxt.Items.Clear();
// con.Open();
// using (SqlCeCommand command = new SqlCeCommand("SELECT table_name FROM INFORMATION_SCHEMA.Tables", con))
// {
// SqlCeDataReader reader = command.ExecuteReader();
// while (reader.Read())
// {
// tableTxt.Items.Add(reader.GetString(0));
// }
// }
// con.Close();
// }
// dcs.SaveConfiguration(dcd);
// tableTxt.Enabled = true;
// }
// catch (Exception ex)
// {
// MessageBox.Show("Unable to establish Connection..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
// break;
case "Microsoft SQL Server":
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
tableTxt.Items.Clear();
con.Open();
using (SqlCommand command = new SqlCommand("SELECT table_name FROM INFORMATION_SCHEMA.Tables", con))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
tableTxt.Items.Add(reader.GetString(0));
}
}
con.Close();
}
dcs.SaveConfiguration(dcd);
tableTxt.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Unable to establish Connection..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
default:
MessageBox.Show("Not Implemented Yet..!!");
break;
}
}
}
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;
}
private void OnConnectionStringButtonClick(object sender, EventArgs e)
{
var dialogResult = DialogResult.Cancel;
var connectionString = string.Empty;
var dcd = new DataConnectionDialog();
try
{
var dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd, Connection.Type);
CaptureConnection();
if (Connection.ConnectionString != GetDefaultConnectionStringForServerType(Connection.Type))
{
dcd.ConnectionString = Connection.ConnectionString;
}
dialogResult = DataConnectionDialog.Show(dcd);
connectionString = dcd.ConnectionString;
}
catch (ArgumentException)
{
dcd.ConnectionString = string.Empty;
dialogResult = DataConnectionDialog.Show(dcd);
}
finally
{
if (dialogResult == DialogResult.OK)
{
Connection.ConnectionString = connectionString;
BindData();
}
}
}
