1:
oraStr = "select count as ct from result "
oraRec.CursorLocation = adUseClient
oraRec.Open oraStr, oraconn ,adOpenStatic '可以直接用oraRec.RecordCount得到count
'或orarec.Fields(0).Value 得到count2:最好将该变量定义在Modules中,且为public,这样就可以直接使用了
oraStr = "select count as ct from result "
oraRec.CursorLocation = adUseClient
oraRec.Open oraStr, oraconn ,adOpenStatic '可以直接用oraRec.RecordCount得到count
'或orarec.Fields(0).Value 得到count2:最好将该变量定义在Modules中,且为public,这样就可以直接使用了
oraStr = "select count(*) from result "
oraRec.CursorLocation = adUseClient
oraRec.Open oraStr, oraconn,adOpenStatic 用orarec.Fields(0) 得到记录数2:最好将该变量定义在Modules中,且为public,这样就可以直接使用了
还可以这样,就是引用窗体:
如你在Form1中定义:
Public strC as string
在Form2中可以这样引用
Form1.strC