
sqlconnection 连接数的问题请教?基本问题请教?
我在公共类中定义了连接数据库函数.代码如下:PublicFunctionOpenConnect()AsSqlConnectionTryDimconnectionStrin...
我在公共类中定义了连接数据库函数.
代码如下:
Public Function OpenConnect() As SqlConnection
Try
Dim connectionString As String = _
"Persist Security Info=False;User ID=test;Password=test;Initial Catalog=test;Data Source=" & DataServer & ";"
Dim Connect As New SqlConnection(connectionString)
If Connect.State <> ConnectionState.Open Then
Connect.Open()
End If
Return Connect
Catch ex As Exception
MsgBox("Can't connect to the dataserver!", MsgBoxStyle.Critical, "Wrong")
End Try
Return Nothing
End Function
我是打开连接后,我又用conn.Dispose() 释放连接啦..
我直接用OpenConnect.Dispose()释放也试过.
但我在数据库后台查询的时候,sql server 2008 显示我的程序还有两个连接连在数据库上? 展开
代码如下:
Public Function OpenConnect() As SqlConnection
Try
Dim connectionString As String = _
"Persist Security Info=False;User ID=test;Password=test;Initial Catalog=test;Data Source=" & DataServer & ";"
Dim Connect As New SqlConnection(connectionString)
If Connect.State <> ConnectionState.Open Then
Connect.Open()
End If
Return Connect
Catch ex As Exception
MsgBox("Can't connect to the dataserver!", MsgBoxStyle.Critical, "Wrong")
End Try
Return Nothing
End Function
我是打开连接后,我又用conn.Dispose() 释放连接啦..
我直接用OpenConnect.Dispose()释放也试过.
但我在数据库后台查询的时候,sql server 2008 显示我的程序还有两个连接连在数据库上? 展开
1个回答
展开全部
建议你试试Cmd.Connection.close,你的conn和Cmd.Connection已经分离了!
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询