Suppose, you have a table called Employee_Master and it contains one Status column. and status column contains
AA/DD as a text which shows Active/De-active employees.
If you are using Gridview and you want to show Active/De-active in Gridview Status Column then, either you will write a code in Gridview' RowDataBound event or you will directly write in aspx page in Itemtemplate as shown:-
<asp:gridview id="gd_employee" runat="server">
<column>
<templatefield headertext="Employee Status">
<itemtemplate>
<asp:label id="lbl_employee_status" runat="server" Text = '<%#IIF(Eval("Status").Tostring()="AA","Active","De-active") %>'
</itemtemplate>
</templatefield>
</column>
</asp:gridview>