databind in radiobutton in asp.net data not shown in radiobuttonlist

Question

User-717550176 posted

private void yrs()
{
DataSet sid = new DataSet();
string aise = "select distinct yearr from programe where course='" + ddcorese.SelectedItem.Text.ToString() + "'";
sid = mvl.GETDS(aise);
ListItem liq = new ListItem();
liq.Value = "--Select--";
r1.Items.Add(liq.ToString());
r1.DataSource = sid;
r1.DataTextField = "yearr";
r1.DataBind();
}

<asp:RadioButtonList ID="r1" runat="server" AutoPostBack="True" RepeatColumns="3" RepeatDirection="Horizontal">
</asp:RadioButtonList>

Answer 1

User1535942433 posted

Hi sriram342019,

Accroding to your codes,I suggest you could debug and check if the sid value is null.

Could you tell us what is ddcorese and  mvl.GETDS()?

Since you don't post more codes to us,I create a demo which when I select the dropdownlist,the radiobuttonlist will show the data from database.

More detail,you could refer to below codes:

 <asp:RadioButtonList ID="r1" runat="server" AutoPostBack="True" RepeatColumns="3" RepeatDirection="Horizontal">
</asp:RadioButtonList>
            <asp:DropDownList ID="DropDownList1" runat="server">
                <asp:ListItem Value="1" Text="1"></asp:ListItem>
                <asp:ListItem Value="2" Text="2"></asp:ListItem>
            </asp:DropDownList>

Code-behind:

 protected void Page_Load(object sender, EventArgs e)
        {
            string str, strSql;
            str = System.Configuration.ConfigurationManager.ConnectionStrings["aspnet-TestApplicationWithDatabase-20190820030542"].ConnectionString;
            SqlConnection conn = new SqlConnection(str);
            strSql = "select * from Sum where Year='" + DropDownList1.SelectedItem.Value.ToString()+ "'";
            SqlDataAdapter da = new SqlDataAdapter(strSql, str);
            DataSet ds = new DataSet();
            da.Fill(ds, "Sum");
           
            ListItem liq = new ListItem();
            liq.Value = "--Select--";
            r1.Items.Add(liq.ToString());
            r1.DataSource = ds;
            r1.DataTextField = "Id";
            r1.DataBind();
        }

If you have problems,you could post your full codes to us.It will help us to solve your problems.

Best regards,

Yijing Sun