Reputation: 6406
I'm there is a gridview on a form of my windows forms application. it gets it's value from a data source. the datasource contains a field "IsNew". this shows "True" or "False" in a column of my datagridview. I want to show "Yes" for True and No for False. Is it possible? Please Help.
Upvotes: 0
Views: 1060
Reputation:
if you have a SELECT statement maybe you may try a DECODE; for MS SQL it should be:
SELECT CASE WHEN FieldA = 'A' THEN 'myA' ELSE 'myB' FROM myTable.
Upvotes: 2