在第一个表中选择用户后，如何将数据从数据库检索到第二个表? [英] How to retreive data from the database to the second table after selecting the user in the first table?

问题描述

我的数据库中有三个表，如下所示:

**员工表:用户名，名称，职务，Division代码**

**课程表:CourseID，CoursName，GroupID **

** Employee_Course表:用户名，CourseID(每个表中的第一个键是主键)**

我创建了两个ListViews.一个用于从Employee表中检索雇员信息，第二个用于在第一个ListView中显示所选雇员的已修课程(从Employee_Course表中).

对于第一个表，一切运行良好且正常，但是对于第二个表，我无法在第一个表中检索所选员工的已修课程.

那我该怎么办?

我的ASP.NET代码:

I have three tables in my database as following:

**Employee Table: Username, Name, Job, DivisonCode**

**Course Table: CourseID, CourseName, GroupID**

**Employee_Course Table: Username, CourseID (The first key in each table is the primary key)**

I created two ListViews; one for retrieving the employee information from the Employee Table and the second one to show the taken courses (from Employee_Course Table) of the selected employee in the first ListView.

For the first table, everything works well and fine, but for the second table, I could not be able to retrieve the taken courses of the selected employee in the first table.

So how can I do that?

My ASP.NET code:

<asp:ListView ID="ListView1" runat="server" DataKeyNames="Username"

                DataSourceID="SqlDataSource1" InsertItemPosition="LastItem">

                <EditItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="UpdateButton" ImageUrl="images/update4.png" Width="20px" runat="server" CommandName="Update" />
                            <asp:ImageButton ID="CancelButton" ImageUrl="images/cancel.png" Width="20px" runat="server" CommandName="Cancel" />
                        </td>
                        <td>
                            <asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
                        </td>
                        <td>
                            <asp:Label ID="UsernameLabel1" runat="server" Text='<%# Eval("Username") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="JobTitleTextBox" runat="server"

                                Text='<%# Bind("JobTitle") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="BadgeNoTextBox" runat="server" Text='<%# Bind("BadgeNo") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="EmpOrgTypeTextBox" runat="server"

                                Text='<%# Bind("EmpOrgType") %>' />
                        </td>
                        <td>
                            <asp:DropDownList ID="DropDownList1" runat="server" SelectedValue='<%# Bind("DivisionCode") %>'

                                DataSourceID="SqlDataSource1" DataTextField="DivisionName"

                                DataValueField="SapCode">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                                ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

                                DeleteCommand="DELETE FROM [Divisions] WHERE [SapCode] = @SapCode"

                                InsertCommand="INSERT INTO [Divisions] ([SapCode], [DivisionName]) VALUES (@SapCode, @DivisionName)"

                                SelectCommand="SELECT * FROM [Divisions]"

                                UpdateCommand="UPDATE [Divisions] SET [DivisionName] = @DivisionName WHERE [SapCode] = @SapCode">
                                <DeleteParameters>
                                    <asp:Parameter Name="SapCode" Type="Double" />
                                </DeleteParameters>
                                <InsertParameters>
                                    <asp:Parameter Name="SapCode" Type="Double" />
                                    <asp:Parameter Name="DivisionName" Type="String" />
                                </InsertParameters>
                                <UpdateParameters>
                                    <asp:Parameter Name="DivisionName" Type="String" />
                                    <asp:Parameter Name="SapCode" Type="Double" />
                                </UpdateParameters>
                            </asp:SqlDataSource>
                        </td>
                    </tr>
                </EditItemTemplate>
                <EmptyDataTemplate>
                    <table runat="server" style="">
                        <tr>
                            <td>
                                No data was returned.</td>
                        </tr>
                    </table>
                </EmptyDataTemplate>
                <InsertItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" />
                            <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" />
                        </td>
                        <td>
                            <asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="UsernameTextBox" runat="server"

                                Text='<%# Bind("Username") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="JobTitleTextBox" runat="server"

                                Text='<%# Bind("JobTitle") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="BadgeNoTextBox" runat="server" Text='<%# Bind("BadgeNo") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="EmpOrgTypeTextBox" runat="server"

                                Text='<%# Bind("EmpOrgType") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="DivisionCodeTextBox" runat="server"

                                Text='<%# Bind("DivisionCode") %>' />
                        </td>
                    </tr>
                </InsertItemTemplate>
                <ItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" />
                            <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" />
                            <asp:ImageButton ID="SelectButton" ImageUrl="images/select.png" Width="20px" runat="server" CommandName="Select" />
                        </td>
                        <td>
                            <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
                        </td>
                        <td>
                            <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' />
                        </td>
                        <td>
                            <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' />
                        </td>
                        <td>
                            <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' />
                        </td>
                        <td>
                            <asp:Label ID="EmpOrgTypeLabel" runat="server"

                                Text='<%# Eval("EmpOrgType") %>' />
                        </td>
                        <td>
                            <asp:Label ID="DivisionCodeLabel" runat="server"

                                Text='<%# Eval("DivisionCode") %>' />
                        </td>
                    </tr>
                </ItemTemplate>
                <LayoutTemplate>
                    <table ID="Table1" runat="server" border="0" style="" class="listView">
                        <tr runat="server">
                            <td runat="server">
                                <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView">
                                    <tr runat="server" style="">
                                        <th runat="server">
                                        </th>
                                        <th runat="server">
                                            Name</th>
                                        <th runat="server">
                                            Username</th>
                                        <th runat="server">
                                            JobTitle</th>
                                        <th runat="server">
                                            BadgeNo</th>
                                        <th runat="server">
                                            EmpOrgType</th>
                                        <th runat="server">
                                            DivisionCode</th>
                                    </tr>
                                    <tr ID="itemPlaceholder" runat="server">
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr runat="server">
                            <td runat="server" style="">
                                <asp:DataPager ID="DataPager1" runat="server">
                                    <Fields>
                                        <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"

                                            ShowLastPageButton="True" />
                                    </Fields>
                                </asp:DataPager>
                            </td>
                        </tr>
                    </table>
                </LayoutTemplate>
                <SelectedItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" />
                            <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" />
                        </td>
                        <td>
                            <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
                        </td>
                        <td>
                            <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' />
                        </td>
                        <td>
                            <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' />
                        </td>
                        <td>
                            <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' />
                        </td>
                        <td>
                            <asp:Label ID="EmpOrgTypeLabel" runat="server"

                                Text='<%# Eval("EmpOrgType") %>' />
                        </td>
                        <td>
                            <asp:Label ID="DivisionCodeLabel" runat="server"

                                Text='<%# Eval("DivisionCode") %>' />
                        </td>
                    </tr>
                </SelectedItemTemplate>
            </asp:ListView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server"

                ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

                DeleteCommand="DELETE FROM [employee] WHERE [Username] = @Username"

                InsertCommand="INSERT INTO [employee] ([Name], [Username], [JobTitle], [BadgeNo], [EmpOrgType], [DivisionCode]) VALUES (@Name, @Username, @JobTitle, @BadgeNo, @EmpOrgType, @DivisionCode)"

                SelectCommand="SELECT * FROM [employee]"

                UpdateCommand="UPDATE [employee] SET [Name] = @Name, [JobTitle] = @JobTitle, [BadgeNo] = @BadgeNo, [EmpOrgType] = @EmpOrgType, [DivisionCode] = @DivisionCode WHERE [Username] = @Username">
                <DeleteParameters>
                    <asp:Parameter Name="Username" Type="String" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Username" Type="String" />
                    <asp:Parameter Name="JobTitle" Type="String" />
                    <asp:Parameter Name="BadgeNo" Type="Double" />
                    <asp:Parameter Name="EmpOrgType" Type="Double" />
                    <asp:Parameter Name="DivisionCode" Type="Double" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="JobTitle" Type="String" />
                    <asp:Parameter Name="BadgeNo" Type="Double" />
                    <asp:Parameter Name="EmpOrgType" Type="Double" />
                    <asp:Parameter Name="DivisionCode" Type="Double" />
                    <asp:Parameter Name="Username" Type="String" />
                </UpdateParameters>
            </asp:SqlDataSource>
        </div>

        <div>

            <asp:ListView ID="ListView2" runat="server" DataKeyNames="ID"

                DataSourceID="SqlDataSource2" InsertItemPosition="LastItem">
                <EditItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="UpdateButton" ImageUrl="images/update4.png" Width="20px" runat="server" CommandName="Update" />
                            <asp:ImageButton ID="CancelButton" ImageUrl="images/cancel.png" Width="20px" runat="server" CommandName="Cancel" />
                        </td>
                        <%--
                        <td>
                            <asp:TextBox ID="employeeIdTextBox" runat="server"
                                Text='<%# Bind("employeeId") %>' />
                        </td>--%>
                        <td>
                            <asp:TextBox ID="courseIdTextBox" runat="server"

                                Text='<%# Bind("courseId") %>' />
                        </td>
                    </tr>
                </EditItemTemplate>
                <EmptyDataTemplate>
                    <table runat="server" style="">
                        <tr>
                            <td>
                                No data was returned.</td>
                        </tr>
                    </table>
                </EmptyDataTemplate>
                <InsertItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" />
                            <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" />
                        </td>
                        <%--<td>
                            <asp:TextBox ID="employeeIdTextBox" runat="server"
                                Text='<%# Bind("employeeId") %>' />
                        </td>--%>
                        <td>
                            <asp:TextBox ID="courseIdTextBox" runat="server"

                                Text='<%# Bind("courseId") %>' />
                        </td>
                    </tr>
                </InsertItemTemplate>
                <ItemTemplate>
                    <tr style="">
                        <td>
                            <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" />
                            <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" />
                        </td>
                        <%--<td>
                            <asp:Label ID="employeeIdLabel" runat="server"
                                Text='<%# Eval("employeeId") %>' />
                        </td>--%>
                        <td>
                            <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' />
                        </td>
                    </tr>
                </ItemTemplate>
                <LayoutTemplate>
                                <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView">
                                    <tr runat="server" style="">
                                        <th runat="server">
                                        </th>
                                        <%--<th runat="server">
                                            employeeId</th>--%>
                                        <th runat="server">
                                            courseId</th>
                                    </tr>
                                    <tr ID="itemPlaceholder" runat="server">
                                    </tr>
                                </table>
                </LayoutTemplate>
                <SelectedItemTemplate>
                    <tr style=""><br /> <br />
                        <td>
                            <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" />
                            <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" />
                        </td>
                        <%--<td>
                            <asp:Label ID="employeeIdLabel" runat="server"
                                Text='<%# Eval("employeeId") %>' />
                        </td>--%>
                        <td>
                            <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' />
                        </td>
                    </tr>
                </SelectedItemTemplate>
            </asp:ListView>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server"

                ConnectionString="<%$ ConnectionStrings:testConnectionString %>"

                DeleteCommand="DELETE FROM [employee_courses] WHERE [ID] = @ID"

                InsertCommand="INSERT INTO [employee_courses] ([employeeId], [courseId]) VALUES (@employeeId, @courseId)"

                SelectCommand="SELECT * FROM [employee_courses] WHERE ([employeeId] = @Username)"

                UpdateCommand="UPDATE [employee_courses] SET [employeeId] = @employeeId, [courseId] = @courseId WHERE [ID] = @ID">
                <DeleteParameters>
                    <asp:Parameter Name="ID" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="employeeId" Type="String" />
                    <asp:Parameter Name="courseId" Type="Int32" />
                    <asp:ControlParameter ControlID="ListView1" Name="Username" PropertyName="SelectedValue" Type="String" />
                </InsertParameters>
                <SelectParameters>
                    <asp:ControlParameter ControlID="ListView1" Name="Username"

                        PropertyName="SelectedValue" Type="String" />
                </SelectParameters>
                <UpdateParameters>
                    <%--<asp:Parameter Name="employeeId" Type="String" />--%>
                    <asp:Parameter Name="courseId" Type="Int32" />
                    <asp:Parameter Name="ID" Type="Int32" />
                </UpdateParameters>
            </asp:SqlDataSource>

