ADO.net "Recordset"

[Paul Ilacqua]

What is the most efficient VB ADO.net method to pull read only data from a
SQL Server database? My entire application reads / no writes to SQL Server
database. I want to display the results from stored procedures in a data
table.
Thanks
Paul Ilacqua

 

[William \(Bill\) Vaughn]

There is only one way ADO.NET returns data: via the DataReader. If you're
working with ASP.NET you can bind to a RO DataReader. If you're working with
a Windows app, I would use the DataAdapter which (also) uses the DataReader,
but quickly does all of the work needed to build a bindable
DataTable/DataView.

hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Mary Chipman]

In addition to what Bill suggested, you can also mark the filegroup on
which the database resides as read-only, which will further speed up
data retrieval.

--Mary

 

[Sahil Malik]

I'd like to add, you can do databinding in any environment using only
datareader (no need for DataAdapter) using a nifty trick
http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/11/36078.aspx

The arraylist in the trick above is much light-er-weight compared to
DataTable/DataView.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik