连用Forename +姓氏SelectCommand

Question

我正在尝试将TeacherForename + TeacherSurname字段连接到我的下拉列表中，以便让用户更清楚地了解他们选择的老师。

但是，TeacherForename + TeacherSurname将保存TeacherID的值。

<div class="fields">
    <p>
        <asp:Label ID="TeacherIdentification" runat="server" Font-Bold="True" 
            Width="150px">Teacher ID:</asp:Label>
        <asp:DropDownList ID="DropDownList2" runat="server" 
            DataSourceID="SqlDataSource2" DataTextField="TeacherForename"
            DataValueField="TeacherID" Height="29px" Width="155px" 
            CssClass="Dropdownlist">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT Class.TeacherID, Teacher.TeacherForename, Teacher.TeacherSurname FROM (Class INNER JOIN Teacher ON Class.TeacherID = Teacher.TeacherID)">
        </asp:SqlDataSource>
    </p>
</div>

我已经尝试过这样做，但我不能正确地选择命令，它不会显示在我的下拉列表，谁能指出我的正确方向吗？

Answer 1

<div class="fields">
    <p>
        <asp:Label ID="TeacherIdentification" runat="server" Font-Bold="True" 
            Width="150px">Teacher ID:</asp:Label>
        <asp:DropDownList ID="DropDownList2" runat="server" 
            DataSourceID="SqlDataSource2" DataTextField="TeacherForename"
            DataValueField="TeacherID" Height="29px" Width="155px" 
            CssClass="Dropdownlist">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT Class.TeacherID, (Teacher.TeacherForename + '' +     Teacher.TeacherSurname) as  TeacherFullName  FROM Class INNER JOIN Teacher ON Class.TeacherID = Teacher.TeacherID ">
        </asp:SqlDataSource>
    </p>
</div>