All the "Using" block does is takes care of releasing any resources that your object may have been using. So doing this:Only reason I did it that way is because that's how jmcilhinney's thread did it, and I'm not nearly experienced enough to "see" other ways of doing it...
is the same as doing this:vb Code:
Using connection As New OleDbConnection("etc etc") 'use the connection object here '.... End Using
vb Code:
Dim connection As New OleDbConnection("etc etc") 'use the connection object here '.... connection.Dispose
As for your current error, can you post your actual Select statement?





Reply With Quote