Maybe this should be done programmatically in the Code-behind, but I don''t know how to do it

Any Help PLEASE?

Maybe this should be done programmatically in the Code-behind, but I don''t know how to do it

Any Help PLEASE?

推荐答案

ConnectionStrings:testConnectionString %>" span> DeleteCommand="DELETE FROM [Divisions] WHERE [SapCode] = @SapCode" span> InsertCommand="INSERT INTO [Divisions] ([SapCode], [DivisionName]) VALUES (@SapCode, @DivisionName)" span> SelectCommand="SELECT * FROM [Divisions]" span> UpdateCommand="UPDATE [Divisions] SET [DivisionName] = @DivisionName WHERE [SapCode] = @SapCode"> < DeleteParameters > <asp:Parameter Name="SapCode" Type="Double" /> < /DeleteParameters > < InsertParameters > <asp:Parameter Name="SapCode" Type="Double" /> <asp:Parameter Name="DivisionName" Type="String" /> < /InsertParameters > < UpdateParameters > <asp:Parameter Name="DivisionName" Type="String" /> <asp:Parameter Name="SapCode" Type="Double" /> < /UpdateParameters > < /asp:SqlDataSource > < /td > < /tr > < /EditItemTemplate > < EmptyDataTemplate > <table runat="server" style=""> < tr > < td > 没有返回任何数据.< /td > < /tr > < /table > < /EmptyDataTemplate > < InsertItemTemplate > < tr =" " > < td > <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" /> < /td > < td > < asp:TextBox ID =" runat 服务器" 文本 <％#Bind(" ) / > < /td > < td > <asp:TextBox ID="UsernameTextBox" runat="server" span> Text='<%# Bind("Username") %>' /> < /td > < td > <asp:TextBox ID="JobTitleTextBox" runat="server" span> Text='<%# Bind("JobTitle") %>' /> < /td > < td > <asp:TextBox ID="BadgeNoTextBox" runat="server" Text='<%# Bind("BadgeNo") %>' /> < /td > < td > <asp:TextBox ID="EmpOrgTypeTextBox" runat="server" span> Text='<%# Bind("EmpOrgType") %>' /> < /td > < td > <asp:TextBox ID="DivisionCodeTextBox" runat="server" span> Text='<%# Bind("DivisionCode") %>' /> < /td > < /tr > < /InsertItemTemplate > < ItemTemplate > < tr =" " > < td > <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> <asp:ImageButton ID="SelectButton" ImageUrl="images/select.png" Width="20px" runat="server" CommandName="Select" /> < /td > < td > <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> < /td > < td > <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' /> < /td > < td > <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' /> < /td > < td > <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' /> < /td > < td > <asp:Label ID="EmpOrgTypeLabel" runat="server" span> Text='<%# Eval("EmpOrgType") %>' /> < /td > < td > <asp:Label ID="DivisionCodeLabel" runat="server" span> Text='<%# Eval("DivisionCode") %>' /> < /td > < /tr > < /ItemTemplate > < LayoutTemplate > <table ID="Table1" runat="server" border="0" style="" class="listView"> <tr runat="server"> <td runat="server"> <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView"> <tr runat="server" style=""> <th runat="server"> < /th > <th runat="server"> Name</th> <th runat="server"> Username</th> <th runat="server"> JobTitle</th> <th runat="server"> BadgeNo</th> <th runat="server"> EmpOrgType</th> <th runat="server"> DivisionCode</th> < /tr > <tr ID="itemPlaceholder" runat="server"> < /tr > < /table > < /td > < /tr > <tr runat="server"> <td runat="server" style=""> < asp:DataPager ID =" runat 服务器" < 字段 > <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" span> ShowLastPageButton="True" /> < /Fields > < /asp:DataPager > < /td > < /tr > < /table > < /LayoutTemplate > < SelectedItemTemplate > < tr =" " > < td > <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> < /td > < td > <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> < /td > < td > <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' /> < /td > < td > <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' /> < /td > < td > <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' /> < /td > < td > <asp:Label ID="EmpOrgTypeLabel" runat="server" span> Text='<%# Eval("EmpOrgType") %>' /> < /td > < td > <asp:Label ID="DivisionCodeLabel" runat="server" span> Text='<%# Eval("DivisionCode") %>' /> < /td > < /tr > < /SelectedItemTemplate > < /asp:ListView > < asp:SqlDataSource ID =" runat 服务器" ConnectionString="<%

