[DotNetDevelopment] Template Column - need help

[Learner]

Hi,

  I have a belwo template column

*********************************************************************************************************************
<asp:TemplateColumn HeaderText="Status">
                                                                                
<HeaderStyle Font-Bold="True" HorizontalAlign="Center"></
HeaderStyle>
                                                                                
<FooterStyle Font-Bold="True" />
                                                                                
<ItemStyle width="60px" CssClass="SFGridItem"
VerticalAlign="Bottom"></ItemStyle>
                                                                                
<ItemTemplate>
                                                                                
        <asp:Label id="lblStatus" runat="server"
CssClass="SFGridItem" width="60px" Text= '<%# DataBinder.Eval
(Container.DataItem, "Status") %>' />
                                                                                
</ItemTemplate>
                                                                                
<EditItemTemplate>
                                                                                
        <asp:DropDownList id="drpStatus" runat="server"
CssClass="SFGridItem" Width="60px">
                                                                                
                <asp:ListItem Value="A">Active</asp:ListItem>
                                                                                
                <asp:ListItem Value="T">Term</asp:ListItem>
                                                                                
                <asp:ListItem Value="R">Retire</asp:ListItem>
                                                                                
                <asp:ListItem Value="D">Disable</asp:ListItem>
                                                                                
                <asp:ListItem Value="M">Death</asp:ListItem>
                                                                                
    </asp:DropDownList>
                                                                                
</EditItemTemplate>
                                                                        
</asp:TemplateColumn>
*********************************************************************************************************************

I am storing text in the database. But while displaying it in the Grid
I would like to display the value of it in the drop down. For instance
I would like to display 'A' for 'Active'.

Please help.

Thanks,

-L