deepkt (7/9/2013)

---

Hi,

I have one requirement and need help.

I have a table:

CREATE TABLE MiscItems(ID INT, Description VARCHAR(50), DisplayOrder SMALLINT)

INSERT INTO MiscItems(ID,Description,DisplayOrder)

SELECT 100, 'A1',1

UNION ALL

SELECT 101,'A2',2

UNION ALL

SELECT 102,'A3',3

UNION ALL

SELECT 104,'A4',4

UNION ALL

SELECT 105,'A5', 5

UNION ALL

SELECT 106,'A6',6

SELECT * FROM MiscItems

DROP TABLE MiscItems

I will display in UI: Description & Displayorder and both are editable in UI.

My requirement is User can modify DisplayOrder of his interest and clicks on save, then accordingly the display order should be saved in table.

User can change multiple items at once and accordingly data should be re arranged and saved in table.

Display order will not be a zero & non negative value.

please help..