private void btnCreate_Click(object sender, System.EventArgs e) //triggers the create database event { if (txtPath.Text != "") { if (File.Exists(txtPath.Text)) //if the database exists, delete it { File.Delete(txtPath.Text); }//creates the database clsDataStorage.db = clsDataStorage.dbe.CreateDatabase(txtPath.Text, LanguageConstants.dbLangGeneral); clsDataStorage.status = true; MetroMessageBox.Show(this, "Database created with success!", "New database", MessageBoxButtons.OK, MessageBoxIcon.Information); MiniAccess.disableMenu(); //disables the create and open menu MiniAccess.enableAdd(); //enables the add fields and display menu MiniAccess.tsMenuAdd.Enabled = false; this.Close(); } else { MetroMessageBox.Show(this, "Please check the name of the database.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//function to create the table private void createTable(MetroGrid dgv) { bool error = false; //check variable if (autoIncr < 2) //check if there is more than one auto increment field { foreach (DataGridViewRow row in dgv.Rows) //loops through the datagridview rows { if (row.Index != dgv.RowCount - 1) { createField(dgv, row.Index); //creates a field } } if (unqcount > 1) //if there are more than one unique value, display error { MetroMessageBox.Show(this, "This table already contains a field with the property UNIQUE.\nA table can only contain one UNIQUE field.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); error = true; } if (pricount > 1) //if there are more than one primary value, display error { MetroMessageBox.Show(this, "This table already contains a field with the property PRIMARY.\nA table can only contain one PRIMARY field.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); error = true; } if (!error) //if no error found, then append table { clsDataStorage.tableNames.Add(txtTableName.Text); MetroMessageBox.Show(this, "Table : " + txtTableName.Text + " successfully created."); clsDataStorage.db.TableDefs.Append(table); MiniAccess.disableMenu(); MiniAccess.enableAdd(); MiniAccess.tsMenuOpen.Enabled = false; autoIncr = 0; this.Close(); } } else { MessageBox.Show("A table can only contain ONE auto increment value."); } }