Hi

 I have  2 tables in database as follows:

table1: 

id             name          state id      

1              aaa              1,2

2              bbb              1,3 

table2:

id          state

1            ak

2            ny

3            jk

so the problem is that  I want to display all the data of "table1" in a gridview and in place of  "state id" I want to display "statename", for example in place of "1,2" I want to display "ak,ny".

How to do this?

Please help me.

Thanks

 just change the query you are using to bind the grid, it should be like this,

Select table1.*,table2.* from table1

inner join table2 on

tabe1.stateid=table2.id