Read from database and load the values of radio buttons in asp.net server side

Question

I want my web page to do in this way: when web page loads, all the radio button values should be fetched from database and shown in web page. This is a part of my ".cshtml" code:

<div class="radiobtn">
    <label for="koobideh">select</label>
    <input type="radio" id="koobideh" name="0" value="004" runat="server">
</div>

Here is a part of my ".cs" file:

public void OnGet()
{
    string sql = "SELECT foodId FROM [reservation] WHERE userId = '" + UserId + "'" +
                                         "AND date = '" + date + "'";
    using (SqlCommand command = new SqlCommand(sql, connection))
    {
        SqlDataReader reader = command.ExecuteReader();
        if (reader.Read())
        {
            string foodid = reader.GetString(reader.GetOrdinal("foodId"));
            ???????????????
        } 
        reader.Close();
    }
}

So when the web page is loaded for the first time, the input radios should be fetched from database and loaded in the correct place.

My first try was this:

Request.Form["0"] = reader.GetString(reader.GetOrdinal("foodId"));

But this is impossible since Request.Form is "ReadOnly". How can I do such a thing?

I have the "name" properties of input radios. I want to read the value of each group from database and make the radio as checked in the front side.

use parameterized query to avoid SQL injections

Vivek Nuna
– Vivek Nuna

2023-01-09 12:48:46 +00:00
Commented Jan 9, 2023 at 12:48 — Vivek Nuna
– Vivek Nuna, Commented Jan 9, 2023 at 12:48

hamza · Accepted Answer · 2023-01-09 17:10:32Z

1

This May help. Here is an example of how you can show the chosen radio based on the retrieved value from DataBase.

This is the .cshtml code:

<label>
    <input asp-for="Gender" type="radio" value="male">
    <label for="male">Male</label>
</label>
<label>
    <input asp-for="Gender" type="radio" value="female">
    <label for="female">Female </label>
</label>

in the .cs file

    [BindProperty]
    public string Gender { get; set; }

    public async Task<IActionResult> OnGetAsync()
    {
        Gender = await GetPersonGender(personId);
        return Page();

    }


    //This Method to extract the Gender value of a person from DB.
    private async Task<string> GetPersonGender( string personId)
    {
        string personGender = "";

        using (var connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using var command = new SqlCommand(
                "SELECT * FROM Persons WHERE PersonId = @id", connection);
            
            command.Parameters.AddWithValue("@id", personId);
            using var reader = command.ExecuteReader();
                
            if (reader.Read())
            {
                personGender = reader["Gender"].ToString();
            }
                
            
        }
        return personGender;

    }

answered Jan 9, 2023 at 17:10

hamza

1591 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nastaran Over a year ago

Thanks for your attention. It doesn't load the Gender value to the radio buttons on the page.

hamza Over a year ago

it will not if you are just copying the code, because that require a table named Person and a Column named PersonId and another Column Named Gender. so, you should configure your database first if you want to use the code above. or just replace the await GetPersonGender(personId); with "male" and sometimes with "female'. @Nastaran

Nastaran Over a year ago

I was wrong in some lines. Finally it works. Thank you so much.

Collectives™ on Stack Overflow

Read from database and load the values of radio buttons in asp.net server side

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related