问在GridView上显示之前先操作SQL值

EN

 <asp:Label ID="lblStatus"  
                 runat="server" 
                 Text='<%# GetLabelText(Eval("status")) %>'>
 </asp:Label>

public string GetLabelText(object dataItem)
    {
    string text = "";
    string val = dataItem as string;
    switch (val)
        {
        case "N":   text = "New"; 
             break;
        case "V":   text = "Verified";
            break;
        case "F":   text = "Fulfilled";
            break;
        case "C":   text = "Cancelled";
            break;
        }
    return text;
    }

private void gridview_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
  if (e.Value.equals("N")) e.Value = "New";
  else if(e.Value.equals("V")) e.Value = "Verified";
  else if(e.Value.equals("C")) e.Value = "Cancelled";
  else if(e.Value.equals("D")) e.Value = "Deleted";
}

Select 
      YourFields
      case 
      when YourConditionField= 'N' then 'New' 
      when YourConditionField= 'V' then 'Verified'
      when YourConditionField= 'C' then 'Cancelled'
      when YourConditionField= 'D' then 'Deleted'
      end,
from table

<asp:TemplateField>
    <ItemTemplate>
        <asp:Label ID="labelResult" runat="server" />
    </ItemTemplate>
</asp:TemplateField>


protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if(e.Row.RowType == DataControlRowType.DataRow)
    {
       string value = e.Row.Cells[0].Text;
       Next find the label in the template field.
        Label myLabel = (Label) e.Row.FindControl("myLabel");
        if (value == "N")
        {
            myLabel.Text = "New";
        }
        else if (value == "V")
        {
            myLabel.Text = "Verified";
        }
        else if (value == "C")
        {
            myLabel.Text = "Cancelled";
        }
        else if (value == "D")
        {
            myLabel.Text = "Deleted";
        }
    }
}