How to change the order of datagrid columns?

Question

0.00/5 (No votes)

See more:

Hi,

How to change the order of datagrid columns? One think I would like to mention here is it's datagrid not the datagridview. So DisplayIndex property is not available which is available in datagridview. And AutoGeneratedColumns is set to false. And I don't want to set it to true(as there are limitations to use this).

Thanks,
Surendra

Posted 6-Oct-13 22:58pm

Surendra Patil

Add a Solution

Comments

BulletVictim 7-Oct-13 5:08am

Where would you like to change the order of the columns? On run time with drag and drop? or just the initial order when it is populated?

Are you selecting the data for the datagrid from a database? Assuming you do you could just change the select statement.

Surendra Patil 7-Oct-13 5:45am

Hi BulletVictim,
Here is the scenario,

I am populating the data from the database. I want have the functionality where user is capable of selecting the columns which user want to see and change the order according to his context/preference. I am able to hide /unhide the column according to the user selection. But I am not able to change the order.

Example:

Let's say, I have Column1,Column2, Column3, Column4, Column5 from the database and I have some icons like 'View', 'Print' in one column which will be fixed at left most side. Now user want to see Column1 Column2 Column3 with tools in the order Column3 Column1 Column2. I can't set the autogeneratecolumns to true. So what should be done on this?

BulletVictim 7-Oct-13 5:55am

Do you currently have any type of way for the user to select in which order they want it?
Because you say you cant set autogeneratecolumns to true, I keep on thinking that you will need to look at the select statement. Now that being said, with the ordering from the user in place perhaps using that order to write the select statement?

Surendra Patil 7-Oct-13 6:10am

I have a view which populates the data. I have provided the modalpopup with datagrid where user will select his context.

I can's set autogeneratecolumns to true bcaz there are some tools like print option, view option which are bounded to the one column. Which will be fixed always. And for the printer option they have used image of the print. So I don't think i can bound those images at code behind.

What i was thinking initially, bound the all the columns to the datagrid and then hide/unhide or change the order by some property of datagrid. Means there are some properties like 'DisplayIndex' in datagridview where we can select the index of the column.

BulletVictim 7-Oct-13 6:37am

Currently how do the user select the columns to display? Is it with checkboxes or comboboxes?
I'm thinking use comboboxes in a set order, listing all the columns that could be displayed.
Then use your select statement with the comboboxes selected item.

For instance. Have the comboboxes populated with column 1 until column x
Have a combobox for each column.
Your select statement is then something like, select combobox1.seleectedItem.Tostring(), combobox2.seleectedItem.Tostring() FROM Table

Surendra Patil 7-Oct-13 7:12am

Ok..I agree with you on this. But the thing is, I am using boundcolumn instead of auto generating the column. So boundcolumn will always show the data in specific order not according to user.

BulletVictim 7-Oct-13 7:26am

Are you using the boundcolumn for all the columns or just the controls that are to the left?
Because you can use both bound column and generated columns as far as I know.
So why not use both?

Surendra Patil 7-Oct-13 7:37am

I am using boundcolumns for all the columns. And i tried to use both but the thing is, the formatting like date formatting and bounding of two values from the database in the same column, and use of webusercontrol can be done with boundcolumn not dynamically. As I am doing enhancement on the client code, so very limited options are available :(

BulletVictim 7-Oct-13 7:50am

Then I am sorry I do not know how to take this any further at the moment. especially with a datagrid, not with boundcolumns at least.
Remove the Solution at the bottom here that is not correct so that your question can go back on the unanswered list, perhaps someone else will be able to help you better than I could.
Best of luck

Surendra Patil 7-Oct-13 7:58am

Ok..ya I am also in difficult situation. But thanks for your time. Do tell if you get any solution on this. And how to remove solution as I am not finding any way to remove

Surendra Patil 8-Oct-13 5:08am

Hey hi, requirement is changed now. Now the requirement is, without affecting current binding, I need to add few new columns and whose order will be decide by user selection. Can we use any method like AddAt or Add.

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)

Adrishya · Answer 1 · 2013-10-06T23:23:00

Solution 1

Try this
It may help you

http://msdn.microsoft.com/en-us/library/vstudio/wkfe535h%28v=vs.100%29.aspx[^]

Posted 6-Oct-13 23:23pm

Adrishya

Comments

Surendra Patil 7-Oct-13 6:17am

Hey Saroj, I can't use this. Because I am using datagrid not datagridview.

BulletVictim 7-Oct-13 8:39am

Please Remove this solution as it is not correct pertaining to Surendra's question so that it can be added back to the unanswered questions to help him resolve this issue