Add "Select" in a combobox

[pinkpoppy]

I have a combobox in a window form and it is populating from a datasource via sql. I need a blank item, "select category". How do I do it?

                dtCategory = SQLQuery("Select Category Display from Category_Support").Tables[0];
                DataColumn[] CategoryKeyColumn = new DataColumn[1];
                CategoryKeyColumn[0] = dtCategory .Columns[0];
                combobox1.DataSource = dtCategory ;
                combobox1.DisplayMember = "Display";
                combobox1.ValueMember = "Display";

 

[gmmastros]

Maybe this:

Select 'Select Category' As Display Union All Select Category from Category_Support

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[pinkpoppy]

Thank you so much. Works great!