asp.net链接AS400数据库,gridview绑定不到数据源

Question

gridview要绑定表A，A中有一列名为"unit$"，我试过select unit$ from A 、select [unit$] from A 和select [unit$] as unit from A都返回NULL，用select * from A的话则绑定不到列unit$。麻烦的是我又不能修改unit$这个列名，求教大家我该怎么办。另外我发现在jsp里执行select unit$ from A是能返回数据集的，但跑asp.net里却返回null

Answer 1

尝试：

select [unit$] As Unit from A

不过我很奇怪，你的数据表列名为啥可以用特殊符号……

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 2

试过不行。我也不知道为啥可以用特殊符号，都是别人老早就建好的。还有有些列名带#，不过不会影响我写代码

Answer 3

截图看看是什么样子的数据库。

你直接用SqlDataSource（默认根据向导窗口配置）也不行吗？

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats