use reference of one table and get data from other table

Question

0.00/5 (No votes)

See more:

Hi!
i have two different tables. temptable, pictable.
the temptable contains all those usersname whos are online. and pictable contains pictures of all the users who are registered.
now i have an index.aspx page it contains gridview
what i want is to when the page loads it checks the temptable and take pictures of all those users that are present in temptable and show it in gridview.
please tell me how to do it.
thanks in advance

Posted 30-Aug-12 0:33am

saifullahiit

Add a Solution

Comments

_Amy 30-Aug-12 7:57am

What have you tried yet? Where you stuck?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kashinath Patil · Answer 1 · 2012-08-30T00:48:00

Solution 1

temptable should contains userid (primary key) which is reference key in pictable

for example

temptable:
userid (primary key)
username
pictable:
userid(foreign key)
image

Then add gridview and assigned sqldatasource which has query

Select t.username,p.image
from temptable t join pictable p
on t.userid=p.userid

Posted 30-Aug-12 0:48am

Kashinath Patil

Comments

saifullahiit 30-Aug-12 7:22am

cant understand :( could you please elaborate it thorough code?please
thanks