ConnectionStrings:testConnectionString %>" DeleteCommand="DELETE FROM [Divisions] WHERE [SapCode] = @SapCode" InsertCommand="INSERT INTO [Divisions] ([SapCode], [DivisionName]) VALUES (@SapCode, @DivisionName)" SelectCommand="SELECT * FROM [Divisions]" UpdateCommand="UPDATE [Divisions] SET [DivisionName] = @DivisionName WHERE [SapCode] = @SapCode"> <DeleteParameters> <asp:Parameter Name="SapCode" Type="Double" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="SapCode" Type="Double" /> <asp:Parameter Name="DivisionName" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="DivisionName" Type="String" /> <asp:Parameter Name="SapCode" Type="Double" /> </UpdateParameters> </asp:SqlDataSource> </td> </tr> </EditItemTemplate> <EmptyDataTemplate> <table runat="server" style=""> <tr> <td> No data was returned.</td> </tr> </table> </EmptyDataTemplate> <InsertItemTemplate> <tr style=""> <td> <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" /> </td> <td> <asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' /> </td> <td> <asp:TextBox ID="UsernameTextBox" runat="server" Text='<%# Bind("Username") %>' /> </td> <td> <asp:TextBox ID="JobTitleTextBox" runat="server" Text='<%# Bind("JobTitle") %>' /> </td> <td> <asp:TextBox ID="BadgeNoTextBox" runat="server" Text='<%# Bind("BadgeNo") %>' /> </td> <td> <asp:TextBox ID="EmpOrgTypeTextBox" runat="server" Text='<%# Bind("EmpOrgType") %>' /> </td> <td> <asp:TextBox ID="DivisionCodeTextBox" runat="server" Text='<%# Bind("DivisionCode") %>' /> </td> </tr> </InsertItemTemplate> <ItemTemplate> <tr style=""> <td> <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> <asp:ImageButton ID="SelectButton" ImageUrl="images/select.png" Width="20px" runat="server" CommandName="Select" /> </td> <td> <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' /> </td> <td> <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' /> </td> <td> <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' /> </td> <td> <asp:Label ID="EmpOrgTypeLabel" runat="server" Text='<%# Eval("EmpOrgType") %>' /> </td> <td> <asp:Label ID="DivisionCodeLabel" runat="server" Text='<%# Eval("DivisionCode") %>' /> </td> </tr> </ItemTemplate> <LayoutTemplate> <table ID="Table1" runat="server" border="0" style="" class="listView"> <tr runat="server"> <td runat="server"> <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView"> <tr runat="server" style=""> <th runat="server"> </th> <th runat="server"> Name</th> <th runat="server"> Username</th> <th runat="server"> JobTitle</th> <th runat="server"> BadgeNo</th> <th runat="server"> EmpOrgType</th> <th runat="server"> DivisionCode</th> </tr> <tr ID="itemPlaceholder" runat="server"> </tr> </table> </td> </tr> <tr runat="server"> <td runat="server" style=""> <asp:DataPager ID="DataPager1" runat="server"> <Fields> <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" /> </Fields> </asp:DataPager> </td> </tr> </table> </LayoutTemplate> <SelectedItemTemplate> <tr style=""> <td> <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> </td> <td> <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="UsernameLabel" runat="server" Text='<%# Eval("Username") %>' /> </td> <td> <asp:Label ID="JobTitleLabel" runat="server" Text='<%# Eval("JobTitle") %>' /> </td> <td> <asp:Label ID="BadgeNoLabel" runat="server" Text='<%# Eval("BadgeNo") %>' /> </td> <td> <asp:Label ID="EmpOrgTypeLabel" runat="server" Text='<%# Eval("EmpOrgType") %>' /> </td> <td> <asp:Label ID="DivisionCodeLabel" runat="server" Text='<%# Eval("DivisionCode") %>' /> </td> </tr> </SelectedItemTemplate> </asp:ListView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%

