关于问题2。我是在form_load中设
adodc.recordsource="select * from table"
然后我想再次查询,sql语句为"select count(A),sum(B) from table
where X=X group by C",但msHflexgrid不能显示(或者是adodc出错?)
另不能用“with club"这种sql语法。。。。。。
Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
' 步骤 1,创建一个数据连接
conn.Open "DSN=pubs;uid=sa;pwd=;database=pubs"
' 步骤 2,设置数据命令
Set cmd.ActiveConnection = conn
cmd.CommandText = "SELECT * from authors"
' 步骤 3,打开数据
rs.CursorLocation = adUseClient
rs.Open cmd, , adOpenStatic, adLockBatchOptimistic