ListView更新数据库：ASP.NET带复选框的ListView数据更新问题

Hey there! Congrats on your first Stack Overflow post—welcome to the community! 🎉 Let's get that attendance-check ListView working properly, since you're already making great strides with ASP.NET.

First, let's make sure your ListView is set up to pass the necessary data to the backend when a checkbox is toggled. Here's how to structure your front-end markup:

<asp:ListView ID="AttendanceListView" runat="server" DataKeyNames="StudentID">
    <LayoutTemplate>
        <table style="border-collapse: collapse; width: 100%;">
            <tr>
                <th style="border: 1px solid #ccc; padding: 8px;">Student Name</th>
                <th style="border: 1px solid #ccc; padding: 8px;">Present?</th>
            </tr>
            <asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
        </table>
    </LayoutTemplate>
    <ItemTemplate>
        <tr>
            <td style="border: 1px solid #ccc; padding: 8px;"><%# Eval("StudentName") %></td>
            <td style="border: 1px solid #ccc; padding: 8px; text-align: center;">
                <asp:CheckBox ID="chkAttendance" runat="server" 
                    AutoPostBack="true" 
                    OnCheckedChanged="chkAttendance_CheckedChanged"
                    Checked='<%# Convert.ToBoolean(Eval("IsPresent")) %>' />
            </td>
        </tr>
    </ItemTemplate>
</asp:ListView>

Key details here:

• DataKeyNames="StudentID" tells the ListView to track the unique ID for each record (adjust this to match your table's primary key)
• AutoPostBack="true" ensures the page sends a request to the server when the checkbox is clicked
• OnCheckedChanged="chkAttendance_CheckedChanged" links the checkbox to our backend event handler
• We bind the Checked property to the IsPresent column from your DataTable to show the current attendance status

Next, let's handle the backend logic. First, make sure you're binding your DataTable correctly on page load (only on the first load, not postbacks):

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // Replace this with your code to populate the DataTable from your database
        DataTable attendanceTable = GetAttendanceData();
        AttendanceListView.DataSource = attendanceTable;
        AttendanceListView.DataBind();
    }
}

// Example method to get your data (adjust to your actual data access logic)
private DataTable GetAttendanceData()
{
    string connectionString = ConfigurationManager.ConnectionStrings["YourDbConnection"].ConnectionString;
    DataTable dt = new DataTable();
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "SELECT StudentID, StudentName, IsPresent FROM Attendance WHERE ClassDate = @ClassDate";
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
            cmd.Parameters.AddWithValue("@ClassDate", DateTime.Today); // Adjust to your filter
            conn.Open();
            dt.Load(cmd.ExecuteReader());
        }
    }
    return dt;
}

Now the critical part: updating the database when the checkbox is toggled. Add this event handler to your code-behind:

protected void chkAttendance_CheckedChanged(object sender, EventArgs e)
{
    // Get the checkbox that was clicked
    CheckBox clickedCheckbox = (CheckBox)sender;
    // Get the parent ListView item to access the data key
    ListViewItem listItem = (ListViewItem)clickedCheckbox.NamingContainer;
    
    // Retrieve the unique StudentID from the ListView's DataKeys
    int studentId = Convert.ToInt32(AttendanceListView.DataKeys[listItem.DataItemIndex].Value);
    bool isPresent = clickedCheckbox.Checked;

    // Update the database with parameterized query (prevents SQL injection)
    string connectionString = ConfigurationManager.ConnectionStrings["YourDbConnection"].ConnectionString;
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string updateQuery = "UPDATE Attendance SET IsPresent = @IsPresent WHERE StudentID = @StudentID";
        using (SqlCommand cmd = new SqlCommand(updateQuery, conn))
        {
            cmd.Parameters.AddWithValue("@IsPresent", isPresent);
            cmd.Parameters.AddWithValue("@StudentID", studentId);
            
            conn.Open();
            cmd.ExecuteNonQuery();
        }
    }

    // Optional: Uncomment to refresh the ListView and show changes immediately
    // AttendanceListView.DataBind();
}

If you're using Entity Framework instead of raw SQL, here's a simpler alternative for the update step:

using (var dbContext = new YourSchoolDbContext())
{
    var attendanceRecord = dbContext.Attendance.FirstOrDefault(a => a.StudentID == studentId);
    if (attendanceRecord != null)
    {
        attendanceRecord.IsPresent = isPresent;
        dbContext.SaveChanges();
    }
}

Quick troubleshooting tips if you run into issues:

• Make sure AutoPostBack is set to true on the checkbox (easy to miss!)
• Verify your Web.config has a valid connection string under <connectionStrings>
• Add a try-catch block around the database code to catch and inspect specific errors

Hope this gets you up and running smoothly! Let me know if you hit any snags.

内容的提问来源于stack exchange，提问作者Billson3000