How to rearrange serial no/Sorting Order

Question

1.00/5 (2 votes)

See more:

i have 3 columns in gridview like as below:

ProductID ProductName Order
44 Lux 1
56 Dove 2
69 Pears 3
78 Hamam 4
84 Power 5
----------------------------
Dropdownlist loads the Productname
2 textbox:
1. txtOldOrder
2. txtNewOrder
when i select the productname : Pears in dropdownlist it shows txtOldOrder=3......
when i give value as 2 in txtNewOrder that gridview should rearrange like as below :

ProductID ProductName Order
44 Lux 1
69 Pears 2
56 Dove 3
78 Hamam 4
84 Power 5

~~Very Urgent Please reply quickly~~

Posted 23-Oct-13 10:16am

pavan_4510

Updated 23-Oct-13 11:11am

Sergey Alexandrovich Kryukov

v4

Add a Solution

Comments

[no name] 23-Oct-13 16:36pm

It's not urgent to anyone here. And you need to show some of the code you have written if you want a sensible answer.

Sergey Alexandrovich Kryukov 23-Oct-13 17:12pm

http://www.whathaveyoutried.com so far?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dave Kreskowiak · Answer 1 · 2013-10-23T14:55:00

Solution 1

Since non of these tables has a serial number, it's pretty much impossible to answer your question.

You're also going to have to explain what you mean by "rearrange sort order".

Posted 23-Oct-13 14:55pm

Dave Kreskowiak

Comments

Nagaraj Bobba 26-Oct-13 2:56am

TestOrder is the serial no

Nagaraj Bobba 26-Oct-13 3:15am

i mean in that table having Order column that column is serialno column

Dave Kreskowiak 26-Oct-13 10:07am

Order does not mean "Serial Number". Name your columns what they describe. If this column is used specifically for a sort order, name the column "SortOrdinal".

So you want to change the order in which the items are sorted? You're going to have to load the table into a DataTable object in your code, reassign the sort ordinal numbers and then write the table back to the database.