Question

sqlconnection 连接数的问题请教？基本问题请教?

我在公共类中定义了连接数据库函数.
代码如下:
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 显示我的程序还有两个连接连在数据库上？

Answer 1

建议你试试Cmd.Connection.close，你的conn和Cmd.Connection已经分离了！