Prefix the Hyperlink on a Bulleted List 1

[djs45uk]

Good Afternoon

I am using the following code to create a bulleted list based on records retrieved from a database. My bulleted list is set to DisplayMode="Hyperlink".

The DataTextField="downloadTitle" and the DataValueField="downloadFilename".

However, I would like to prefix the DataValueField with a string like this "download/".

<asp:BulletedList ID="releteddownloads" runat="server" DataSourceID="ds_relateddownloads"
DataTextField="downloadTitle" DataValueField="downloadFilename" DisplayMode="HyperLink">
</asp:BulletedList>
<asp:SqlDataSource ID="ds_relateddownloads" runat="server" ConnectionString="<%$ ConnectionStrings:StPaulsDatabase %>"
SelectCommand="SELECT [downloadTitle], [downloadFilename] FROM [Downloads] WHERE ([downloadCategory] = @downloadCategory)">
<SelectParameters>
<asp:Parameter DefaultValue="Laptop Scheme" Name="downloadCategory" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

How can I prefix the DataValueField with a bit of text?

Many thanks

Daniel

 

[vbkris]

one way:
SelectCommand="SELECT [downloadTitle], 'download/'+[downloadFilename] FROM [Downloads] WHERE ([downloadCategory] = @downloadCategory)">

Known is handfull, Unknown is worldfull

 

[djs45uk]

I guess whilst I'm here, does anyone know if it's possible to set the hyperlink's target also (let's say to _blank).

Many thanks in advance

Daniel

 

[vbkris]

use this property:
Target="_blank"

Known is handfull, Unknown is worldfull

 

[djs45uk]

Thank you vbkris - I tried the following but it doesn't work.

<asp:BulletedList ID="releteddownloads" runat="server" DataSourceID="ds_relateddownloads"
DataTextField="downloadTitle" DataValueField="downloadFilename" DisplayMode="HyperLink">
</asp:BulletedList>
<asp:SqlDataSource ID="ds_relateddownloads" runat="server" ConnectionString="<%$ ConnectionStrings:StPaulsDatabase %>"
SelectCommand="SELECT [downloadTitle], 'download/'+[downloadFilename] FROM [Downloads] WHERE ([downloadCategory] = @downloadCategory)"> 
<SelectParameters>
<asp:Parameter DefaultValue="Laptop Scheme" Name="downloadCategory" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

The following error is returned:
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'downloadFilename'.

 

[vbkris]

oops:

change
'download/'+[downloadFilename]

to
'download/'+[downloadFilename] [downloadFilename]

Known is handfull, Unknown is worldfull

 

[djs45uk]

Thank you very very much! I am truly grateful.

Daniel

 

[vbkris]

welcome...

Known is handfull, Unknown is worldfull