checkbox问题

[shaqing_0928]

我有一个存储过程，其中有一个sql语句为：
select t.*,case when (EXISTS(SELECT * FROM planadmin where
planadmin.file_mark not in ('xx')and t.city_name=planadmin.city_name and t.country_name=planadmin.county_name and planadmin.construct_spot like '%'+substring(t.F6,0,8)+'%'and t.F7 is not null))
then 1 else 0 end as keyid FROM t
其中keyid用于控制gridview中的一个checkbox1，判断是否checked，我现在在同样的gridview中加入一列checkbox2，只是用planadmin.watersupply_population > t.F7条件来判断checkbox2，应该怎么修改上面的sql语句或应该怎么做，望指教

[tianshangfei]

友情up

[tian_fang]

说明白些啊，你select t.*,case when
(EXISTS(SELECT * FROM planadmin where
planadmin.file_mark not in ('xx')
and t.city_name=planadmin.city_name
and t.country_name=planadmin.county_name
and planadmin.construct_spot like '%'+substring(t.F6,0,8)+'%'and t.F7 is not null))
then 1 else 0 end as keyid FROM t 有这么多的条件，控制checkbox2只有planadmin.watersupply_population > t.F7一个条件？

[shaqing_0928]

我的意思是

select t.*,case when
(EXISTS(SELECT * FROM planadmin where
planadmin.file_mark not in ('xx') and planadmin.watersupply_population > t.F7 FROM t

应怎样把这两句整合到一起，通过判断两个条件，控制2个不同的checkbox

[tian_fang]

..........那加个and连起来呢？..............

[shaqing_0928]

不能加and，加了and条件就多了，而且就只能控制一个checkbox1了，2个条件控制2个checkbox

[tian_fang]

............

[ljhcy99]

select t.*,
case when (
EXISTS(SELECT * FROM
----你这个 查询语句where里面怎么没有t表呢
planadmin,t where
planadmin.file_mark not in ('xx')
and t.city_name=planadmin.city_name
and t.country_name=planadmin.county_name
and planadmin.construct_spot like '%'+substring(t.F6,0,8)+'%'
and t.F7 is not null)
)
then 1 else 0 end as keyid,
-----用keyid2控制另一个复选框
case when (
EXISTS(SELECT * FROM
planadmin,t
where planadmin.file_mark not in ('xx') and
planadmin.watersupply_population > t.F7)
)
then 1 else 0 end as keyid2, FROM t

[shaqing_0928]

我也这么做了，可是在页面中说找不到keyid2,这是怎么回事？？？
<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.keyid2").ToString()=="0"?false:true %>' Enabled="False" />
这样写会报错，应该怎么改呢