• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Building a query off of a dataset

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
1 Solution
Bob LearnedCommented:
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.

Marc333Author Commented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now