private void LoadData() { try { this.Validate(); this.swimmersBindingSource.EndEdit(); this.swimmersTableAdapter.Update(this.poolBDDataSet); DataGridViewMain.Update(); DataGridViewMain.Rows.Clear(); SqlConnection con = new SqlConnection(this.swimmersTableAdapter.Connection.ConnectionString); con.Open(); SqlCommand command = con.CreateCommand(); command.CommandText = $"SELECT * FROM Swimmers"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DataGridViewMain.Rows.Add(reader[0], reader[1], reader[2], reader[3], reader[4], reader[5]); } reader.Close(); con.Close(); MessageBox.Show("Update successful"); } catch (Exception) { MessageBox.Show("Update failed"); } }
public static void Main() { Application.SetHighDpiMode(HighDpiMode.SystemAware); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); // Configure main logic: var factory = new MessageBoxFactory(); var mainForm = new DataGridViewMain(); var controller = new StandardController(mainForm, null); #if !DEBUG try { controller.LoadApp(); } catch (Exception a) { factory.ShowMessageBox(EMessageBox.Standard, string.Format(Resources.UnknownExceptionMessage, a.Message), Settings.Default.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } #else controller.LoadApp(); #endif Application.Run(mainForm); }
private void MainForm_Activated(object sender, EventArgs e) { this.Validate(); this.swimmersBindingSource.EndEdit(); this.swimmersTableAdapter.Update(this.poolBDDataSet); DataGridViewMain.Update(); SqlConnection con = new SqlConnection(this.swimmersTableAdapter.Connection.ConnectionString); con.Open(); SqlCommand command = con.CreateCommand(); command.CommandText = $"SELECT * FROM Swimmers"; SqlDataReader reader = command.ExecuteReader(); DataGridViewMain.Rows.Clear(); while (reader.Read()) { DataGridViewMain.Rows.Add(reader[0], reader[1], reader[2], reader[3], reader[4], reader[5]); } reader.Close(); con.Close(); }