How to load values in the combobox by the form load event C#

Question

How to load values in the combobox by the form load event C#

Asked 7 years ago

Viewed 318 times

2

I’m trying through this code:

private void frmAdicionarProdutos_Load(object sender, EventArgs e)
        {
             string serverName = "localhost";
             string port = "5432";
             string userName = "postgres";
             string password = "adm";
             string databaseName = "GE";
             NpgsqlConnection conn = null;
             string ConnString = null;

             ConnString = String.Format("Server={0};Port={1};User Id={2};Password={3};Database={4};",
                                           serverName, port, userName, password, databaseName);

            using (conn = new NpgsqlConnection(ConnString))
            {
                conn.Open();

                string cmdCarregar = String.Format("SELECT PRODUTOS.ID_PRODUTO, PRODUTOS.NOME, PRODUTOS.PRECO FROM PRODUTOS;");
                using (NpgsqlCommand cmd = new NpgsqlCommand(cmdCarregar, conn))
                {
                    NpgsqlDataReader dr = cmd.ExecuteReader();
                    DataTable dt = new DataTable();
                    dt.Load(dr);

                    cbProdutos.DisplayMember = "nome";
                    cbProdutos.ValueMember = "id_produto";
                    cbProdutos.DataSource = dt;
                    conn.Close();
                }     
            }
        }

At first I just want to test this way anyway, then implement by calling the bank class.

This code does not show anything in Combobox, I think I forgot something.. I would like to show: Product name + value of it (concatenated).

Probably the query should be like this: string cmdCarregar = String.Format("SELECT ID_PRODUTO, NOME, PRECO FROM PRODUTOS;");

– Jéf Bueno

2017/10/23 at 18:43
In the same, I tested the query in postgres and returned me what I needed, but the combobox shows nothing yet..

– WSS

2017/10/23 at 18:46
2 points, 1 do not need to use String.Format . 2 as you yourself said you need concatenate the PRODUCTS.NAME, PRODUCTS.PRICE .

– Marco Souza

2017/10/23 at 18:50

2 answers

Browser other questions tagged c#

You are not signed in. Login or sign up in order to post.

by Fernando • **1,027** points · Answer 1 · 2017-10-24T01:40:54+00:00

0

I can only see one cause for trouble: you nay associated the method frmAdicionarProdutos_Load to the event Form.Load

this.Load += new System.EventHandler(this.frmAdicionarProdutos_Load);

I tested your code here and the combo loaded right.

I made this change too and didn’t load it anyway.. load I think you’re right.. because I went to the events and the only load you have was the one that implemented the code

– WSS

2017/10/24 at 09:14
Weird. I tested your code and it worked. I just made a change to the query to take advantage of a table I already had. My query looked like this: string cmdCarregar = String.Format("SELECT \"ID\", \"Descricao\" FROM \"SchemaTeste\".\"TabTeste\";");

– Fernando

2017/10/24 at 11:16
Another detail: I’m using the Npgsql versão 3.2.5, You came to check if the code of your routine is running?

– Fernando

2017/10/24 at 11:21
How can I verify this? It would be by Breakpoint but I don’t know how to use it in this case

– WSS

2017/10/24 at 11:37
I used them, and it turned out Items.Count = 0

– WSS

2017/10/24 at 11:39
Yeah, put a Breakpoint pressing F9 over a line within Function. If the execution is not interrupted, then your routine is not running.

– Fernando

2017/10/24 at 11:42
So it’s running.. Just don’t give the return

– WSS

2017/10/24 at 11:43
Let’s go continue this discussion in chat.

– WSS

2017/10/24 at 11:44

Show 3 more comments

by Heron Dantas • **316** points · Answer 2 · 2017-10-23T18:47:46+00:00

I believe it will work when adding Databind()

cbProdutos.DataBind();

Make sure it works.

private void frmAdicionarProdutos_Load(object sender, EventArgs e)
    {
         string serverName = "localhost";
         string port = "5432";
         string userName = "postgres";
         string password = "adm";
         string databaseName = "GE";
         NpgsqlConnection conn = null;
         string ConnString = null;

         ConnString = String.Format("Server={0};Port={1};User Id={2};Password={3};Database={4};",
                                       serverName, port, userName, password, databaseName);

        using (conn = new NpgsqlConnection(ConnString))
        {
            conn.Open();

            string cmdCarregar = String.Format("SELECT PRODUTOS.ID_PRODUTO, PRODUTOS.NOME, PRODUTOS.PRECO FROM PRODUTOS;");
            using (NpgsqlCommand cmd = new NpgsqlCommand(cmdCarregar, conn))
            {
                NpgsqlDataReader dr = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(dr);

                cbProdutos.DisplayMember = "nome";
                cbProdutos.ValueMember = "id_produto";
                cbProdutos.DataSource = dt;
                cbProdutos.DataBind();
                conn.Close();
            }     
        }
    }