C# Combobox and SQL

Question

I would like to know how to load values in a combobox, listing an entire column of the database, for example, I have a column called "Beer" and it has several names, I would like to list this column in a Combobox. Thanks.

I have a stored procedure:

CREATE PROCEDURE [dbo].[LoadCerveja]
(
    @Cerveja varchar(60)
)
AS
    SELECT @cerveja from Ingredientes
RETURN

and in the code I need to add to the formLoad for him to pull the "Beer" column from the database.

I tried to do the following (in the form load)

private void Form1_Load(object sender, EventArgs e)
{
try
{
conexao.Open();
SqlCommand cmdd = new SqlCommand("LoadIngredients", conexao);
cmdd.CommandType = CommandType.StoredProcedure;
cmdd.Parameters.Add("@Cerveja");
SqlDataReader DR;
DR = cmdd.ExecuteReader();
{
 comboBox1.Items.Add(DR.GetValue()); **// Não sei o que fazer aqui pra        adicionar      os dados ao combobox !!!!**
}
else MessageBox.Show("Erro ao buscar receita no DB.");

}

Answer 1

There is an example in the documentation on the Sqldatareader..

....
    SqlDataReader DR = cmdd.ExecuteReader();

    if (DR.HasRows)
    {
      while (DR.Read())
      {
          comboBox1.Items.Add(DR.GetString(0)); 
      }
    }
    else
    {
      Console.WriteLine("No rows found.");
    }
    DR.Close();
....

In your Parameters you can insert the value in two ways

cmdd.Parameters.Add("@Cerveja", SqlDbType.VarChar).Value = "valor"

or

cmdd.Parameters.AddWithValue("@Cerveja", valor);

I hope I’ve helped!