Skip to Content
author's profile photo Former Member
Former Member

Sort functionality in Data Grid

Hi Gurus,

I am new to this DataGrid control.I want to establish the sort functionality when clicking on the headercolumns as in matrices.

(ie.When double clicking the header column , sort the data in ascending or descending order of that column) like in system form matrices.

How ever this is not possible when I tried with grid control.

The problem I am facing is that I cannot get the column headers of the grid programmatically.(in duble click event or itempressed event)

Anybody did this one previously? Also how

we can change the column order of the grid using screen painter?

The columns that actually come visible in the grid are actually columns of the linked datatable object.

In the designer ,there is no "swap" button for column re-ordering.

Only one way I know is changing the query associated with datatable.

This is a crucial thing ,since client may ask for re-ordering of columns frequently.

Can anybody help?

Regards,

Deepesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 17, 2006 at 02:19 PM

    Hi Deepesh,

    1. This functionality is not available with the SDK. Thus it's not possible to change it on the fly. Your only option is to change the query associated with datatable (as you mentioned). You may set up a user preference table, that the user can configure with its preference. That's the best you can do.

    2. To swap the columns in screen painter you must use SBO 2005 (it's not available on previous release). What you must do is, click on the one column you want to swap and the other you want to swap and click on the swap button (on the left bottom of the page in the columns tab)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.