ADO.net "Recordset"

  • Thread starter Thread starter Paul Ilacqua
  • Start date Start date
P

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
 
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.
__________________________________
 
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
 
Back
Top