how to bind data to images

Question

0.00/5 (No votes)

See more:

i have multiple images of students and those are scrolling in my website.
And i have a students table in database.Now, when i click on a particular student image in my website it will display the details of particular Student from students table.

Posted 19-Dec-14 20:42pm

Member 11052105

Add a Solution

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)

Afzaal Ahmad Zeeshan · Answer 1 · 2014-12-19T21:53:00

That is a pretty much database job, to query the data about the Student. What you would do, is to create a table for a Student that will contain all of the information about him, including his picture. The table can be like this,

StudentID | Name | FatherName | Picture | Course [| other columns...]
1         | Ahmad| Abdullah   | Pic.png | .. remaining data

.. now there are some images in your website, which (as you say) can be viewed (because you said scrolling; I assume you meant that the user can scroll to see all of the images in the website) and the image has a name (or better if it has an ID). You can create a hyperlink for those images, to direct to the profile page for the student. Like this,

HTML

<!-- ASP.NET version of code, change it to your language -->
<a href="~/profile/@Student.StudentID">
   <!-- Show the image... -->
   <img src="~/Images/@Student.Picture" alt="Student Picture" />
</a>

.. now once the user will click, he will be redirected to the Profile page, and there will be the student's ID assosiated at the end of the URL. On that page you can use that StudentID to query the database, and get all of the data assosiated to him.

Tip: Always try to make a single table as much as you can try. Do not duplicate the data inside the tables, but save the data for every object (Student is an object) inside the same table, instead of creating a different table for each of the attribute he is having (Name, FatherName, Picture, Course etc).