从radiobuttonlist提取text解决办法

从radiobuttonlist提取text
 if (!IsPostBack)
        {
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = "server = (local);password = 123;uid = sa;database = keshe";
            cn.Open();
            SqlDataAdapter adp = new SqlDataAdapter("select * from 房屋表 ", cn);
            DataSet ds = new DataSet();
            adp.Fill(ds, "房屋表");
            RadioButtonList1.DataSource = ds.Tables["房屋表"];
            RadioButtonList1.DataTextField = "出租价格";
            RadioButtonList1.DataBind();
            for (int i = 0; i <= RadioButtonList1.Items.Count - 1; i++)
            {
                if (RadioButtonList1.Items[i].Selected)
                {
                    Label2.Text = RadioButtonList1.Items[i].Value;
                }
            }

            string s = "select * from 房屋表 where 出租价格 = '" + Label2.Text + "'";
            SqlDataAdapter da = new SqlDataAdapter(s, cn);
            DataSet ds_1 = new DataSet();
            da.Fill(ds_1, "房屋表");
            GridView1.DataSource = ds_1.Tables["房屋表"];
            GridView1.DataBind();

            cn.Close();
        }
[解决办法]
给radiobuttonlist加SelectedIndexChanged会吧！！ 然后在设置AutoPostBack设置为true
会吧
在
protected void RadioButtonListID_SelectedIndexChanged(object sender, EventArgs e)
{
   //自己定义cn
   string s = "select * from 房屋表 where 出租价格 = '" + RadioButtonList1.SelectedValue + "'";
            SqlDataAdapter da = new SqlDataAdapter(s, cn);
            DataSet ds_1 = new DataSet();
            da.Fill(ds_1, "房屋表");
            GridView1.DataSource = ds_1.Tables["房屋表"];
            GridView1.DataBind();
}
[解决办法]
http://www.cnblogs.com/LifeKingcn/archive/2012/12/19/2825120.html