private void TestConnect_Click(object sender, EventArgs e) { RefreshInfo(); SqlConnectionResult SqlConnResult = new SqlConnectionResult(); SqlConnection = new MySqlConnection(this.ConnectString); SqlConnResult = SqlConnection.Connect(); if (SqlConnResult.isSuccess() == false) { SqlException theException = SqlConnResult.GetReason(); MessageBox.Show(theException.Message); } else { try { SqlConnection.ChangeDatabase(this.Database); MessageBox.Show("警告:该数据库已经存在!"); } catch (SqlException a) { a.ToString(); MessageBox.Show("通过测试"); } SqlConnection.DisConnect(); } }
private void btnDelete_Click(object sender, EventArgs e) { try { RefreshInfo(); SqlConnectionResult SqlConnResult = new SqlConnectionResult(); SqlConnection = new MySqlConnection(this.ConnectString); SqlConnResult = SqlConnection.Connect(); SqlConnection.Exec("drop database [DD]"); SqlConnection.DisConnect(); MessageBox.Show("OK"); } catch { MessageBox.Show("NO"); SqlConnection.DisConnect(); } }
private void btnBrandNewDatabase_Click(object sender, EventArgs e) { string FileName = "Blank.bak"; try { RefreshInfo(); SqlConnectionResult SqlConnResult = new SqlConnectionResult(); SqlConnection = new MySqlConnection(this.ConnectString); SqlConnResult = SqlConnection.Connect(); CreatDatabaseStructure(); string queryString = "use [master]\r\n RESTORE DATABASE DD FROM disk='" + Application.StartupPath + "\\" + FileName + "' with replace"; SqlConnection.Exec(queryString); MessageBox.Show("恢复成功", "提示信息"); SqlConnection.DisConnect(); } catch { MessageBox.Show("创建失败"); SqlConnection.DisConnect(); } }