我用Foxtable自带的示例文件『多表统计』，测试有问题的：
1.报不存在为""Datable的
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.Connection Name = "Sale"
cmd.CommandText = "select 客户ID,sum(数量) as 数量 from{订单} group by 客户ID"
dt = cmd.ExecuteReader()
For Each dr As DataRow In Dt.DataRows
dr("数量") = dr("数量") +100
Next
Tables("窗口1_Table1").DataSource = dt '放于最后报错!
2.不报错的
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.Connection Name = "Sale"
cmd.CommandText = "select 客户ID,sum(数量) as 数量 from{订单} group by 客户ID"
dt = cmd.ExecuteReader()
Tables("窗口1_Table1").DataSource = dt
For Each dr As DataRow In Dt.DataRows
dr("数量") = dr("数量") +100
Next
另cmd.Connection Name 区分大小写吗?如写作cmd.Connection Name = "sale"就不行!
加好友 
发短信
Post By：2011/5/27 9:10:00 [显示全部帖子]
