Building a query off of a dataset

Posted on 2006-04-18
Last Modified: 2010-04-23
Is it possible to build a query off of a dataset that is a query of a table?  IE:

Table:  "Solds"
DataSet1: Contains Prices from Homes from a Subdivision
DataSet2: Average of prices from DataSet1
Question by:Marc333
    LVL 96

    Accepted Solution

    If you have a DataView, you can use a RowFilter.  If you don't, then you can use the Select method.  They both take simple filter expressions, and cannot handle SQL-like syntax, but you still may be able to do it.

    LVL 3

    Author Comment

    Well, I think I've worked around the issue by using an array to create calculations from the dataset.  But I appreciate the idea.  

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now