adding sql query output to hyperlink in asp.net

Question

I think it might have been asked before but i was unable to find the right answer, so i am asking here. i have added a data source which is working fine, i wanted a feature where i query the top n entries from the database and add it with a hyperlink. Think of it like Latest News! The markup for the hyperlink inside the ItemTemplate of DataList is this.

 <asp:HyperLink ID="HyperLink1" runat="server" 
                Text='<%# Eval("News_Id") %>' NavigateUrl="~/News.aspx?NewsId=<%#Eval("News_Id") %> " runat="server" /> </asp:HyperLink>

however i get The error as "Error Creating Control, Server tag is not well formed". It reports the error where the quotes are placed.

I know i can use datanavigateurl property but i want to write it in this way. as written in the markup above. How can i?

Upon re writing it to

NavigateUrl='~/Product.aspx?DVDID=<%#Eval("Title") %> '

i get the following as the url

http://localhost:61221/Product.aspx?DVDID=<%#Eval("Title") %>

The title of this question is definitely misleading. This is about databinding, not an SQL query per se. — Cerebrus
– Cerebrus, Commented Jul 7, 2009 at 7:12

Canavar · Accepted Answer · 2009-07-07 06:57:18Z

2

try this :

<asp:HyperLink ID="HyperLink1" runat="server"
    Text='<%# Eval("News_Id") %>' 
    NavigateUrl='<%#Eval("News_Id", "~/News.aspx?NewsId={0}") %>' 
    runat="server" /> 
</asp:HyperLink>

<%# Eval() %> must be inside single quotes, otherwise it throws error.

To concatenate string in your binding tag, you can use this :

<%# "~/News.aspx?NewsId=" + Eval("News_Id").ToString() %>

edited Jul 7, 2009 at 6:57

answered Jul 7, 2009 at 6:42

Canavar

48.1k17 gold badges94 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Anirudh Goel Over a year ago

upon doing so i get the following as the hyperlink localhost:61221/… %> it is not processing Eval

Canavar Over a year ago

Updated my answer, try the new one please.

Anirudh Goel Over a year ago

i know that method too..i wanted to concatenate literal text and eval method.

Anirudh Goel Over a year ago

got it '<%# "~/News.aspx?NewsId=" + Convert.ToString( Eval("id"))%>' this works! Though i know it is primitive way and what you have suggested is the new one and better being datanavigateurl. Thanks nevertheless for helping.

Canavar Over a year ago

yeap I was writing my new answer :)

Collectives™ on Stack Overflow

adding sql query output to hyperlink in asp.net

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related