set link in database

Question

1.00/5 (2 votes)

See more:

how can we set a link in the database. I want to set different link for each row data.
example: I have a database of images which i ll be display in the grid view or any other control. when user clicks on any image i want to redirect the user to the particular bigger size image he/she clicks on.

c# code only.

Posted 17-Sep-10 11:17am

patelKhyati

Add a Solution

Comments

Sandeep Mewara 18-Sep-10 4:43am

What have you tried? Put some effort!

2 solutions

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)

Michael Eber · Answer 1 · 2010-09-17T12:08:00

Solution 1

save the url in the database as a string.
Populate a linkbutton with the string to act as a url

Posted 17-Sep-10 12:08pm

Michael Eber

Comments

patelKhyati 21-Sep-10 6:51am

its not helpful
can u please give me the code in c#?

Ruselo Riva Asentista · Answer 2 · 2010-09-17T19:40:00

There are two ways to do this:
1.) Save the url as a string in the database and populate it in a link button which is bound to a datagridview
2.) Save the image in richtextformat and save it in a varchar(MAX) column. (Microsoft prefers this method over BLOBS (Image and Text)), Then for each row in your datagridview, place the image (retrieved from database) to an image cell and set the size to 100 x 100. You may need to convert the richtextformat back to image or icon (I suggest icon for the thumbmarks). If the user clicks on that cell (image cell), display a Form containing only the imagebox with the image (convert richtextformat back to image).

I'm not very sure about retrieving stuff from a Thumbs.db file... but if you could explore this possibility, please let me know.

Thanks and good luck