gridview从数据库取出数字型记录，以其他类型(中文)显示，例如性别(1,0)问题

1.最简单的办法：=================================

      SQL原句：

      SELECT sex FROM user    //这样只会显示0或1，（因为一般情况性别在数据库都用1，0记录）

      修改SQL语句：

      SELECT

      CASE    WHEN sex ='1' THEN '男'

                  WHEN sex ='2' THEN '女'

                  WHEN sex ='0' THEN '不详' END AS sex

      FROM user   

下面的2个方法是在.NET中用GRIDVIEW的模板列一些功能，将性别以一个label显示，放在相应模板列中

2.写函数的方法：==================================

      .cs文件中：

      public string show_isreg(int str)
    {
        //
       
        string strFont = string.Empty;
        if (str == 0)
        {
            strFont = "未注册";
          
        }
        else if (str == 1)
        {
            strFont = "已注册";
           
        }       
        else if (str == 2)
        {
            strFont = "已销毁";
          
        }
        return strFont;
    }

      

      前台.aspx:

      <asp:TemplateField HeaderText="注册">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# show_isreg((int)Eval("isreg")) %>'></asp:Label>
                </ItemTemplate>
       </asp:TemplateField>

3.绑定事件======================================

      protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)//
    {
        //
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label temp = e.Row.FindControl("Label2") as Label;
            switch (temp.Text)
            {
                case "0":
                    {
                        temp.Text = "未注册";
                    } break;
                case "1":
                    {
                        temp.Text = "已注册";
                    } break;
                case "2":
                    {
                        temp.Text = "已销毁";
                    } break;
                default:
                    {
                        temp.Text = "未知";
                    } break;
            }
        }
    }

      .aspx中：

      <asp:TemplateField HeaderText="注册">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# (Eval("isreg") %>'></asp:Label>
                </ItemTemplate>
       </asp:TemplateField>