如何在C#中从数据库中检索和显示单选按钮值

using System;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // 连接数据库
            string connectionString = "YourConnectionString";
            SqlConnection connection = new SqlConnection(connectionString);

            // 执行查询
            string query = "SELECT RadioButtonValue FROM YourTable";
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            // 处理查询结果
            while (reader.Read())
            {
                int radioButtonValue = reader.GetInt32(0);

                // 设置单选按钮的值
                if (radioButtonValue == 1)
                {
                    radioButton1.Checked = true;
                }
                else if (radioButtonValue == 2)
                {
                    radioButton2.Checked = true;
                }
                // 可以根据需要继续添加其他选项

                // 如果只有一个选项，可以使用以下代码
                // radioButton1.Checked = (radioButtonValue == 1);
            }

            // 关闭连接和读取器
            reader.Close();
            connection.Close();
        }
    }
}