A connection can be open, and closed at each time, but a better way to use them is to open one, and query everything in the using. Do not forget that you can only do that when you are NOT using Datareader! An exclusive connection is required in that case. -f.