我的代码如下: select aa.id as a1, aa.name as a2,bb.id as b1,bb.style as b2 from table1 aa,table2 bb where aa.id=bb.id 这段代码在SQL里执行就设有问题 但是在程序中执行就提示"列名“style”无效"
马虎!不可能的,检查你web.config里面的连接字符串是不是跟查询分析器连的是同一个数据库!
把你的datagrid的style列名改为b2
select aa.id as a1, aa.name as a2,bb.id as b1,[bb.style] as b2 from table1 aa,table2 bb where aa.id=bb.id
to vzxq: style中列名
select aa.id as a1, aa.name as a2,bb.id as b1,[bb.style] as b2 from table1 aa,table2 bb where aa.id=bb.id 改成这个以后又说"列名[bb.style]无效"
select aa.id as a1, aa.name as a2,bb.id as b1,bb.style as b2 from table1 aa,table2 bb where aa.id=bb.id
这段代码在SQL里执行就设有问题
但是在程序中执行就提示"列名“style”无效"
style中列名
改成这个以后又说"列名[bb.style]无效"
你说的是绑定的时候吧我已经设了
datafield="b2"