Guest User

Untitled

a guest
Oct 24th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.33 KB | None | 0 0
  1. private void frmAdicionarProdutos_Load(object sender, EventArgs e)
  2. {
  3. this.Load += new System.EventHandler(this.frmAdicionarProdutos_Load);
  4. string serverName = "localhost";
  5. string port = "5432";
  6. string userName = "postgres";
  7. string password = "adm";
  8. string databaseName = "GE";
  9. NpgsqlConnection conn = null;
  10. string ConnString = null;
  11.  
  12. ConnString = String.Format("Server={0};Port={1};User Id={2};Password={3};Database={4};",
  13. serverName, port, userName, password, databaseName);
  14.  
  15. using (conn = new NpgsqlConnection(ConnString))
  16. {
  17. conn.Open();
  18.  
  19. string cmdCarregar = String.Format("SELECT CONCAT(id_produto,' ', nome,' ', preco) FROM PRODUTOS;");
  20. using (NpgsqlCommand cmd = new NpgsqlCommand(cmdCarregar, conn))
  21. {
  22. NpgsqlDataReader dr = cmd.ExecuteReader();
  23. DataTable dt = new DataTable();
  24. dt.Load(dr);
  25.  
  26. cbProdutos.DisplayMember = "nome";
  27. cbProdutos.ValueMember = "id_produto";
  28. cbProdutos.DataSource = dt;
  29. conn.Close();
  30. }
  31. }
  32. }
Add Comment
Please, Sign In to add comment