Hi
I try to fill gridview with data from table 1

ID | NAME | DATA1 | DATA2 | DATA3
---------------------------------
1 | NEW | 11 | 12 | 9
2 | OLD | 10 | 8 | 12
3 | ACT | 7 | 9 | 10

where values DATA1,DATA2,DATA3 are IDs from second table

ID | NAME | DATA
-----------------
7 | one | xxxx
8 | two | xxxx
9 | tre | xxxx
10 | fou | xxxx
11 | bla | xxxx
12 | mia | xxxx

I want show in gridview not IDs but names which belongs to ID's
like this

ID | NAME | DATA1 | DATA2 | DATA3
---------------------------------
1 | NEW | bla | mia | tre
2 | OLD | fou | two | mia
3 | ACT | one | tre | fou
how can I do this???
I have idea to make this when is rowdatabinding,but I need that ID values for next work...
thank's for advice

hi there..

this looks like more to an sql problem.. what is the logic to build the result table??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========