private void btnTest_Click(object sender, EventArgs e) { ThongSo.DB_Mode = (DBMS)cboDatasource.SelectedIndex; ThongSo.DB_Server = txtServer.Text; ThongSo.DB_UserName = txtUserName.Text; ThongSo.DB_Password = txtPassword.Text; ThongSo.DB_AccessFile = bfcFileBrowse.txtFileName.Text; DBProviderBase database = new DBProviderBase(); if (database.TestConnection()) { DevExpress.XtraEditors.XtraMessageBox.Show("Test Connection succecced"); } else { DevExpress.XtraEditors.XtraMessageBox.Show("Test Connection failed", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void GenerateDirect(string FolderPath, string dbName, string script) { if (ThongSo.DB_Server != "" && ThongSo.DB_Server != null || ThongSo.DB_Mode == DBMS.Access) { DBProviderBase database = new DBProviderBase(); if (ThongSo.DB_Mode == DBMS.Access) { string filePath = ""; if (!ThongSo.DB_IsNewDatabase) { filePath = ThongSo.DB_AccessFile; } else { filePath = FolderPath + "\\" + dbName + ".mdb"; } FileInfo fi = new FileInfo(filePath); if (fi.Exists) { if (DevExpress.XtraEditors.XtraMessageBox.Show("This database already existed\nDo you want to overwrite it ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { fi.Delete(); } } if (database.CreateDatabase(dbName, FolderPath)) { if (database.Connect(filePath)) { if (database.Execute(script)) { database.Close(); } else { DevExpress.XtraEditors.XtraMessageBox.Show("Generate Failed, please manual check the generated script !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { DevExpress.XtraEditors.XtraMessageBox.Show("Cannot create the database\nMay be the file name is duplicated with write protected file", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { if (database.TestConnection()) { if (!database.Connect(dbName)) { database.CreateDatabase(dbName, FolderPath); if (database.Connect(dbName)) { database.Execute(script); } } else { if (ThongSo.DB_Mode == DBMS.Oracle) { database.Execute(script); } else if (DevExpress.XtraEditors.XtraMessageBox.Show("This database already existed\nDo you want to overwrite it ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { database.Execute(script); } } database.Close(); } else { DevExpress.XtraEditors.XtraMessageBox.Show("Cannot connect to database\nYou must start the database first", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { DevExpress.XtraEditors.XtraMessageBox.Show("Cannot connect to database\nPlease specify connection setting", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information); } }