The data type of the column is nvarchar. I can insert to the column properly using parameters. I see the ampersand character in the column when I view the table in sql server management studio.
My problem is when i'm selecting from the column in my application the ampersand character disappears.
Once I select the column I assign the value to a label like, label1.Text = reader("column")
The column in my table has a value of "Foo&Bar" but in my application it just shows as "FooBar".
It is a property of the
Label
calledUseMnemonic
, set it toFalse
to show the text&
properly