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
Loading
saifullah khanPosted Aug 30, 2012, 9:18 AM
thanks
Adil AnsariPosted Aug 30, 2012, 8:45 AM
You can use the reference keys(i. e. UserId or UserName) to make the Left outer join between TempTable and PicTable, such a way you get the all the users with their images (if any).
So, just a matter of writing the SQL query (with join) and rendering the result onto your Page
Hope this answers your question, if not let me know more details