VB.NET Disconnected DataReader...
-
Ok, I am frustrated!:confused: I am trying to find the most optimal way to retrieve Data from a Database. I understand that there are basically 3 ways to do this: 1.) Stored Procedure (DataCommand), 2.) DataSet, 3.) DataReader. My dilemma is, I do not need to store this data for Saving later on (basically I am loading some ComboBoxes). I would like to use a DataReader but sometimes I hit conflicts where the program tries to open more than one Reader (which can't be done on the Same Connection). I do not want more than one connection. I do NOT want to use a DataSet because I do not want the Overhead of creating one since it's not needed. I've tried MSSQLXML 3.0 SP2 to retrieve data through XML. I have tried using the SqlCommand.ExecuteXMLReader. Any method that using a "Reader" of some sort basically uses a DataReader behind the scenes! Is there some way that I can retrieve all of the Records into a Stream of some sort and then loop through it? In VB6 this was easy...I created a Forward Only / Read Only Disconnected Recordset.