I've added a dictionary that loads as a datasource to a combobox. I want to add a blank value so a user can essentially blank it out if the dropdown type is a dropdownlist vs a dropdown. So to get around this, my SQL statement has a union statement in it to create this quasi blank record like "select name from table union all select '' as 'name'"
my question is, is there a better way to add a blank row into my datasource vs creating a union? I noticed the dictionary class has a union method to it... is this the right track? I'll need an example.