protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
string query = "SELECT Value, Label FROM ValuesTable";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ListItem item = new ListItem(reader["Label"].ToString(), reader["Value"].ToString());
rblValues.Items.Add(item);
}
conn.Close();
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string selectedValue = rblValues.SelectedValue;
// 保存所选值到数据库中
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
string query = "SELECT Value, Label FROM ValuesTable";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ListItem item = new ListItem(reader["Label"].ToString(), reader["Value"].ToString());
rblValues.Items.Add(item);
}
conn.Close();
}
}
// 默认选择第一个单选按钮
rblValues.Items[0].Selected = true;
}
}
这样就可以使用ASP.NET和SQL数据库选择和编辑单选按钮列表中的值了。