ConnectionStrings:testConnectionString %>" DeleteCommand="DELETE FROM [employee] WHERE [Username] = @Username" InsertCommand="INSERT INTO [employee] ([Name], [Username], [JobTitle], [BadgeNo], [EmpOrgType], [DivisionCode]) VALUES (@Name, @Username, @JobTitle, @BadgeNo, @EmpOrgType, @DivisionCode)" SelectCommand="SELECT * FROM [employee]" UpdateCommand="UPDATE [employee] SET [Name] = @Name, [JobTitle] = @JobTitle, [BadgeNo] = @BadgeNo, [EmpOrgType] = @EmpOrgType, [DivisionCode] = @DivisionCode WHERE [Username] = @Username"> < DeleteParameters > <asp:Parameter Name="Username" Type="String" /> < /DeleteParameters > < InsertParameters > < asp:Parameter 名称 =" 类型 字符串" / <asp:Parameter Name="Username" Type="String" /> <asp:Parameter Name="JobTitle" Type="String" /> <asp:Parameter Name="BadgeNo" Type="Double" /> <asp:Parameter Name="EmpOrgType" Type="Double" /> <asp:Parameter Name="DivisionCode" Type="Double" /> < /InsertParameters > < UpdateParameters > < asp:Parameter 名称 =" 类型 字符串" / <asp:Parameter Name="JobTitle" Type="String" /> <asp:Parameter Name="BadgeNo" Type="Double" /> <asp:Parameter Name="EmpOrgType" Type="Double" /> <asp:Parameter Name="DivisionCode" Type="Double" /> <asp:Parameter Name="Username" Type="String" /> < /UpdateParameters > < /asp:SqlDataSource > < /div > < div > <asp:ListView ID="ListView2" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource2" InsertItemPosition="LastItem"> < EditItemTemplate > < tr =" " > < td > <asp:ImageButton ID="UpdateButton" ImageUrl="images/update4.png" Width="20px" runat="server" CommandName="Update" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/cancel.png" Width="20px" runat="server" CommandName="Cancel" /> < /td > <％- <td> <asp:TextBox ID="employeeIdTextBox" runat="server" Text='<%# Bind("employeeId") %>'/> </ td > - ％> < td > <asp:TextBox ID="courseIdTextBox" runat="server" span> Text='<%# Bind("courseId") %>' /> < /td > < /tr > < /EditItemTemplate > < EmptyDataTemplate > <table runat="server" style=""> < tr > < td > 没有返回任何数据.< /td > < /tr > < /table > < /EmptyDataTemplate > < InsertItemTemplate > < tr =" " > < td > <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" /> < /td > <％-< td> <asp:TextBox ID="employeeIdTextBox" runat="server" Text='<%# Bind("employeeId") %>'/> </ td > - ％> < td > <asp:TextBox ID="courseIdTextBox" runat="server" span> Text='<%# Bind("courseId") %>' /> < /td > < /tr > < /InsertItemTemplate > < ItemTemplate > < tr =" " > < td > <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> < /td > <％-< td> <asp:Label ID="employeeIdLabel" runat="server" Text='<%# Eval("employeeId") %>'/> </ td > - ％> < td > <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' /> < /td > < /tr > < /ItemTemplate > < LayoutTemplate > <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView"> <tr runat="server" style=""> <th runat="server"> < /th > <%--<th runat="server"> employeeId</th>--%> <th runat="server"> courseId</th> < /tr > <tr ID="itemPlaceholder" runat="server"> < /tr > < /table > < /LayoutTemplate > < SelectedItemTemplate > <tr style=""><br /> <br /> < td > <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> < /td > <％-< td> <asp:Label ID="employeeIdLabel" runat="server" Text='<%# Eval("employeeId") %>'/> </ td > - ％> < td > <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' /> < /td > < /tr > < /SelectedItemTemplate > < /asp:ListView > < asp:SqlDataSource ID =" runat 服务器" ConnectionString="<%

