suppose there is a datatable (in asp.net,not sql database table) with 3 columns
col1 col2 col3
high cool no
high normal no
low cool yes
low normal no
high dry yes
low dry yes
column values are like these.
col3 name is already known.
suppose col1 is selected now.then how many 'high' values(in col1) are having corresponding col3 value 'no' and how many 'high' values(in col1) are having corresponding col3 value 'yes'
This same has to be calculated for each value in col 1 and 2 corresponding to the col3 values yes and no.
How can I do it?