7of9121098
asked on
Idisposable interface and the using statement in SQL
I'm having problem finding a good Vb.net example that shows how to dispose a sql connection via the idisposable interface. Also with the 'using' statement. Does anyone have a good small example using both of these keywords?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ah...I was only thinking about .NET 1.1
I amwrong in VB.NET 2.0 you can use Using
http://pluralsight.com/blogs/fritz/archive/2005/04/28/7834.aspx
I amwrong in VB.NET 2.0 you can use Using
http://pluralsight.com/blogs/fritz/archive/2005/04/28/7834.aspx
Here is a way to get Using working in VB.NET 1.1
Dim conn As SqlConnection = New SqlConnection(dsn)
Try
Dim cmd As SqlCommand = New SqlCommand("SELECT * FROM Employees", conn)
Try
conn.Open()
rdr = cmd.ExecuteReader()
While rdr.Read()
Console.WriteLine(rdr(0))
End While
Finally
If Not cmd is Nothing Then
cmd.Dispose()
End If
End Try
Finally
If Not conn is Nothing Then
conn.Dispose()
End If
End Try
Hope this Helps
Darren
Dim conn As SqlConnection = New SqlConnection(dsn)
Try
Dim cmd As SqlCommand = New SqlCommand("SELECT * FROM Employees", conn)
Try
conn.Open()
rdr = cmd.ExecuteReader()
While rdr.Read()
Console.WriteLine(rdr(0))
End While
Finally
If Not cmd is Nothing Then
cmd.Dispose()
End If
End Try
Finally
If Not conn is Nothing Then
conn.Dispose()
End If
End Try
Hope this Helps
Darren
As far as I know you cannot use the 'using' statement in VB.NET only C#
Darren