Click here to Skip to main content
16,017,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am making an E-commerce site in .net(database using SQL server 2008). I want to manage display order of already added product according to admin on user side. At present Display order is desc. on both side(user and admin).

As for example- if admin have added 3-products(x,y,z) and now these products are showing on user side in order(z,y,x) but now admin want to change display order(y,z,x) how can he change? thanks to all in advance.
Posted

1 solution

you can create a stored procedure in which orderby is set by admin and use that sp to show product at client side
 
Share this answer
 
Comments
Naveen K Tiwari 14-Nov-13 1:25am    
how can i set order by according to admin?
Vishal Pand3y 14-Nov-13 2:09am    
In Admin Section Create a page put a dropdown or whatever u want to select order by from that page admin can set order
and in that stored procedure which you are using to bind data to show at client side read last value set by admin
Hope It Helps..........

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900