Class to handle DB connections

[Simon Harris]

Hi All,

I'm trying to create a class to connect/disconnect a database. Code I have
so far is below, problem is that the closeconn function gives me an error -
Name 'SPDOleDbConnec tion' is not declared.

Also getting the same problem in my code where I want to use the connection
(also shown below)

Would appreciate it if anyone has any ideas - Surely I dont have to repeat
this code everytime I open/close a connection! :)

Regards,
Simon.
Code to open/close connection
=============== =========
Public Class DataBase

Public Function OpenConn() As System.Data.Ole Db.OleDbConnect ion
Dim configurationAp pSettings As
System.Configur ation.AppSettin gsReader = New
System.Configur ation.AppSettin gsReader
Dim SPDOleDbConnect ion As New OleDb.OleDbConn ection
SPDOleDbConnect ion.ConnectionS tring =
CType(configura tionAppSettings .GetValue("OleD bConnection1.Co nnectionString" ,
GetType(System. String)), String)
SPDOleDbConnect ion.Open()
End Function
Public Function CloseConn() As System.Data.Ole Db.OleDbConnect ion
SPDOleDbConnect ion.Close()
End Function

End Class

Code where I want to use the connection
=============== =============== =
Dim myCommand As New System.Data.Ole Db.OleDbCommand ("SELECT Country FROM
Countries WHERE CountryID = " & CountryID, SPDOleDbConnect ion)
Dim myReader As System.Data.Ole Db.OleDbDataRea der =
myCommand.Execu teReader(Comman dBehavior.Close Connection)
While myReader.Read()
Return myReader.GetStr ing(0)
End While
myReader.Close( )