求gridview绑定问题

miosoul

如果你的audioId段是Key鍵，那就可以寫一條SQL語句完成啊。
strSQL = "select A.字段,A.字段,...,count(B.audioId) as commcount from A inner join B on A.audioId = b.audioId where A.UserId = " + uid + " Group by A.字段,A,字段,...,"

白饭米粉

你的count(B.*)

这个，，出错，，所以0就不显示，，也就是只显示“真”值

miosoul

count(B.*)改為count(B.audioId)

白饭米粉

count(B.*)改為count(B.audioId)


我昨天下午试了，，不显示，，我的ID也是主键啊，，

白饭米粉

miosoul   

           strSQL = "select A.字段,A.字段,...,isnull((count(B.audioId) as commcount),0) from A inner join B on A.audioId = b.audioId where A.UserId = " + uid + " Group by A.字段,A,字段,...,"



这种写法行吗，，

我用查询分析器试了下，，AS有错，，不加AS能正常运行

白饭米粉

isnull(count(B.audioId) ，0)as aa,,

这个怎么也不显示，郁闷

白饭米粉

呵呵，搞定，，累啊，，

谢谢

miosoul  的指点

俺用的方法是：


strSQL = "select A.字段,A.字段,...,isnull(count(B.audioId) ，0)as aa from A FULL OUTER join B on A.audioId = b.audioId where A.UserId = " + uid + " Group by A.字段,A,字段,...,"