C#从数据库填充CheckBoxList (奇怪的列/标题文本名称)

using System;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // 连接数据库
        string connectionString = "YourConnectionString";
        SqlConnection connection = new SqlConnection(connectionString);

        // 执行查询
        string query = "SELECT Id, Name FROM YourTable";
        SqlCommand command = new SqlCommand(query, connection);

        connection.Open();

        // 处理查询结果
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            // 读取数据并添加到CheckBoxList
            ListItem item = new ListItem();
            item.Text = reader["Name"].ToString();
            item.Value = reader["Id"].ToString();
            CheckBoxList1.Items.Add(item);
        }

        connection.Close();

        // 绑定数据
        CheckBoxList1.DataBind();
    }
}