Building a dynamic grid on the fly? | Infragistics Forums

State See Verified Answer
Replies 5 replies
Subscribers 7 subscribers
Views 914748 views
Users 0 members are here

UltraGrid

260

Building a dynamic grid on the fly?

Nick posted over 16 years ago

Could the following be accomplished with the UltraGrid control and how (example, documentation, etc...)Basically I'll have a form with a single grid, the user will select items from a combo box which then populates the UltraGrid, and each item could have a view with a different column layout.1. Populate an UltraGrid with a given view, and have the grid layout reflect the views columns. If user selects a different view, have the grid reflect its column layout, both views have different number of columns, in a sense the grid would have to be dynamic in its layout based on whatever view is used as it's data source.2. Hide columns in a grid, is there a way to select on a column at runtime in the grid and hide it? Any information is greatly appreciated. Best Regards, Nick

Parents

469350

Verified Answer
Offline Mike Saltzman posted over 16 years ago

Hi Nick,
Everything you have here sounds not only doable, but pretty easy. All you would have to do is set the DataSource on the grid and it will automatically pick up the structure of the data source you assigned. You could use the Load and Save methods on the grid's DisplayLayout to save the last layout for each different view, so that when the user switches away from a view and back, the grid would maintain the column sizing, position, sorting, etc. that they had the last time they viewed it.
Regarding the hiding of columns, you can use the ColumnChooser for this. The easiest way to do this is touse the RowSelectorHeaderStyle property and set it up as a ColumnChooser button. Then the users can click it and it brings up a list of the column that they can show / hide just like Microsoft Outlook has.
Cancel
Reply

Reject Answer

Cancel

Reply

260

Nick posted over 16 years ago in reply to Mike Saltzman

MIke -

Thanks, this helps greatly, the main purpose of the form is to allow the user to export to the clip board the data in the grid.

I do have another question. Let's say I apply all suggestion and the user filters the data using columns filters and hides a couple of columns in the process. What the best way to copy to the clip board only the rows and columns currect displayed in the grid? Again many thanks. BTW, we are using v 3.1 of the UltraGrid control.

Nick
Cancel
Reply

Cancel

Children

469350

Verified Answer
Offline Mike Saltzman posted over 16 years ago in reply to Nick Smith

Wow, v3.1 is pretty old. I'm not sure what kind of funtionality might not have been available in that version.
You would have to loop through the rows. In the current version, you could use the Rows.GetFilteredInNonGroupByRow method to get the rows, But in v3.1, you probably have to loop through every row and check the HiddenResolved property. As for the columns, you should be able to use GetFirstVisibleColumn on the Band and then use GetRelatedVisibleColumn to get the next column until you hit the end.
Cancel
Reply

Reject Answer

Cancel
260

Nick posted over 16 years ago in reply to Nick Smith

Nick -

I agree, manegemnt does not wan to upgrade at the moment, typical right? So I'm stuck with v3.1 for now, I'm wondering if any of the functionality I need in my initial post is doable in v3.1.

Thanks,

Nick A.
Cancel
Reply

Cancel
3186

Offline Nick Smith posted over 16 years ago in reply to Nick

Hello Nick,

Gosh you are missing out on so many great features added since 3.1. Might be worthwhile to download a trial version and see what all has been added. I started using the product just a little before that version and I can't imagine not having all the neat capabilities since then. There is an example in the samples explorer for the grid of being able to copy a rectangle of cells and paste into Excel. This ability was added I believe around the 5.3 or slightly after timeframe.

Nick S.
Cancel
Reply

Cancel