I am using a VB.Net SQLDataSource to populate a combobox on a windows form. However in the bound combobox, I need to add one additional entry that displays "(none)" and has a value value of 0. I have tried to follow a couple of posts on the VB side that suggest inserting a new ListItem, but it does not accept ListItem as a valid type.
So I would like to try doing what I have done in Access previously and use a union query to add a static value row to the query itself. Something like:
Select Identified_Language_ID As ID, Print_Name as Name From Identified_Language Order By Print_Name
Union Select 0 as id, '(none)' as name from identified_Language;
But when I test this in SQL Management Studio, it complains: "Incorrect syntax near the keyword 'UNION'." Can anyone help me correctly formulate a query that retrieves values from a data table, and adds one additional row with a static value for the two fields?
Thanks for any help.