How to add & retrieve images of a country flag in SQL server(inbuilt in VS), based on country name selected from the dropdown list?

Question

1.00/5 (1 vote)

See more:

I am trying to store images of the Country flags,Capital city of country,symbol in Sql server(inbuilt in VS) & added a dropdown list of Country name.

To be Clear, upon selecting a Country from dropdown list i need to display corresponding selected country's flag & other details(capital city,symbol,etc) in details view.

Please reply for the above question.

Posted 20-Jan-15 22:30pm

Deeepakk

Updated 20-Jan-15 22:40pm

v2

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)

V. · Accepted Answer · 2015-01-21T00:13:00

Solution 1

Well you didn't provide that much info, so here's my best guess.

1.
Put the images in a common folder and store the path of the file together with the countryname in the database.

2. When loading the dropdown, don't load the country names only, rather bind the dropdown to the "country" object where you show the name as text, but behind the dropdown item you have the entire object (flag image path, country name, capital name, ...).

3. When changing the dropdown item handle the event retrieve the object, get the flag image path from the object and load that image from disk into a control.

Start with small problems at a time and you'll get there.
If it is ASP.Net you'll probably need to set some access rights to the image storage folder.

hope this helps.

Posted 21-Jan-15 0:13am

V.

Comments

Deeepakk 21-Jan-15 7:14am

To be clear.I have binded dropdown to datasource & added image field in it but the thing is i am not able to get appropriate flag image on selecting particular country from dropdown.
Can you send me code for that.
I need code to match selected value from dropdown & flag image from database.

V. 21-Jan-15 7:17am

I will NOT send you code for that. I don't have it around and I don't have time to setup a database and code something that might be useful for you, effectively doing your work for you. Look up piece by piece and ask more precise question when they arise.
If you do need code I can always refer you to this site: http://www.rent-acoder.com/

Deeepakk 21-Jan-15 23:31pm

ok buddy, to be PRECISE
Things i have done:
1.I added list of country name in dropdown list
2.Taken sqldatasource & gridview to display data from database
3.binded the datasource to dropdown list
4.data i have added to database are flag images,capital cities of countries present in dropdown
THATS ALL ABOUT INITIAL SETUP

5.My aim is to display the content(flag,capitalcities) from database upon selecting a country name from dropdown.
ie for eg: upon selecting INDIA from dropdown list, Indian flag & its capitalcity should display in details veiw.

Deeepakk 12-Feb-15 2:47am

Waiting.

V. 12-Feb-15 3:22am

I consider this topic closed.