I have a problem with closing the SQLconnection in my application. My application is in VB.net. I have a reference in my application to a class with code to open and close the database connection and to execute all sql scripts.
The error occurs when i close my application. In the formClosing event of my main form I call a function that closes all the connections. But just before I close the connections I perform an SQLquery to delete a row from a table with the function below.
Public Function DeleteFunction(ByVal mySQLQuery As String, ByVal cmd As SqlCommand) As Boolean
Try
cmd.Connection = myConnection
cmd.CommandText = mySQLQuery
cmd.ExecuteNonQuery()
Return True
Catch ex As Exception
WriteErrorMessage("DeleteFunction", ex, Logpath, "SQL Error: " & mySQLQuery)
Return False
End Try
End Function
In my application I check the result of the boolean. If it returns True, then i call the function to close the database connection.
The returned boolean is True and the requested row is deleted in my database. This means i can close my connection which I do with the function below.
Public Sub DatabaseConnClose()
myCommand.CommandText = ""
myConnection.Close()
myCommand = Nothing
myConnection = Nothing
End Sub
After executing this code I receive an error in my logfile from the DeleteFunction. It says: "Connection property has not been initialized."
It seems very strange to receive an error from a function that was completely executed, or am i wrong to think that?
Can anyone tell me why I receive this error and how I can solve the problem?
