I have a scenario where I fetch all the records from a database table using ADO.Net and I want to convert one of the column values which has either "0" or "1". If 0, then "No" should be replaced with 0 and if 1, then it should be "Yes".
For instance, if the following data is there in the table :-
- Item1 1
- Item2 0
- Item3 1
then, it should display in the DataGridView as :-
- Item1 Yes
- Item2 No
- Item3 Yes
Any help is appreciated whether in C# or VB.Net.