How to use sql data values as a dynamic link button

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I want to use a dynamic link button over the sql data which gets displayed
on the page.

e.g.,
If I have column Name "MobileNo" in database, when I get the count(say 5) of MobileNo on the web page. I want to click that count value(say 5) and it should navigate to some other page showing all the 5 MobileNo's..

Please anyone suggest me on this....

Regards,

Posted 26-Feb-11 0:20am

Raj.rcr

Updated 27-Feb-11 22:27pm

v3

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)

Sandeep Mewara · Answer 1 · 2011-02-26T00:51:00

Solution 1

What's in it?

STEPS:
1. Get the mobile number count from DB
2. Set that as a text to hyperlink
3. On hyperlink click event, set the unique identfier that identifies those 5 numbers as a query string or session or form variables - your choice based on application
4. On new page, based on the selection, hit the DB and get those records.

Try!

Posted 26-Feb-11 0:51am

Sandeep Mewara

Comments

Espen Harlinn 26-Feb-11 9:29am

Nice recipe, my 5

Raj.rcr 28-Feb-11 0:31am

sorry, its not working... I tried with the link button..

arindamrudra 28-Feb-11 2:39am

What have you taken? Gridview or Repeater? Or, you are using it directly. If you are using repeater then write your necessary code in itemdatabind event. else in case of link button linkbutton1.text = the count return from database and write necessary code on click event of that button. Or, in case of a repeater use anchertag.

arindamrudra 28-Feb-11 2:44am

Sandeep gave the correct solutions. Why it is not working? So, us some of your code.

Raj.rcr 28-Feb-11 4:25am

No, I am not using repeater or gridview. I am looping through html code and using the <tr> data, I am getting the database column's counted values. But the problem is, if I click the particular value, I want another page to be redirected with the details of the counted values.

arindamrudra 28-Feb-11 4:33am

Then use anchor tag. Put the count value in anchor tag and set the redirection to desired page. If there is session value then you can get all your details from there or else send required value with query string. In page load write necessary code for query string. That will work.