Is this possible with just pure DataSets?

  • Thread starter Thread starter ghsmith
  • Start date Start date
G

ghsmith

I know I can do this if I'm using a real database and queries. I don't
want to assume the presense of a decent engine on people's machines so
I'm trying to use just the .Net Framework (ie: DataSet).

Among many other tables/fields/etc. I have...

I have a "Members" table which is unique by Group_Name+Player_Name.
ie: Lists which players belong to which groups.

I have a "PlayerHistory" table which is unique by
Player_Name+Scenario_ID. ie: Lists which scenarios have been played by
specific players.

I have a "GroupHistory" table which is unique by
Group_Name+Scenario_ID. ie: Normally would be a join result.

I want to have a Count expression column in the GroupHistory table that
involves the other 2 tables. Namely, I want to get "count of players
of this group who have played this scenario".

Is this possible with just pure datasets and expression columns?
 
GHSmith,

In my opinion should it be posible.

When we have a datarelation, than we know the count of the childrows which
you should be able to use in an expression.

However I never tried it.

I hope this helps,

Cor
 
But in this case, I need the results from consulting 2 tables - not
just one. I'm doing child based expressions in other columns but they
are only referring to 1 table. I may well be possible, I'm just not
sure how.
 
Back
Top