本文整理汇总了C#中MySql.Data.MySqlClient.MySqlConnection.Clone方法的典型用法代码示例。如果您正苦于以下问题:C# MySql.Data.MySqlClient.MySqlConnection.Clone方法的具体用法?C# MySql.Data.MySqlClient.MySqlConnection.Clone怎么用?C# MySql.Data.MySqlClient.MySqlConnection.Clone使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySql.Data.MySqlClient.MySqlConnection
的用法示例。
在下文中一共展示了MySql.Data.MySqlClient.MySqlConnection.Clone方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SaveButton_Click
protected void SaveButton_Click(object sender, EventArgs e)
{
Errors.Items.Clear();
string serverType = ServerTypeDrop.SelectedValue;
DbServer serverTypeParsed;
if (!Enum.TryParse<DbServer>(serverType, out serverTypeParsed))
{
Errors.Items.Add("Please, choose the type of database engine you wish to use.");
return;
}
// initial testing of the database connection before we attempt to create the main schema
IBaseDriver drv = null;
switch (serverTypeParsed)
{
case DbServer.MySql:
drv = new BaseDriverMySql(SystemConnstringTextBox.Text);
break;
case DbServer.MsSql:
drv = new BaseDriverMsSql(SystemConnstringTextBox.Text);
break;
}
try
{
drv.TestConnection();
drv.TestDatabaseIsEmpty();
}
catch (Exception ex)
{
Errors.Items.Add(ex.Message);
return;
}
if (UsernameTextBox.Text == "")
{
Errors.Items.Add("Please, insert the initial user's name");
return;
}
if (PasswordTextBox.Text.Length < 7)
{
Errors.Items.Add("The password must be at least 7 characters long.");
return;
}
if (PasswordTextBox.Text != RetypePasswordTextBox.Text)
{
Errors.Items.Add("The passwords do not match.");
return;
}
try
{
System.Net.Mail.MailAddress address = new System.Net.Mail.MailAddress(MailTextBox.Text);
}
catch (FormatException fe)
{
Errors.Items.Add(fe.Message);
return;
}
// run the schema dump script
switch (serverTypeParsed)
{
case DbServer.MySql:
MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(SystemConnstringTextBox.Text);
try
{
MySql.Data.MySqlClient.MySqlScript script = new MySql.Data.MySqlClient.MySqlScript(connection);
string scriptText = File.ReadAllText(HttpContext.Current.Server.MapPath(CC.MYSQL_SCHEMA_FILE_PATH));
script.Query = scriptText;
script.Query = scriptText;
connection.Open();
script.Execute();
connection.Clone();
}
catch (Exception esql1)
{
Errors.Items.Add(esql1.Message);
connection.Close();
return;
}
break;
case DbServer.MsSql:
SqlConnection conn = new SqlConnection(SystemConnstringTextBox.Text);
try
{
string query = File.ReadAllText(HttpContext.Current.Server.MapPath(CC.MSSQL_SCHEMA_FILE_PATH));
Microsoft.SqlServer.Management.Smo.Server sqlServer = new Server(new ServerConnection(conn));
conn.Open();
sqlServer.ConnectionContext.ExecuteNonQuery(query);
conn.Close();
SqlMembershipProvider mssqlProvider = new SqlMembershipProvider();
}
//.........这里部分代码省略.........