<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:JC %>"
SelectCommand="SELECT distinct(CarModel) FROM [cars] where Carbrand=replace(@carbrand,'-',' ')">
<SelectParameters>
<asp:RouteParameter Name="carbrand" RouteKey="carbrand" />
</SelectParameters>
the above query and everything is working fine for the below url
carmodel/audi-car
, right now routekey for carbrand, the data is coming like this
carmodel/audi-car)
so i have to remove ")" bracket in the routing. how can i do that???
Go to the complete details ...