hyperlink in database

Question

0.00/5 (No votes)

See more:

I am trying to pull all the content from the table row when I click the hyperlink.
So can I put the hyperlink in the database table.
EXAMPLE:

I have a policies table which has a policy ID and policy name as two fields.
So this policy is connected to a standards table(fields are standard number and standard url) which is connected by one-many relation.So I am putting this stanadrd URL in to the datatable.So the policy has many standards which I will put them in datatable and when I click it the standard document gets opened by populating the standard content fields.

Can this be done by keeping the hyperlink in to the database table.

Any suggestions or advice?

Posted 31-Jul-12 7:18am

Member 8544853

Add a Solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2012-07-31T07:55:00

You don't need to keep the hyperlink in Database.

1. If you are binding the data to a GridView, then you can bind the PolicyID in one column and also u can make it DataKey of GridView.

2. Then you can have the hyperlink inside one ItemTemplate.

3. After that u have do some coding in GridView onRowCommand Event....

4. You have to use e.CommandArgument to get the selected row number and using the row Number you can find the corresponding Datakey Value which is the PolicyID for that particular row.

5. After getting the PolicyID, you can easily pull data from database for that ID.

Refer Using GridView and RowCommand Events[^] for one example.

I have shared the idea and logic how to do the task.
Now you have to implement that.
Please try to implement and come back with your codes, if you face any issues.

Thanks...

jschell · Answer 2 · 2012-07-31T07:50:00

Solution 1

You can put a url into a column into a table.

If however you are asking if you can put some meta-data object tree (regardless of representation) into a column then basically the answer is no.

Posted 31-Jul-12 7:50am

jschell