如何将数据库列值绑定到radiobuttonlist

问题描述

请告诉我如何将所有列值绑定到数据库中的radiobuttonlist，就像我在4列数据库表中有4个选项一样。我想阅读选项列到radiobuttonlist选择。我有代码，但有错误，它只读取第一列值到单选按钮列表，但我需要访问所有列值，如列ABCDE ro radiobuttonlist。请给我解决方案.....

pls some one tell that how to bind all column value to radiobuttonlist from database like i have 4 options in 4 columns of database table. i want to read option column to radiobuttonlist to selection. i have code but there is error it reads only 1st column value to radio button list but i need to access all column value like column ABCDE ro radiobuttonlist. pls give me solution.....

SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            //cmd.CommandText = "select id,Questions,A,B,C,D from Question where Id='" + t + "'";
            cmd.CommandText = "select id,Questions,A,B,C,D from Question";
            //cmd.Parameters.Add("@Id", SqlDbType.Float).Value = t;

            string uid = "";
            string Questions = "";
            string A = "";
            string B = "";
            string C = "";
            string D = "";

            cmd.Connection.Open();
            SqlDataReader rdr = cmd.ExecuteReader();

            if (rdr.HasRows)
            {
                //PanUpdate.Visible = true;
                //PanDisplay.Visible = false;

                while (rdr.Read())
                {
                    uid = rdr["Id"].ToString();
                    Questions = rdr["Questions"].ToString();
                    A = rdr["A"].ToString();
                    B = rdr["B"].ToString();
                    C = rdr["C"].ToString();
                    D = rdr["D"].ToString();
                }
                rdr.Close();
                rdr = cmd.ExecuteReader();

                //rdr.Close();
                //RadioButton1.DataBind = A;

                //RadioButton1.DataTextField = "Role_Name";
                //RadioButton1.DataSource = "Role_Name";
                //RadioButton3.DataTextField = "Role_Name";
                //RadioButton4.DataTextField = "Role_Name";
                //RadioButton5.DataTextField = "Role_Name";

                RadioButtonList1.DataSource = A;
                //RadioButtonList1.DataTextField = A;
                //RadioButtonList1.DataValueField = A;
                RadioButtonList1.DataBind();
                //LblUserID.Text = uid;
                //TxtPwdChange.Text = pwd;
                //LbxRole.Items.FindByText(rol).Selected = true;

                cmd.Connection.Close();

pls some one tell ........

pls some one tell........

推荐答案

ListItem li = new ListItem();
li.Text = A;
li.Value = A;
RadioButtonList1.Items.Add(li);  

或

or

DataTable table = new DataTable();
while (rdr.Read())
{

table.Columns.Add("Option", typeof(string));
if(A!="")
table.Rows.Add(A);
if(B!="")
table.Rows.Add(B);
if(C!="")
table.Rows.Add(C);
if(D!="")
table.Rows.Add(D);
}
RadioButtonList1.DataTextField = "Option"
RadioButtonList1.DataValueField = "Option"
RadioButtonList1.DataSource = table;
RadioButtonList1.DataBind();

RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("RadioButtonList1");
             HiddenField hdn = (HiddenField)e.Item.FindControl("hf1");
             SqlDataAdapter ds = new SqlDataAdapter("select * from Question where QuestionId='" + hdn.Value + "'", con);
             DataTable ds1 = new DataTable();
             ds.Fill(ds1);
             RadioButtonList1.Items.Clear();
             RadioButtonList1.Items.Add(ds1.Rows[0]["OptionA"].ToString());
             RadioButtonList1.Items.Add(ds1.Rows[0]["OptionB"].ToString());
             RadioButtonList1.Items.Add(ds1.Rows[0]["OptionC"].ToString());
             RadioButtonList1.Items.Add(ds1.Rows[0]["OptionD"].ToString());
             RadioButtonList1.DataBind();

这篇关于如何将数据库列值绑定到radiobuttonlist的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！