I am trying to read a querystring and then use this to run a query and display the results for that variable. Very simple.
Unfortunately some of the names have special characters within them and as a result I am not using the full name when running the query on the second page.
i.e. name might be equal to "chas & dave", but the querystring is only giving me back "chas" on the second page and when I search for chas I get no results. Any tips, I seem to have two characters causing an issue "&" and "#".
<asp:hyperlinkcolumn datatextfield="merchant_name"
datanavigateurlfield="merchant_name"
datanavigateurlformatstring="writing_out.aspx?id={0}"
headertext="Merchant Name" />