dimanche 14 juin 2015

Selecting from a column with Ampersand(&)

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".

Aucun commentaire:

Enregistrer un commentaire