[Resolved] Add one line of text to combo box after binding to dataset

[indydavid32]

I have the following code which binds the combo box to a dataset.

Dim cn As New SqlClient.SqlConnection()
        Dim da As SqlClient.SqlDataAdapter
        Dim ds As New DataSet()
 
        cn.ConnectionString = "Integrated Security=True;" & _
        "Data Source=Brutus;Initial Catalog=Problem Tracking;" & _
        "user id=user;password=pass;"
        cn.Open()
 
        da = New SqlClient.SqlDataAdapter("Select [Store Number] From Stores Order " & _
        "By [Store Number]", cn)
        da.Fill(ds, "Stores")
 
        cmbStores.Items.Clear()
 
        cmbStores.DataSource = ds.Tables("Stores")
        cmbStores.DisplayMember = "Store Number"

At the top of this list in this combo box, I would like to add "All"

I tried this to no avail.

cmbStores.Items.Insert("All", 0)

I received an error about the combo box being set.

Anyone have any ideas?

Thanks!

[Lunatic3]

If you have to keep the combobox bound, i am afraid you can not add an item to it in this way. If not, populate it from the dataset but do not bound it and then add another item.

[indydavid32]

I did populate it manualy but then I had to run it through a do while loop. I was trying to avoid that. No big deal though, it's not a large table.

Thanks for the reply.

[Memnoch1207]

you can't manually add items to a bound control.

but you can still fill it from a database and also add items manually likes this

using System;
using System.Data.SqlClient

SqlConnection Conn = new SqlConnection(ConnectionString);
SqlCommand Comm = new SqlCommand("SELECT field1 FROM tableName", Conn);
SqlReader reader;

try
{
   Conn.Open();
   reader = Comm.ExecuteNonQuery();

   ComboBox1.Items.Add("All");
   
   while(reader.Read())
   {
       ComboBox1.Items.Add(reader["field1"]);
   }

   reader.Close();
   Conn.Close();
}
catch(Exception ex)
{
   MessageBox.Show("Error Occurred: " + ex.Message());
}