将预填充值传递到SQL Server数据库表(使用Blazor)

@page "/insert-data"
@inject Microsoft.Extensions.Configuration.IConfiguration Configuration

<h3>Insert Data</h3>

<form>
    <div class="form-group">
        <label for="name">Name:</label>
        <input type="text" class="form-control" id="name" @bind="@Name" />
    </div>
    <div class="form-group">
        <label for="age">Age:</label>
        <input type="number" class="form-control" id="age" @bind="@Age" />
    </div>
    <button type="button" class="btn btn-primary" @onclick="InsertData">Insert</button>
</form>

@code {
    private string Name { get; set; }
    private int Age { get; set; }

    private void InsertData()
    {
        var connectionString = Configuration.GetConnectionString("DefaultConnection");
        using (var connection = new SqlConnection(connectionString))
        {
            connection.Open();

            var sql = "INSERT INTO Users (Name, Age) VALUES (@Name, @Age)";
            using (var command = new SqlCommand(sql, connection))
            {
                command.Parameters.AddWithValue("@Name", Name);
                command.Parameters.AddWithValue("@Age", Age);

                command.ExecuteNonQuery();
            }
        }
    }
}