How to link data from texbox to gridview/table?

Question

0.00/5 (No votes)

See more:

I am trying to look for example or guide, into setting up the following functionality, as explained below:

I have web application, where I am displaying text description(e.g. of data) such as one below:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. 
Aenean arcu nunc, luctus vitae sodales vitae, tag1 quis sem. 
Integer nisl leo, iaculis vel mi ac, sagittis tag2 nisi. 
Suspendisse volutpat blandit nisi, eget pulvinar sem lobortis quis.

In the description textbox, i have certain data which i would like to be represented as links, which link to table, showing corresponding data records, when clicked on (bold & underlined text), such as shown below:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. 
Aenean arcu nunc, luctus vitae sodales vitae, tag1 quis sem. Integer nisl leo, iaculis vel mi ac, sagittis tag2 nisi. 
Suspendisse volutpat blandit nisi, eget pulvinar sem lobortis quis.

clicked on tag1, would lead to table, showing tag1 details:

Name	Value	SSC
Tag1	45	TL45
Tag1	15	YH56

I would like to know, what kind of sql queries i need to create for this task and what methods or properties, i could look into for implementing this task.

Please help. Thank you for your time and help.

Posted 4-Sep-14 1:18am

miss786

Add a Solution

2 solutions

Solution 2

See this Example, This has a grid view pop up on click Button, you can change it to On Click of Link. I think this will useful for you.

http://aj-learning.com/blog/show-gridview-popup-window-asp-net/[^]

Posted 4-Sep-14 1:59am

Gihan Liyanage

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)

George Jonsson · Accepted Answer · 2014-09-04T01:57:00

You should look into RichTextBox, this control can handle links.

I found this project that probably answers some of your initial questions.

Links with arbitrary text in a RichTextBox[^]

Regarding the SQL query you need, I can't answer that without knowing your database structure.
Basically you could fill a DataTable using a DataAdapter
DataAdapter Class[^]

If you have a column called 'Name' in the datatable you can do something like this is in the code behind the link click.

C#

// Assuming you have a datatable called dtTagInfo that has been created beforehand.
DataRow dr = dataTable.Select(String.Format("Name = '{0}'", tagFromRichTextBox)).FirstOrDefault();
if (dr != null)
{
   // Present the information
}