Re: Keeping a DataView in Memory

ADO and ADO.NET Examples and Best Practices is written for developers transitioning to ADO.NET and has a wealth of fundamental material for those getting started. The 7th Edition takes up where the ADO.NET E&BP book leaves off and talks about the ADO.NET that ships with VS 2005 and far more on SQL Server, the tools and how to design successful applications.

No, I have no idea how authors make money on tech books. They don't stay on the shelves (being pushed off by more recent content) long enough to pay off the advances.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
http://betav.com
____________________________________________________________________________________________



"Fred Block" <fblock_no_spamming@xxxxxxxxx> wrote in message news:eKBa0dhYJHA.2084@xxxxxxxxxxxxxxxxxxxxxxx
Hi William,

Thanks a ton for that tip! That did seem to make the data return way faster. It's easy for me to notice because the data is coming from a remote SQL connection. With this application on the actual server, I suppose it'll be light-speed now. I appreciate your time and your input with this topic.

May ask you to recommend one of your two books for me being an ADO.NET beginner please? ADO.NET and ADO Examples and Best Practices for VB Programmers, 2nd Edition -or- Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)

I'd like both but I'm budgeted for one now...

Thanks! -- Fred


"William Vaughn (MVP)" <billva@xxxxxxxxxxxxxxx> wrote in message news:uMzTWLYYJHA.4424@xxxxxxxxxxxxxxxxxxxxxxx
And you don't need a DataAdapter either. Open a DataReader, use the new DataTable.Load method. It's light and fast. Set your DataView properties to filter or sort as needed.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
http://betav.com
____________________________________________________________________________________________



"Kenny" <Kenny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FC80A9F5-B1A6-4DD0-BC0A-F36F4A871BF4@xxxxxxxxxxxxxxxx
Often ... I don't even use a DataSet.

I define a DataTable().
Fill it with a DataAdapter.
"Index" it with a DataView.

As long as the DataTable and DataView object remain in scope then you can
play with the DataView all you like.

"Fred Block" wrote:

Hi All,

What is the best way to keep a DataView in memory? I need to access it often
(using "Find" to get data from it repeatedly) and then process other data
based on what I pull from it. I'm thinking a class but I'm new to ADO.NET
and OOP (for the most part). I was also thinking this may give better
performance than repeated calls using a stored procedure.

I thought at first module level variables...

Also - Will I need to keep the DataSet and/or DataTable open too used to ?

All thoughts and ideas are greatly appreciated with many thanks in advance!

Kind regards - Fred





.

Relevant Pages

  • Re: Keeping a DataView in Memory
    ... I appreciate your reply and will pick up a copy of the ADO and ADO.NET ... Hitchhiker's Guide to Visual Studio and SQL Server ... 2nd Edition -or- Hitchhiker's Guide to Visual Studio and SQL ... "Index" it with a DataView. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)
Loading