ConnectionStrings:testConnectionString %>" DeleteCommand="DELETE FROM [employee] WHERE [Username] = @Username" InsertCommand="INSERT INTO [employee] ([Name], [Username], [JobTitle], [BadgeNo], [EmpOrgType], [DivisionCode]) VALUES (@Name, @Username, @JobTitle, @BadgeNo, @EmpOrgType, @DivisionCode)" SelectCommand="SELECT * FROM [employee]" UpdateCommand="UPDATE [employee] SET [Name] = @Name, [JobTitle] = @JobTitle, [BadgeNo] = @BadgeNo, [EmpOrgType] = @EmpOrgType, [DivisionCode] = @DivisionCode WHERE [Username] = @Username"> <DeleteParameters> <asp:Parameter Name="Username" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Username" Type="String" /> <asp:Parameter Name="JobTitle" Type="String" /> <asp:Parameter Name="BadgeNo" Type="Double" /> <asp:Parameter Name="EmpOrgType" Type="Double" /> <asp:Parameter Name="DivisionCode" Type="Double" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="JobTitle" Type="String" /> <asp:Parameter Name="BadgeNo" Type="Double" /> <asp:Parameter Name="EmpOrgType" Type="Double" /> <asp:Parameter Name="DivisionCode" Type="Double" /> <asp:Parameter Name="Username" Type="String" /> </UpdateParameters> </asp:SqlDataSource> </div> <div> <asp:ListView ID="ListView2" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource2" InsertItemPosition="LastItem"> <EditItemTemplate> <tr style=""> <td> <asp:ImageButton ID="UpdateButton" ImageUrl="images/update4.png" Width="20px" runat="server" CommandName="Update" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/cancel.png" Width="20px" runat="server" CommandName="Cancel" /> </td> <%-- <td> <asp:TextBox ID="employeeIdTextBox" runat="server" Text='<%# Bind("employeeId") %>' /> </td>--%> <td> <asp:TextBox ID="courseIdTextBox" runat="server" Text='<%# Bind("courseId") %>' /> </td> </tr> </EditItemTemplate> <EmptyDataTemplate> <table runat="server" style=""> <tr> <td> No data was returned.</td> </tr> </table> </EmptyDataTemplate> <InsertItemTemplate> <tr style=""> <td> <asp:ImageButton ID="ImageButton1" ImageUrl="images/insert.png" Width="20px" runat="server" CommandName="Insert" /> <asp:ImageButton ID="CancelButton" ImageUrl="images/clear3.png" Width="20px" runat="server" CommandName="Cancel" /> </td> <%--<td> <asp:TextBox ID="employeeIdTextBox" runat="server" Text='<%# Bind("employeeId") %>' /> </td>--%> <td> <asp:TextBox ID="courseIdTextBox" runat="server" Text='<%# Bind("courseId") %>' /> </td> </tr> </InsertItemTemplate> <ItemTemplate> <tr style=""> <td> <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> </td> <%--<td> <asp:Label ID="employeeIdLabel" runat="server" Text='<%# Eval("employeeId") %>' /> </td>--%> <td> <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' /> </td> </tr> </ItemTemplate> <LayoutTemplate> <table ID="itemPlaceholderContainer" runat="server" border="0" style="" class="listView"> <tr runat="server" style=""> <th runat="server"> </th> <%--<th runat="server"> employeeId</th>--%> <th runat="server"> courseId</th> </tr> <tr ID="itemPlaceholder" runat="server"> </tr> </table> </LayoutTemplate> <SelectedItemTemplate> <tr style=""><br /> <br /> <td> <asp:ImageButton ID="DeleteButton" ImageUrl="images/delete.png" Width="20px" runat="server" CommandName="Delete" /> <asp:ImageButton ID="EditButton" ImageUrl="images/edit.png" Width="20px" runat="server" CommandName="Edit" /> </td> <%--<td> <asp:Label ID="employeeIdLabel" runat="server" Text='<%# Eval("employeeId") %>' /> </td>--%> <td> <asp:Label ID="courseIdLabel" runat="server" Text='<%# Eval("courseId") %>' /> </td> </tr> </SelectedItemTemplate> </asp:ListView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%

