Changing Text in asp:HyperlinkField

[wbodger]

I have this code

<asp:HyperLinkField runat="server" HeaderText="Add/View Status" DataNavigateURLFields="fabpn" DataNavigateUrlFormatString="~/AddMaterialStatus.aspx?PartNum={0}" Text='Add/View Status' ></asp:HyperLinkField>

in the dataset I have a field 'Status' which is either blank or says '/View'. I would like to have the value in the text field be 'Add<%=Status%> Status', but I have not been able to come up with a way to do that so it actually uses the value from the database. Help?

Thanks,
wb

 

[wbodger]

Figured out that I needed to use the DataTextField property, manipulated the SQL and it works great.

wb