//on load do this. private void Main_Load(object sender, EventArgs e) { try { //using SelectRows method to grab data safely. DataSet personDataSet = new DataSet(); personDataSet = Handlers.RetrieveSQLData(personDataSet, DataStrings.SqlConnectionString(), DataStrings.DGVMainFormDataQuery()); dgvPersonInfo.DataSource = personDataSet.Tables["Person"]; //forces columns in dgvPersonInfo to fill for (int i = 0; i < 6; i++) { dgvPersonInfo.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } dgvPersonInfo.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet; //Debug tool //MessageBox.Show("Connection successful."); } catch { //duh MessageBox.Show("Connection to database failed."); } }
//click new to generate personInformation.cs form with blank fields private void newToolStripMenuItem_Click(object sender, EventArgs e) { Handlers.OpenPersonInformationForm(); }
//use this to prevent accidental closing of Main form protected override void OnFormClosing(FormClosingEventArgs e) { Handlers.CloseCancel(); }