使用 GridView 控件和 SqlDataSource 控件显示乐知班学生名单_使用gridview控件和dataset对象管理学生信息-优快云博客

本文链接：https://blog.youkuaiyun.com/qiyihan0911/article/details/8276416

本文介绍了一个使用ASP.NET实现的学生管理系统，包括数据源配置、数据操作（增删改查）、分页显示及排序功能，以及与之配套的GridView组件进行数据展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<form id="form1" runat="server">
    <div>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:TestConnectionString %>"

            SelectCommand="SELECT [FId], [FName], [FAge], [FGender], [FMath], [FEnglish] FROM [MyStudents]"
            ConflictDetection="CompareAllValues"
            DeleteCommand="DELETE FROM [MyStudents] WHERE [FId] = @original_FId AND (([FName] = @original_FName) OR ([FName] IS NULL AND @original_FName IS NULL)) AND (([FAge] = @original_FAge) OR ([FAge] IS NULL AND @original_FAge IS NULL)) AND (([FGender] = @original_FGender) OR ([FGender] IS NULL AND @original_FGender IS NULL)) AND (([FMath] = @original_FMath) OR ([FMath] IS NULL AND @original_FMath IS NULL)) AND (([FEnglish] = @original_FEnglish) OR ([FEnglish] IS NULL AND @original_FEnglish IS NULL))"
            InsertCommand="INSERT INTO [MyStudents] ([FName], [FAge], [FGender], [FMath], [FEnglish]) VALUES (@FName, @FAge, @FGender, @FMath, @FEnglish)"
            OldValuesParameterFormatString="original_{0}"
            UpdateCommand="UPDATE [MyStudents] SET [FName] = @FName, [FAge] = @FAge, [FGender] = @FGender, [FMath] = @FMath, [FEnglish] = @FEnglish WHERE [FId] = @original_FId AND (([FName] = @original_FName) OR ([FName] IS NULL AND @original_FName IS NULL)) AND (([FAge] = @original_FAge) OR ([FAge] IS NULL AND @original_FAge IS NULL)) AND (([FGender] = @original_FGender) OR ([FGender] IS NULL AND @original_FGender IS NULL)) AND (([FMath] = @original_FMath) OR ([FMath] IS NULL AND @original_FMath IS NULL)) AND (([FEnglish] = @original_FEnglish) OR ([FEnglish] IS NULL AND @original_FEnglish IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_FId" Type="Int32" />
                <asp:Parameter Name="original_FName" Type="String" />
                <asp:Parameter Name="original_FAge" Type="Int32" />
                <asp:Parameter Name="original_FGender" Type="String" />
                <asp:Parameter Name="original_FMath" Type="Double" />
                <asp:Parameter Name="original_FEnglish" Type="Double" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="FName" Type="String" />
                <asp:Parameter Name="FAge" Type="Int32" />
                <asp:Parameter Name="FGender" Type="String" />
                <asp:Parameter Name="FMath" Type="Double" />
                <asp:Parameter Name="FEnglish" Type="Double" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="FName" Type="String" />
                <asp:Parameter Name="FAge" Type="Int32" />
                <asp:Parameter Name="FGender" Type="String" />
                <asp:Parameter Name="FMath" Type="Double" />
                <asp:Parameter Name="FEnglish" Type="Double" />
                <asp:Parameter Name="original_FId" Type="Int32" />
                <asp:Parameter Name="original_FName" Type="String" />
                <asp:Parameter Name="original_FAge" Type="Int32" />
                <asp:Parameter Name="original_FGender" Type="String" />
                <asp:Parameter Name="original_FMath" Type="Double" />
                <asp:Parameter Name="original_FEnglish" Type="Double" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <br />

    </div>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
        AllowSorting="True" AutoGenerateColumns="False"
        DataSourceID="SqlDataSource1" CellPadding="4" DataKeyNames="FId"
        ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
                ShowSelectButton="True" HeaderText="操作"/>
            <asp:BoundField DataField="FId" HeaderText="学号" SortExpression="FId"
                InsertVisible="False" ReadOnly="True" />
            <asp:BoundField DataField="FName" HeaderText="姓名"
                SortExpression="FName" />
            <asp:BoundField DataField="FAge" HeaderText="年龄" SortExpression="FAge" />
            <asp:BoundField DataField="FGender" HeaderText="性别"
                SortExpression="FGender" />
            <asp:BoundField DataField="FMath" HeaderText="数学成绩"
                SortExpression="FMath" />
            <asp:BoundField DataField="FEnglish" HeaderText="英语成绩"
                SortExpression="FEnglish" />
        </Columns>
        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
        <SortedAscendingCellStyle BackColor="#FDF5AC" />
        <SortedAscendingHeaderStyle BackColor="#4D0000" />
        <SortedDescendingCellStyle BackColor="#FCF6C0" />
        <SortedDescendingHeaderStyle BackColor="#820000" />
    </asp:GridView>
    </form>