Re: How do I query a dataset?
From: Miha Markic [MVP C#] (miha)
Date: 03/03/04
- Next message: Wolly: "AS400 invalid token"
- Previous message: Miha Markic [MVP C#]: "Re: INSERT a datetime using convert"
- In reply to: 2: "How do I query a dataset?"
- Next in thread: Earl: "Re: How do I query a dataset?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Mar 2004 10:35:22 +0100
Hi,
You should use DataView with RowFilter set accordingly.
Another approach is to use DataTable.Select method which returns array of
DataRows.
There is no real SQL support there.
-- Miha Markic [MVP C#] - RightHand .NET consulting & software development miha at rthand com www.rthand.com "2" <2@2.2> wrote in message news:eBBISrPAEHA.2480@TK2MSFTNGP11.phx.gbl... > Hello, > > I get how to populate a dataset by querying a database server... but once > I've populated my dataset, say with several related tables, how can I then > select records from the dataset copy of data using SQL statements instead of > the database server itself? > > In some cases I'd say this is preferable to hitting the database server > everytime a subset of data needs to be retrieved. Only suitable for small > amounts of static data of course. > > As an example if I have a populated table of employee data in a dataset and > I want to populate a temp table with only those records where employee age > > 60..... am I limited to filters or can I use SQL statements (which would > then mean no extra code if I decided to point back at the database server > instead of the dataset itself)....? > > Hope this makes sense to you guys... cheers > > > > > > >
- Next message: Wolly: "AS400 invalid token"
- Previous message: Miha Markic [MVP C#]: "Re: INSERT a datetime using convert"
- In reply to: 2: "How do I query a dataset?"
- Next in thread: Earl: "Re: How do I query a dataset?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
