Question

c# gridview中的RadioButtonList要怎么绑定数据源啊？ 在线等~

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%" >
<Columns>···
<ItemTemplate>···
<asp:RadioButtonList ID="danxuan" runat="server" AutoPostBack="True" RepeatDirection="Horizontal"
Visible="False" Width="178%">
</ItemTemplate>···
是要绑定vot_op表里的op_id、op_name到RadioButtonList的DataValueField、DataTextField
我刚开始学，请大家帮忙啊~
linv2：sda.SelectCommand.Connection = con ;这句话报错了，“System.NullReferenceException: 未将对象引用设置到对象的实例。
”。我写的是：
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db"].ConnectionString);
con.Open();
string strsql = null;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand.Connection = con ;
sda.SelectCommand.CommandText = strsql;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
RadioButtonList radlist = (RadioButtonList)GridView1.Rows[i].FindControl("danxuan");
DataTable tbl = new DataTable();
strsql = "SELECT * from [vot_op] where op_type='单选'and t_id='" + int.Parse(Session["t_id"].ToString()) + "'";
sda.Fill(tbl);
···
con这样写其他的控件也能连上啊 这里问题出在哪里了？

Answer 1

RadioButtonList 在GridView1里边
你确定不是RadioButton?????
----------------------------------------------

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
SqlConnection mycon = new SqlConnection("数据库连接字符串");
string strsql=null;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand.Connection = mycon;
sda.SelectCommand.CommandText = strsql;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
RadioButtonList radlist = (RadioButtonList)GridView1.Rows[i].FindControl("RadioButtonList1");
DataTable tbl = new DataTable();
strsql = "SQL语句";
sda.Fill(tbl);
radlist.DataSource = tbl;
radlist.DataBind();
radlist.DataTextField = "op_name";
radlist.DataValueField = "op_id";
}
}

Answer 2

写个存储过程把那个表里的两列选出来然后会得到一个DataTable
写个方法把DataTable实例出来
这时候你可以写个for循环让RadioButtonList.DataValueField=DataTable第0列的数据也就是op_id
DataTextField 也是一样
当然这个过程是写在GridView RowDataBound里