ConnectionStrings:testConnectionString %>" DeleteCommand="DELETE FROM [employee_courses] WHERE [ID] = @ID" InsertCommand="INSERT INTO [employee_courses] ([employeeId], [courseId]) VALUES (@employeeId, @courseId)" SelectCommand="SELECT * FROM [employee_courses] WHERE ([employeeId] = @Username)" UpdateCommand="UPDATE [employee_courses] SET [employeeId] = @employeeId, [courseId] = @courseId WHERE [ID] = @ID"> < DeleteParameters > < asp:Parameter 名称 =" 类型 Int32 " / < /DeleteParameters > < InsertParameters > <asp:Parameter Name="employeeId" Type="String" /> <asp:Parameter Name="courseId" Type="Int32" /> <asp:ControlParameter ControlID="ListView1" Name="Username" PropertyName="SelectedValue" Type="String" /> < /InsertParameters > < SelectParameters > <asp:ControlParameter ControlID="ListView1" Name="Username" PropertyName="SelectedValue" Type="String" /> < /SelectParameters > < UpdateParameters > <%--<asp:Parameter Name="employeeId" Type="String"/>--%> <asp:Parameter Name="courseId" Type="Int32" /> < asp:Parameter 名称 =" 类型 Int32 " / < /UpdateParameters > < /asp:SqlDataSource >

