CODEWITHSUNDEEP
vb.netms-access
Ishti
Ishti

Reputation: 7

How to close database connection?

I'm having a problem in project of mine in VB.NET. The problem is whenever I want to save, delete or update data with an Access database I get an error with a message saying that "not allowed to change the connection string property. connection's current state is open".

I have used If con.State = ConnectionState.Open Then con.Close() End If command using finally in every section where I have called the database.

But still I'm having the same problem. What am I doing wrong?

Upvotes: 0

Views: 2043

Answers (1)

battleboimatze
battleboimatze

Reputation: 73

Use the "USING"-Keyword. Exiting a using block calls .Dispose() on the object which for a SqlConnection will close the connection and any open resources.

Using connection As New SqlConnection(connection)

Dim command As New SqlCommand("Select * From dbo.table1",connection)

command.ExecuteNonQuery()

End Using

EDIT:

Module Module1

Public Sub DbConnection()

Dim connectionString as String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourServerAddress;Initial Catalog=university.mdb;
Integrated Security=SSPI;"

Using connection as New Sqlconnection(connectionstring)

Dim command As New SqlCommand("Select * From dbo.table1",connection)

command.ExecuteNonQuery()

End Using

End Sub

End Module

Upvotes: 1

Related Questions