Hi,
I have created a database class as follows

Class DBase{
Private strConnection_String As String
Private command As System.Data.SqlClient.SqlCommand
Private recordset As System.Data.SqlClient.SqlReader
Public New()
{
connect.ConnectionString= //path to database
}
Public setSQLCommand(ByVal comm As System.Data.SqlClient.SqlCommand)
{
//assign argument that already has its CommandText filled with sql statement
// assign to instance variable
command = comm
command.Connection = connect
}

Public Function executeStatement() As System.Data.SqlClient.SqlReader
{
if connect.State().ToString().Equals("Open")
{

recordset = command.ExecuteReader()
}
else
{
connect.Open()
recordset = command.ExecuteReader()
}//end of else

return recordset
}
Public closeDB()
{

connect.Close()
}
}//end of class

in the class the utilizes this class, i create an object of this class read values from the database, but when I attempt to reuse the connection I get an error that informs me the connection is already in use by another sqlreader and in order to use my database connectivity class again, I would have to close it off. I have tried to close of the sqlreader that I used at the start and even attempted to close off the connection and create an new one, but I still get that error, is there something I could do to prevent it from occurring?
Thanks Bob