关于VB6 没有用过,怎样在多个方法中共用一个 conn对向,是否可以初始化的时候先定义一下conn ?
Option ExplicitPrivate Context As ScriptingContext
Private Application As Application
Private Response As Response
Private Request As Request
Private Session As Session
Private Server As Server
Dim SUM As SinglePublic Sub OnStartPage(PassedscriptContext As ScriptingContext)
Set Context = PassedscriptContext
Set Application = Context.Application
Set Request = Context.Request
Set Response = Context.Response
Set Server = Context.Server
Set Session = Context.Session
SUM = 3
End Sub
Private Function RiskLoopNum(connstr)
Dim sql As String
Dim rsLoop, conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open (connstr)
sql = "select count(*) as total from [RiskFactors] where ParentID=0"
Set rsLoop = conn.Execute(sql)
RiskLoopNum = Int(rsLoop("total") - 1)
rsLoop.Close
Set rsLoop = Nothing
conn.Close
Set conn = Nothing
End Function
Public Sub showsuc(connstr)
Dim rs, conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open (connstr)
Set rs = conn.Execute("Select * from [armUser]")
Do While Not rs.EOF
Response.Write (rs("Username"))
rs.movenext
Loop
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
End Sub
' 释放内部对象
Public Sub OnEndPage()
Set Application = Nothing
Set Request = Nothing
Set Response = Nothing
Set Server = Nothing
Set Session = Nothing
Set Context = Nothing
End Sub
Option ExplicitPrivate Context As ScriptingContext
Private Application As Application
Private Response As Response
Private Request As Request
Private Session As Session
Private Server As Server
Dim SUM As SinglePublic Sub OnStartPage(PassedscriptContext As ScriptingContext)
Set Context = PassedscriptContext
Set Application = Context.Application
Set Request = Context.Request
Set Response = Context.Response
Set Server = Context.Server
Set Session = Context.Session
SUM = 3
End Sub
Private Function RiskLoopNum(connstr)
Dim sql As String
Dim rsLoop, conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open (connstr)
sql = "select count(*) as total from [RiskFactors] where ParentID=0"
Set rsLoop = conn.Execute(sql)
RiskLoopNum = Int(rsLoop("total") - 1)
rsLoop.Close
Set rsLoop = Nothing
conn.Close
Set conn = Nothing
End Function
Public Sub showsuc(connstr)
Dim rs, conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open (connstr)
Set rs = conn.Execute("Select * from [armUser]")
Do While Not rs.EOF
Response.Write (rs("Username"))
rs.movenext
Loop
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
End Sub
' 释放内部对象
Public Sub OnEndPage()
Set Application = Nothing
Set Request = Nothing
Set Response = Nothing
Set Server = Nothing
Set Session = Nothing
Set Context = Nothing
End Sub
解决方案 »
- GDI+绘制文字的问题
- 怎么让DataGrid在不执行命令的时候不显示数据库中的内容啊??
- 是否可以在VB里调用CMD
- %%%% 估计会的人不多,但是我保证如果解决给300分 ¥¥¥¥¥¥¥
- 怎样在代码中控制控件“移至顶层”或者“移至底层”???
- vb开发环境下运行正常,编译成。exe文件后执行出现实时错误126是怎么回事?
- DataGrid显示更新的数据后,一点击或拖动显示的数据就不见了,困惑啊,求助
- 如何让VB编写的.EXE在没装VB的机器上运行,
- 关于ASCII码的问题?PAGEUP和PAGEDOWN的码是多少?
- 急急,关于VB调用VC的DLL问题
- 楼主修改自己的帖子好像不允许了 是么
- Run-time error'429'
private conn as ???
老大给个代码给我看下吧?