cell event of datagrid ?

I write a crosstab query, it be binded in a datagrid control.

as shown:

Company master bachelor

--------------------------------------

companyA 40 38

companyB 65 67

----------------------------------------

I want to do it :

When I click one of cell, it will shown a list of name details.

for example : when I click '40', it will shown "Milk, Tom, Joan......"

How can I carry it out in the datagrid I was at a loss.Thank you everyone.

Chirurg
>I try to store a string as a qurey condition to the cell, and then , >When I click the cell, it will execute a query, for example :
-- select name from table where degree ='master ' and company ='companyA'

>But I cannot do that , Where to retreive the data for the list

This should work. Why you can't do that
shubs
You can add CurrentCellChanged event handler and display what it needed as it's executed.
JohnWoll
AlexY, where are you
congratulations

Thank you , AlexY.

Yes, I am not sure all of your mention, however, to my worry:

How do I retreive the data for the list

I try to store a string as a qurey condition to the cell, and then , When I click the cell, it will execute a query, for example :

-- select name from table where degree ='master ' and company ='companyA'

But I cannot do that , Where to retreive the data for the list

Thank you.
Jadedmouse

Sorry.

I mean I do not how to store a string as a qurey condition to the cell

Thank you.
David_Baron
So what's your problem specifically

You don't know how to identify the cell Were to retreive the data for the list or how to show list
cell event of datagrid ?