How to display data in gridview?

[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

[majestic0110]

Hi there, I have found a very good tutorial on data access that may interest you:

http://www.asp.net/Learn/data-access/tutorial-52-vb.aspx

I hope this helps!

[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

[majestic0110]

Ok, may I recommend that you watch the videos here :

http://www.learnvisualstudio.net/

These videos are great for absolute beginners and definately recommend them. HTH

[ansari.wajid]

Thanks a lot