Author: oguzkaygun | Posted on: 12/30/2008 9:59:57 AM | Views : 289

hello

i have dropdownlist and i have date+ and date- and price+ and price- as item of Dropdownlist.

i want to use item of dropdownlist as ORDER BY in storedprocedure.. when i click one of items, it should be ORDER BY in storedprocedure..

How can i do this ? Should i use four StoredProcedure for per item of Dropdownlist? or is there sort way ?

My StoredProcedure is below.

BEGIN

WITH ListEntries AS (

SELECT ROW_NUMBER() OVER (ORDER BY urunnumarasi Go to the complete details ...