使用来自SQL Server的数据填充Blazor/Razor中的下拉列表

@page "/dropdownlist"
@using System.Data.SqlClient

<select @bind="selectedOption">
    <option value="">请选择</option>
    @foreach (var option in options)
    {
        <option value="@option.Value">@option.Text</option>
    }
</select>

@code {
    private List<Option> options;
    private string selectedOption;

    protected override void OnInitialized()
    {
        // 建立与SQL Server的连接
        using (var connection = new SqlConnection("your_connection_string"))
        {
            // 执行SQL查询并获取数据
            connection.Open();
            var command = new SqlCommand("SELECT Value, Text FROM Options", connection);
            var reader = command.ExecuteReader();

            // 将结果集转换为数据结构
            options = new List<Option>();
            while (reader.Read())
            {
                options.Add(new Option
                {
                    Value = reader.GetString(0),
                    Text = reader.GetString(1)
                });
            }
        }
    }

    public class Option
    {
        public string Value { get; set; }
        public string Text { get; set; }
    }
}