Member Avatar for ansari.wajid

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

  • 2 Contributors
  • 4 Replies
  • 92 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ansari.wajid
Member Avatar for ansari.wajid

Hi

Thanks for your reply.
Sorry to say that the link you sent does not match my requirement. Actually I am new to asp.net, If you have any other idea for my requirement please reply back.

Thanks again

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.