private void PreencheDataGrid() { ConnetionPostgres connectionPostgres = new ConnetionPostgres(); NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString); string sql = "SELECT * FROM public.\"KitCapsulas\""; NpgsqlCommand cmd; DataTable dt; try { conn.Open(); cmd = new NpgsqlCommand(sql, conn); dt = new DataTable(); dt.Load(cmd.ExecuteReader()); dgvKitCapsulas.DataSource = dt; conn.Close(); } catch (Exception) { MessageBox.Show("Não conseguimos conectar ao servidor, por favor verifique os parametros de configuração!"); FormConnectionConfig form = new FormConnectionConfig(); form.Show(); form.Activate(); } }
private void FormPrincipal_Shown(object sender, EventArgs e) { try { ConnetionPostgres connectionPostgres = new ConnetionPostgres(); NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString); string sql = "SELECT * FROM public.\"Capsulas\""; NpgsqlCommand cmd; conn.Open(); cmd = new NpgsqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception) { MessageBox.Show("Não conseguimos conectar ao servidor, por favor verifique os parametros de configuração!"); FormConnectionConfig form = new FormConnectionConfig(); form.Show(); form.Activate(); } }