ConnectionStrings:testConnectionString %>" DeleteCommand="DELETE FROM [employee_courses] WHERE [ID] = @ID" InsertCommand="INSERT INTO [employee_courses] ([employeeId], [courseId]) VALUES (@employeeId, @courseId)" SelectCommand="SELECT * FROM [employee_courses] WHERE ([employeeId] = @Username)" UpdateCommand="UPDATE [employee_courses] SET [employeeId] = @employeeId, [courseId] = @courseId WHERE [ID] = @ID"> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="employeeId" Type="String" /> <asp:Parameter Name="courseId" Type="Int32" /> <asp:ControlParameter ControlID="ListView1" Name="Username" PropertyName="SelectedValue" Type="String" /> </InsertParameters> <SelectParameters> <asp:ControlParameter ControlID="ListView1" Name="Username" PropertyName="SelectedValue" Type="String" /> </SelectParameters> <UpdateParameters> <%--<asp:Parameter Name="employeeId" Type="String" />--%> <asp:Parameter Name="courseId" Type="Int32" /> <asp:Parameter Name="ID" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource>

Maybe this should be done programmatically in the Code-behind, but I don''t know how to do it

Any Help PLEASE?

Maybe this should be done programmatically in the Code-behind, but I don''t know how to do it

Any Help PLEASE?

这篇关于在第一个表中选择用户后，如何将数据从数据库检索到第二个表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！