请教如何获取数据

Question

  <asp:AccessDataSource ID="SqlDataSource1" runat="server" datafile="<%$ ConnectionStrings:newsConnectionString %>" SelectCommand="SELECT Attend_Desc.Description, Leave.ID, Leave.Name, Leave.Date, Leave.FDate, Leave.TDate, Leave.NumDay, Leave.sl_allow, Leave.Res, Staff_Profile.YearVacation
FROM Staff_Profile RIGHT JOIN (Attend_Desc RIGHT JOIN Leave ON Attend_Desc.Code = Leave.Code) ON Staff_Profile.Name = Leave.Name
ORDER BY Leave.ID DESC" >   
  </asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" ShowHeader="False" GridLines="None" DataSourceID="SqlDataSource1" PageSize="5" Width="530px" BorderColor="#FF8000">
 <Columns>
 <asp:TemplateField>
<ItemTemplate><table border="0" width="100%" cellspacing="0" cellpadding="5">
                  <tr> 
                    <td  align="left" ><b>State：</b></td>
                    
                    <td  colspan="3"><%#Eval("sl_allow") %>
                    <% 
                        Select Case Eval("sl_allow")《〈〈就是这里错误，请教如何获取                            Case 0
                                Response.Write("初申请")
                            Case 1
                                Response.Write("经理审核")
                            Case 2
                                Response.Write("申请通过")
                            Case 3
                                Response.Write("申请否决")
                        End Select
                        %>
                                         </td> 
                  </tr>

Answer 1

这样吧：
HTML
 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                ShowHeader="False" GridLines="None"  PageSize="5"
                Width="530px" BorderColor="#FF8000">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <table border="0" width="100%" cellspacing="0" cellpadding="5">
                                <tr>
                                    <td align="left">
                                        <b>State： </b>
                                    </td>
                                    <td colspan="3">
                                        <%#Eval("sl_allow")%>
                                       <%#ConvertFunction(Eval("sl_allow").ToString())%>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
.cs  public string ConvertFunction(string sl_allow)
    {
        string ret = string.Empty;
        switch (sl_allow)
        {
            case "0":
                ret = "初申请";
                break;
            case "1":
                ret = "经理审核";
                break;
            case "2":
                ret = "申请通过";
                break;
            case "3":
                ret = "申请否决";
                break;
        }
        return ret;
    }把逻辑写到.cs文件里，不会这么乱

Answer 2

sqlCommand漏掉了 你加上去。在后台代码里写个转换的方法，这个方法是public类型的。

Answer 3

switch (<%#Eval("sl_allow").ToString() %>)
case "0":这样试试!!