Populating my Combo Box from Access DB

[blazted]

I am having a problem with populating a combo box from a Access DB, I am calling a stored procedure that executes with one row of values. i want to populate those values into my combo box but right now the combo box will not populate. here is my code.

private void GetProductColors()
        {
            try
            {
                if (oleDbConnection1.State != ConnectionState.Open)
                {
                    oleDbConnection1.Open();
                }
 
                //Initialize the location parameter to our GetColors ADO Command 
Object
                oleDbCommandGetColors = new 
OleDbCommand("SelectDistinctProductColors_sp", oleDbConnection1);
                oleDbCommandGetColors.CommandType = CommandType.StoredProcedure;
                oleDbCommandGetColors.Parameters.Clear();
                oleDbDataReader1 = 
oleDbCommandGetColors.ExecuteReader(CommandBehavior.CloseConnection);
 
                while (oleDbDataReader1.Read() == true)
                {
                    cmbSelection.Items.Add(oleDbDataReader1.GetString(0));    
                }

Thanks

[Plater]

If you only have ONE row, then you will only get one value from that loop.

[blazted]

I have 4 values in that row. I want to populate those values into the ComboBox. Right now it is not populating anything. I have tried adding those values to an array and then using the .add to add it but still nothing. Any ideas?

[Plater]

Try more like this:

if (oleDbDataReader1.Read())
{
   for(int i=0;i<oleDbDataReader1.FieldCount;i++)
   {
      cmbSelection.Items.Add(oleDbDataReader1.GetValue(i).ToString());
   }
}
 

[blazted]

Try more like this:

if (oleDbDataReader1.Read())
{
   for(int i=0;i<oleDbDataReader1.FieldCount;i++)
   {
      cmbSelection.Items.Add(oleDbDataReader1.GetValue(i).ToString());
   }
}
 

That worked great except it is only pulling down my second and 4th value from the stored procedure. Hm thats weird not sure why it would skip the 1st and third values.

[Plater]

Are you sure your stored procedure is returning what you think it's returning?

Have you dumped it into a dataset and looked at it?

[blazted]

I figured it out. It was an improper call. I used my original method. Not sure why your way would skip. Thanks for the help.

[Plater]

I think if you have multiple values stored in one column, or multiple columns with the same name, it would skip them.