dataRead出来的值能否给一个变量？？？？

[jieyi1106]

conCity.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{

string area = dr["areaId"].ToString();

}
string sql_city = "select * from tb_uAdvise where areaID = '"+area+"' ";
SqlCommand cmd_city = new SqlCommand(sql_city, conCity);

//数据绑定GV；

这里报错说 上下文找不到 area 是不是 read出来 不能给变量？

小弟菜

[Fibona]

conCity.Open();
SqlDataReader dr = cmd.ExecuteReader();
string area=""; //在外面定义,里面定义变量的作用域就是在里面,当然外面用不了

if (dr.Read())
{

area = dr["areaId"].ToString();

}
string sql_city = "select * from tb_uAdvise where areaID = '"+area+"' ";
SqlCommand cmd_city = new SqlCommand(sql_city, conCity);

[孤独侠客123]

conCity.Open();

SqlDataReader dr = cmd.ExecuteReader();
string area = "";
if (dr.Read())
{

area = dr["areaId"].ToString();

}
string sql_city = "select * from tb_uAdvise where areaID = '"+area+"' ";
SqlCommand cmd_city = new SqlCommand(sql_city, conCity);

//数据绑定GV；


作用域,area只在if里面

[jieyi1106]

搞定，谢谢1，2楼