Move items in ComboBox

[BRawn]

Hi guys,

I have a data-bound ComboBox and I populate a DataSet with the values returned from a SQL query.

 
        public DataSet CompanyArray(DataSet dataSet)
        {
            SqlConnection connection = InstancesTest.IDataInterface.DefineConnection();
 
            SqlCommand command = new SqlCommand();
            command.CommandText = "usp_CompanyArray";
            command.CommandTimeout = 20000;
            command.CommandType = CommandType.StoredProcedure;
            command.Connection = connection;
 
            try
            {
                if (connection.State != ConnectionState.Open)
                    connection.Open();
 
                SqlDataReader reader = command.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(reader);
                DataRow row = dt.NewRow();
                row["COMPANY_NAME"] = "Please Select";
                dt.Rows.InsertAt(row, 0);
                dataSet.Tables.Add(dt);
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (connection.State != ConnectionState.Closed)
                    connection.Close();
            }
 
            return dataSet;
        }
 

When I call this method, I take the values in the DataSet, build an array and populate the ComboBox.

 
        void CompanyArray()
        {
            DataSet ds = new DataSet();
            ds = logic.CompanyArray(ds);
            string[] array = new string[ds.Tables[0].Rows.Count];
 
            int counter = 0;
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                array[counter] = dr["COMPANY_NAME"].ToString().Trim();
                counter++;
            }
 
            Array.Sort(array);
 
            foreach (string companyName in array)
            {
                cmbCompanySelect.Items.Add(companyName.ToString().Trim());
            }
 
            //cmbCompanySelect.SelectedItem = "Please Select";
            int i = cmbCompanySelect.Items.IndexOf("Please Select");
        }
 

All this works fine. The reason I populated it in an array was so that I could sort the items alphabetically. I know I could just do an "order by" in SQL but I chose this route.

What I'm after is putting a "Please Select" at index 0 in the ComboBox. How can I move this value to the top of the list, without reordering the sorted list?
And I don't really want to insert a "Please Select" as a first row in a database table. Any ideas?

Thanks

[PsychoCoder]

Try this:

cmbCompanySelect.Items.Insert(0,"Please Select");

[firexfighterx]

After doing your sort of the elements of the combo box insert the Please Select element at the 0 position.