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 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);
}
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);
}
// Обработчики сообщений.
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 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 = this.textBoxConnStr.Text;
}
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
textBoxConnStr.Text = dcd.ConnectionString;
}
dcs.SaveConfiguration(dcd);
}
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 sqlConnection_Click(object sender, EventArgs e)
{
dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
switch (this.mainTab.SelectedIndex)
{
case 0:
{
this.sqlStorageConnTxt.Text = dcd.ConnectionString;
break;
}
case 1:
{
this.connectionStringTxt.Text = dcd.ConnectionString;
break;
}
default:
{
break;
}
}
}
dcs.SaveConfiguration(dcd);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == DialogResult.OK)
{
SaveConnString(dcd.ConnectionString);
// 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);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
// string winpath = Environment.ExpandEnvironmentVariables("%SystemRoot%");
// File.Copy("sqlcese35.dll", winpath + @"\sqlcese35.dll");
// File.Copy("sqlceqp35.dll", winpath + @"\sqlceqp35.dll");
// File.Copy("sqlceme35.dll", winpath + @"\sqlceme35.dll");
// MessageBox.Show("sqlce导入成功");
}
}
/// <summary>
/// Method that call DataConnectionDialog
/// </summary>
/// <returns>string of configured connection</returns>
private string getConnectionString()
{
string connString = null;
DataConnectionDialog dcd = new DataConnectionDialog();
DataConnectionConfiguration dcs = new DataConnectionConfiguration(null);
dcs.LoadConfiguration(dcd);
if (DataConnectionDialog.Show(dcd) == System.Windows.Forms.DialogResult.OK)
connString = dcd.ConnectionString;
dcs.SaveConfiguration(dcd);
return connString;
}
