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
Who is Participating?
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.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.