adodc1.rcordsource = "select sum(count1) from pffinmn"n = adodc1.recordset.fields(0)
1、设置Adodc的连接字符串: 如:Adodc3.ConnectionString = "Provider = SQLOLEDB.1;Password = ; Persist Security Info = True;User ID = sa;Initial Catalog = DRUGDB; Data Source = 192.168.30.122" 2、设置记录源: Adodc1.RecordSource ="select sum(count1) as Total from pffinmn" 3、得到记录的合计值: 如:TotalValue=adodc1.recordset.fields(0)
数据库连接最好不要使用数据库件去连接,很笨的 dim adoCn as adodb.connection dim adoRS as adodb.recordset dim strSql as string strSql="select * from table " adoCn.connectongstring="sddssddssdds" adoCn.open set adoRs=new adodb.recordset set adoRs=adoCn.ExcutadoRs!字段 就是所需要的记录
如:Adodc3.ConnectionString = "Provider = SQLOLEDB.1;Password = ; Persist Security Info = True;User ID = sa;Initial Catalog = DRUGDB; Data Source = 192.168.30.122"
2、设置记录源:
Adodc1.RecordSource ="select sum(count1) as Total from pffinmn"
3、得到记录的合计值:
如:TotalValue=adodc1.recordset.fields(0)
dim adoCn as adodb.connection
dim adoRS as adodb.recordset
dim strSql as string
strSql="select * from table "
adoCn.connectongstring="sddssddssdds"
adoCn.open
set adoRs=new adodb.recordset
set adoRs=adoCn.ExcutadoRs!字段
就是所需要的记录