function AdodbCcn_2DuanTS() Set cnn_2DuanTS = New ADODB.Connection
strDSN_2DuanTS = "Provider=SQLOLEDB;Data Source=lxz;Initial Catalog=oiltalimu; User ID=SUPERMAN;Password='';"
cnn_2DuanTS.Open strDSN_2DuanTS Set rs1_2DuanTS = New ADODB.Recordset
Set rs2_2DuanTS = New ADODB.Recordset
Set rs3_2DuanTS = New ADODB.Recordset
Set rs4_2DuanTS = New ADODB.Recordset
str1_2DuanTS = "select top 12 * from 脱水转油综报1 order by DATATIME DESC"
str2_2DuanTS = "select top 12 * from 脱水转油综报2_1 order by DATATIME DESC"
str3_2DuanTS = "select top 12 * from 脱水转油综报2_2 order by DATATIME DESC"
str4_2DuanTS = "select top 12 * from 脱水转油综报3 order by DATATIME DESC"
rs1_2DuanTS.Open str1_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs2_2DuanTS.Open str2_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs3_2DuanTS.Open str3_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs4_2DuanTS.Open str4_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
nn_2DuanTS = rs2_2DuanTS!DataTime
tt1 = GetTime(nn_2DuanTS)
tt2 = SysTime()
/////////
= rs3_2DuanTS!VIR102
= rs3_2DuanTS!VIR103
= rs3_2DuanTS!VIR104
= rs3_2DuanTS!VIR105
= rs1_2DuanTS!TIR133
= rs4_2DuanTS!PIR138
= rs2_2DuanTS!LIR118
= rs2_2DuanTS!LIR119
= rs2_2DuanTS!rs2_2DuanTS.Close
///////////
rs3_2DuanTS.Close
rs4_2DuanTS.Close
End function
想返回斜线部分中的记录集中的字段值
函数应该怎么写呢?
谢谢
strDSN_2DuanTS = "Provider=SQLOLEDB;Data Source=lxz;Initial Catalog=oiltalimu; User ID=SUPERMAN;Password='';"
cnn_2DuanTS.Open strDSN_2DuanTS Set rs1_2DuanTS = New ADODB.Recordset
Set rs2_2DuanTS = New ADODB.Recordset
Set rs3_2DuanTS = New ADODB.Recordset
Set rs4_2DuanTS = New ADODB.Recordset
str1_2DuanTS = "select top 12 * from 脱水转油综报1 order by DATATIME DESC"
str2_2DuanTS = "select top 12 * from 脱水转油综报2_1 order by DATATIME DESC"
str3_2DuanTS = "select top 12 * from 脱水转油综报2_2 order by DATATIME DESC"
str4_2DuanTS = "select top 12 * from 脱水转油综报3 order by DATATIME DESC"
rs1_2DuanTS.Open str1_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs2_2DuanTS.Open str2_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs3_2DuanTS.Open str3_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
rs4_2DuanTS.Open str4_2DuanTS, cnn_2DuanTS, adOpenKeyset, adLockOptimistic, adCmdText
nn_2DuanTS = rs2_2DuanTS!DataTime
tt1 = GetTime(nn_2DuanTS)
tt2 = SysTime()
/////////
= rs3_2DuanTS!VIR102
= rs3_2DuanTS!VIR103
= rs3_2DuanTS!VIR104
= rs3_2DuanTS!VIR105
= rs1_2DuanTS!TIR133
= rs4_2DuanTS!PIR138
= rs2_2DuanTS!LIR118
= rs2_2DuanTS!LIR119
= rs2_2DuanTS!rs2_2DuanTS.Close
///////////
rs3_2DuanTS.Close
rs4_2DuanTS.Close
End function
想返回斜线部分中的记录集中的字段值
函数应该怎么写呢?
谢谢
解决方案 »
- 怎样将一个已知句柄的窗口设置为当前窗口?
- 如何指定我的程序每隔30分钟运行一次?
- VB如何读取和写入ACCESS数据库的指定行和列的数据
- 各类管理系统(ERP,进销存等等)安装文件、源码、控件 (全部真正的免费)
- 类似触发器的一个小问题
- txt1.setfoucs 错误
- winsock.basVB编写网络程序用到的一段模块
- VB达人请进----送50分
- 再UP一下,我想要请教各位的就是,如何象搜索引擎那样如YAHOO.GOOGLE那样可以任意输入几个关键字,中间用空格间隔,就可以查询出符合条件
- 今天遇见一怪现象:运行VB程序时,Norton AntiVirus弹了出来,说VB6.EXE的File System Object的GetFolder方法是具有恶意的脚本。
- 怎么用vb开发多线程序
- 去面试,没过,郁闷中,三分....
//////////////////////
AdodbCcn_2DuanTS.Add item := rs3_2DuanTS!VIR102, key := "1"
AdodbCcn_2DuanTS.Add item := rs3_2DuanTS!VIR103, key := "2"
......
/////////////////////
如
private type RET_VALUE
str1 as string
str2 as string
......
end typeprivate MyValue as RET_VALUE
private function getvalue() as RET_VALUE dim MyValue as RET_VALUE with MyValue
.str1=rs3_2DuanTS!VIR102
.str2=rs3_2DuanTS!VIR103
......
end with
getvalue=Myvalue
end function
如:dim myvalue2 as RET_VALUE
myvalue2=getvalue
可以这样吗?
2,用,
do while not rs1_2duants.eof() str=rs1_2DuanTS!....
...
rs1_2DuanTS.movenext
loop