adminedit_3.aspx.exclude

B/S asp.net的C#编的网站

                        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
                            DeleteCommand="DELETE FROM [Teacher] WHERE [TeacherID] = @TeacherID" InsertCommand="INSERT INTO [Teacher] ([Name], [Sex], [Phone], [Mobile], [Email], [Size], [Address], [Code], [TeamID]) VALUES (@Name, @Sex, @Phone, @Mobile, @Email, @Size, @Address, @Code, @TeamID)"
                            ProviderName="<%$ ConnectionStrings:ACMConnectionString1.ProviderName %>" SelectCommand="SELECT * FROM [Teacher] WHERE ([TeamID] = @TeamID)"
                            UpdateCommand="UPDATE [Teacher] SET [Name] = @Name, [Sex] = @Sex, [Phone] = @Phone, [Mobile] = @Mobile, [Email] = @Email, [Size] = @Size, [Address] = @Address, [Code] = @Code, [TeamID] = @TeamID WHERE [TeacherID] = @TeacherID">
                            <DeleteParameters>
                                <asp:Parameter Name="TeacherID" Type="Int32" />
                            </DeleteParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Sex" Type="String" />
                                <asp:Parameter Name="Phone" Type="String" />
                                <asp:Parameter Name="Mobile" Type="String" />
                                <asp:Parameter Name="Email" Type="String" />
                                <asp:Parameter Name="Size" Type="String" />
                                <asp:Parameter Name="Address" Type="String" />
                                <asp:Parameter Name="Code" Type="String" />
                                <asp:Parameter Name="TeamID" Type="Int32" />
                                <asp:Parameter Name="TeacherID" Type="Int32" />
                            </UpdateParameters>
                            <SelectParameters>
                                <asp:SessionParameter Name="TeamID" SessionField="id" Type="Int32" />
                            </SelectParameters>
                            <InsertParameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Sex" Type="String" />
                                <asp:Parameter Name="Phone" Type="String" />
                                <asp:Parameter Name="Mobile" Type="String" />
                                <asp:Parameter Name="Email" Type="String" />
                                <asp:Parameter Name="Size" Type="String" />
                                <asp:Parameter Name="Address" Type="String" />
                                <asp:Parameter Name="Code" Type="String" />
                                <asp:Parameter Name="TeamID" Type="Int32" />
                            </InsertParameters>
                        </asp:SqlDataSource>
                        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CellPadding="4"
                            DataKeyNames="PlayID" DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None">
                            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:CommandField ShowEditButton="True" />
                                <asp:BoundField DataField="PlayID" HeaderText="PlayID" ReadOnly="True" SortExpression="PlayID" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
                                <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
                                <asp:BoundField DataField="Size" HeaderText="Size" SortExpression="Size" />
                                <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
                                <asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" />
                                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                                <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
                                <asp:BoundField DataField="Code" HeaderText="Code" SortExpression="Code" />
                                <asp:BoundField DataField="MSchool" HeaderText="MSchool" SortExpression="MSchool" />
                                <asp:BoundField DataField="HSchool" HeaderText="HSchool" SortExpression="HSchool" />
                                <asp:BoundField DataField="Merit" HeaderText="Merit" SortExpression="Merit" />
                            </Columns>
                            <RowStyle BackColor="#E3EAEB" />
                            <EditRowStyle BackColor="#7C6F57" />
                            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <AlternatingRowStyle BackColor="White" />
                        </asp:GridView>
                        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
                            DeleteCommand="DELETE FROM [Player] WHERE [PlayID] = @PlayID" InsertCommand="INSERT INTO [Player] ([Name], [Sex], [Age], [Size], [Phone], [Mobile], [Email], [Address], [Code], [MSchool], [HSchool], [TeamID], [Merit]) VALUES (@Name, @Sex, @Age, @Size, @Phone, @Mobile, @Email, @Address, @Code, @MSchool, @HSchool, @TeamID, @Merit)"
                            ProviderName="<%$ ConnectionStrings:ACMConnectionString1.ProviderName %>" SelectCommand="SELECT * FROM [Player] WHERE ([TeamID] = @TeamID)"
                            UpdateCommand="UPDATE [Player] SET [Name] = @Name, [Sex] = @Sex, [Age] = @Age, [Size] = @Size, [Phone] = @Phone, [Mobile] = @Mobile, [Email] = @Email, [Address] = @Address, [Code] = @Code, [MSchool] = @MSchool, [HSchool] = @HSchool, [TeamID] = @TeamID, [Merit] = @Merit WHERE [PlayID] = @PlayID">
                            <DeleteParameters>
                                <asp:Parameter Name="PlayID" Type="Int32" />
                            </DeleteParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Sex" Type="String" />
                                <asp:Parameter Name="Age" Type="Int16" />
                                <asp:Parameter Name="Size" Type="String" />
                                <asp:Parameter Name="Phone" Type="String" />
                                <asp:Parameter Name="Mobile" Type="String" />
                                <asp:Parameter Name="Email" Type="String" />
                                <asp:Parameter Name="Address" Type="String" />
                                <asp:Parameter Name="Code" Type="Int64" />
                                <asp:Parameter Name="MSchool" Type="String" />
                                <asp:Parameter Name="HSchool" Type="String" />
                                <asp:Parameter Name="TeamID" Type="Int32" />
                                <asp:Parameter Name="Merit" Type="String" />
                                <asp:Parameter Name="PlayID" Type="Int32" />
                            </UpdateParameters>
                            <SelectParameters>
                                <asp:SessionParameter Name="TeamID" SessionField="id" Type="Int32" />
                            </SelectParameters>
                            <InsertParameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Sex" Type="String" />
                                <asp:Parameter Name="Age" Type="Int16" />
                                <asp:Parameter Name="Size" Type="String" />
                                <asp:Parameter Name="Phone" Type="String" />
                                <asp:Parameter Name="Mobile" Type="String" />
                                <asp:Parameter Name="Email" Type="String" />
                                <asp:Parameter Name="Address" Type="String" />
                                <asp:Parameter Name="Code" Type="Int64" />
                                <asp:Parameter Name="MSchool" Type="String" />
                                <asp:Parameter Name="HSchool" Type="String" />
                                <asp:Parameter Name="TeamID" Type="Int32" />
                                <asp:Parameter Name="Merit" Type="String" />
                            </InsertParameters>
                        </asp:SqlDataSource>
                    </td>
                </tr>
                <tr>
                    <td align="left" style="width: 100px" valign="top">
                    </td>
                </tr>
            </table>
        </div>
    
    </div>
    </form>
</body>
</html>