Posted on: 12/5/2014 4:24:50 PM | Views : 557

<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 ...