xs.aspx

一个简单的个人课程管理系统 主要功能有登陆 个人课程查看 添加 删除等

            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundField DataField="Cnumber" HeaderText="课程号" ReadOnly="True" SortExpression="Cnumber" />
                <asp:BoundField DataField="Cname" HeaderText="课程名" SortExpression="Cname" />
                <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
                <asp:BoundField DataField="Ccredit" HeaderText="学分" SortExpression="Ccredit" />
                <asp:BoundField DataField="Ctime" HeaderText="上课时间" SortExpression="Ctime" />
                <asp:BoundField DataField="Cclassrom" HeaderText="教室" SortExpression="Cclassrom" />
            </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:courseConnectionString6 %>"
            SelectCommand="SELECT * FROM [CourseInformation]"></asp:SqlDataSource>
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None"
            Style="z-index: 103; left: 247px; position: absolute; top: 487px" Visible="False"
            Width="516px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundField DataField="Uaccouts" HeaderText="用户号" ReadOnly="True" SortExpression="Uaccouts" />
                <asp:BoundField DataField="Upassword" HeaderText="用户密码" SortExpression="Upassword" />
                <asp:BoundField DataField="Uname" HeaderText="用户名" SortExpression="Uname" />
                <asp:BoundField DataField="Uacademy" HeaderText="学院" SortExpression="Uacademy" />
                <asp:BoundField DataField="Uclass" HeaderText="班级" SortExpression="Uclass" />
                <asp:BoundField DataField="Usort" HeaderText="用户类别" SortExpression="Usort" />
            </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="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:courseConnectionString9 %>"
            SelectCommand="SELECT * FROM [UserInformation] WHERE ([Uaccouts] = @Uaccouts)">
            <SelectParameters>
                <asp:SessionParameter Name="Uaccouts" SessionField="Uaccouts" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Cnumber" DataSourceID="SqlDataSource4"
            ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridView4_SelectedIndexChanged"
            Style="z-index: 104; left: 253px; position: absolute; top: 453px" Visible="False"
            Width="511px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundField DataField="Cnumber" HeaderText="课程号" ReadOnly="True" SortExpression="Cnumber" />
                <asp:BoundField DataField="Cname" HeaderText="课程名" SortExpression="Cname" />
                <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
                <asp:BoundField DataField="Ccredit" HeaderText="学分" SortExpression="Ccredit" />
                <asp:BoundField DataField="Ctime" HeaderText="上课时间" SortExpression="Ctime" />
                <asp:BoundField DataField="Cclassrom" HeaderText="教室" SortExpression="Cclassrom" />
            </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="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:courseConnectionString7 %>"
            SelectCommand="SELECT * FROM [CourseInformation] WHERE ([Cnumber] = @Cnumber)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="Cnumber" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;
        <asp:GridView ID="GridView5" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Cnumber" DataSourceID="SqlDataSource5"
            ForeColor="#333333" GridLines="None" Style="z-index: 105; left: 251px; position: absolute;
            top: 455px" Visible="False" Width="517px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundField DataField="Cnumber" HeaderText="课程号" ReadOnly="True" SortExpression="Cnumber" />
                <asp:BoundField DataField="Cname" HeaderText="课程名" SortExpression="Cname" />
                <asp:BoundField DataField="Cteacher" HeaderText="教师" SortExpression="Cteacher" />
                <asp:BoundField DataField="Ccredit" HeaderText="学分" SortExpression="Ccredit" />
                <asp:BoundField DataField="Ctime" HeaderText="上课时间" SortExpression="Ctime" />
                <asp:BoundField DataField="Cclassrom" HeaderText="教室" SortExpression="Cclassrom" />
            </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:HyperLink ID="HyperLink1" runat="server" BackColor="White" ForeColor="Desktop"
            NavigateUrl="~/SY.aspx" Style="z-index: 106; left: 718px; position: absolute;
            top: 124px">退出系统</asp:HyperLink>
        <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:courseConnectionString8 %>"
            SelectCommand="SELECT * FROM [CourseInformation] WHERE ([Cname] = @Cname)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox2" Name="Cname" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:LinkButton ID="LinkButton1" runat="server" ForeColor="Desktop" PostBackUrl="~/XG.aspx"
            Style="z-index: 109; left: 611px; position: absolute; top: 124px">修改密码</asp:LinkButton>
    </form>
</body>
</html>