读书人

从radiobuttonlist提取text解决办法

发布时间: 2013-12-10 15:05:55 作者: rapoo

从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

读书人网 >C#

热点推荐