how in the world do i sort a datagridview?

[nev]

i gotta form2 with a datagridview control. data is entered in it programatically.

i wanna do form2.datagridview.sort(what will i put here???, direction)

definitely a string or integer for a columnindex is not valid. so how will i reference the current datagridviewcolumn. i noticed there is datagridview.currentrow but where's datagridview.currentcolumn??? did microsoft forgot about it?

[QVeen72]

Hi,

Why not set this property of datagridview:

AllowUserToOrderColumns = True

REgards
Veena

[jamesd0142]

also add a sort order into your sql statement if you using 1

[nev]

Hello Veena, but isn't that property only used to allow a user to rearrange the columns?

Hi jamesd0142, I use a For Next loop to enter data to my datagridview. Data comes from 3 different bindingsource. I would like to physically manipulate the sorting of the datagridview I have filled with values.

For example I have filled my datagridview with values...

____|col1|col2|
row1|_B_|_2_|
row2|_C_|_3_|
row3|_A_|_1_|

I wanna sort it by col1...

datagridview.sort(???col1???, system.componentmodel.listsortdirection.ascending)

____|col1|col2|
row1|_A_|_1_|
row2|_B_|_2_|
row3|_C_|_3_|

The first parameter should be a datagridviewcolumn type. If I place "col1" or datagridview.currentcell.columnindex, naturally it won't work. I also noticed that the datagridview.columns property has getpreviouscolumn and getnextcolumn but he got no getcolumn or getcurrentcolumn.

Maybe I'll try placing the cursor to col2 and use getpreviouscolumn, but this is dumb. Anyone knows the correct way to do this please help.

[nev]

MWAHAHAA!!! I got it. I GOT IT!!! I can't believe i got it! I finally know how to reference the current datagridviewcolumn!!!

[jamesd0142]

Awsome, what i was suggesting was in you select statement add an order by clause.

e.g. select columnname from tablename where parameters = ??? order by columnname1, columnname2...

cheers