"/" in the Database column name

Question

I have database with a column name "State/Province". All the queries and data transfers work properly. But in the "SelectedValue" property of the dropdownlist control, bind expressions throws an error.

When I edit the column name by removing the slash sign, it works well.

So using slash in the column name is not a proper way of naming?

Answer 1

Basically using anything different than:

• Alphabets
• Numbers (not at start of the column name)
• Underscore (_)

is not recommended as it is not a good way to name fields and some datasources might throw errors on other characters.