radiobutton list only store null value in database

Garima Bansal

3y1kASP.NET

I am using radiobutton list with 3 list item, after select one list item its only take null value in database

Style="font-weight: 700" >
ls1
ls2
ls3

cmd.Parameters.AddWithValue("@FarmerType", rdltype.SelectedItem.Text);

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago
Accepted answer
Have you manually added the hardcoded value? It seems incorrect it should be like this (If radiobutton is not binding from code behind)
```
    
    
    
    
```
```
var selectedValue=rdltype.SelectedValue;
```
To get text instead,
```
var selectedValue=rdlType.SelectedItem.Text;
```
+3
Rajeesh Menoth3y ago
Hi,

You need to validate the following steps in your code.

1. Make sure what radio button value you are getting it before storing in the database. If you are getting the value in the backend code before storing it, then the issue is related to your database code.

2. Kindly refer to the following article - https://www.c-sharpcorner.com/UploadFile/009464/save-selected-data-of-radio-button-list-in-Asp-Net/
+2

Sachin Singh3y ago

Do this

var selectedValue = Convert.ToString(rdltype.SelectedItem.Text);
      SqlCommand cmd= new SqlCommand("insert into yourTable(Type,..othercolumnnames) values(@Type,...othercolumnvaalues)");
cmd.Parameters.AddWithValue("@Type", selectedValue);
cmd.ExecuteNonQuery();

and make sure , in database the Type column is Varchar(150)

Garima Bansal3y ago
Sachin Singh

i am using this way but still store null value in database

Style="font-weight: 700" >

var selectedValue = rdltype.SelectedItem.Text;
cmd.Parameters.AddWithValue("@Type", selectedValue);
+2