SQL query with ID from a combobox - C#

Question

I’m putting together a little system where I created a Formulario where there is a Combobox listing the names of the employees stored at the bank and a DataGrid that shows the services done by them (value, description and client).

When selecting the employee in Combobox,I wanted to show the services done by him,

SELECT func_nome, serv_desc, serv_cliente, serv_valor FROM func_serv
INNER JOIN func_dados ON func_serv.func_id = func_dados.func_id
WHERE func_serv.func_id = //codigo da funcionaria;

My doubt is, when picking the index of the selected combobox, how can I use it as parameter for my sql query, replacing that commented part of the code.

I thought about creating several ifs, but if a new employee is created, I will have to put another if.

Help me out, please

Answer 1

Just concatenate the value of comboxBox, I used the @ to escape the string for better viewing.

SqlCommand sql = new SqlCommand(@"SELECT func_nome, serv_desc, serv_cliente, serv_valor FROM func_serv
                                INNER JOIN func_dados ON func_serv.func_id = func_dados.func_id
                                WHERE func_serv.func_id = " + comboBox1.SelectedValue);

Answer 2

@Vinicius Caminha, you can use the

Selectedvalue

. Where meucampo = combobox.SelectedValue;

Answer 3

And if you did something like this:

public SqlDataReader lista_dados_servico(object idFuncionario)
{
    conexao = new SqlConnection(conexao_sqlserver);
    var query = @"SELECT func_nome, serv_desc, serv_cliente, serv_valor FROM func_serv
        INNER JOIN func_dados ON func_serv.func_id = func_dados.func_id
        WHERE func_serv.func_id = @idFuncionario";

    using (var comando = new SqlCommand(query, conexao))
    {
        comando.Parameters.AddWithValue("@idFuncionario", idFuncionario);

        return comando.ExecuteReader();
    }
}

and wear it like this:

var idFuncionario = comboBox1.SelectedValue;

var reader = lista_dados_servico(idFuncionario);

while (reader.Read())
{
    var index = dataGridView1.Rows.Add();

    int indexColunaNome    = 0,
        indexColunaServico = 1,
        indexColunaCliente = 2,
        indexColunaValor   = 3;

    dataGridView1[index, indexColunaNome].Value    = reader["func_nome"];
    dataGridView1[index, indexColunaServico].Value = reader["serv_desc"];
    dataGridView1[index, indexColunaCliente].Value = reader["serv_cliente"];
    dataGridView1[index, indexColunaValor].Value   = reader["serv_valor"];
}

That wouldn’t solve your problem?

Answer 4

First I would change the way you fill the combobox to:

conexao = new SqlConnection(conexao_sqlserver); 
SqlCommand sql = new SqlCommand("select func_nome,func_id from func_serv", conexao); 
SqlDataAdapter da = new SqlDataAdapter(sql); 
DataTable dt = new DataTable(); 
da.Fill(dt);

comboBox1.DataSource = (dt.Tables[0]);
comboBox1.DisplayMember = ("func_nome");
comboBox1.ValueMember = ("func_id");

Then on Combobox Indexchanged or on a search button would put the @Laerte code

SqlCommand sql = new SqlCommand(@"SELECT func_nome, serv_desc, serv_cliente,serv_valor FROM func_serv
                            INNER JOIN func_dados ON func_serv.func_id = func_dados.func_id
                            WHERE func_serv.func_id = " + comboBox1.SelectedValue);

SqlDataAdapter da = new SqlDataAdapter(sql); 
DataTable dt = new DataTable(); 
da.Fill(dt);

Datagrid1.DataSource=dt.Tables[0];

Note: If the system is not organized in layers for a better organization and system development practice follow some links for possible study.

http://www.devmedia.com.br/desenvolvimento-em-3-camadas-conceitos/22277 https://rafaelnicolettdeveloper.wordpress.com/2012/07/04/projeto-em-camadas-c-crud/