You don't show us the code you use to set up the reader- but I'm guessing that you use the existing
con
SqlConnection object to form the connection.
And then in your loop you USSR it again to feed your DatraAdapter, and then:
con.Close();
you close it inside the reader loop, so the reader will be closed as well.
So either don't close it, or create a new connection for your DataAdapter.