WinGrid databinding problem | Infragistics Forums

735

WinGrid databinding problem

Zongwen posted over 15 years ago

I have DataSet with 2 tables (Table A & B) and a parent-child relationship relating these two tables. First time i set the datasource of the grid to Table A, then the grid will show two bands, with Band 0 showing data in Table A and Band1 showing data in Table B. The problem happens when i try to restructure table B, reset the relationship of A-B and reset the grid's datasource to Table A. It still has two bands. But the Band 1 doesn't have any columns. I noticed that Band 0 is linked to Table A and Band 1 is linked to the relationship name. What is the correct way to reset the data source of the grid with the datatables containing new data schema. Thanks. Zongwen

469350

Offline Mike Saltzman posted over 15 years ago in reply to Zongwen

Oh, that's a nice solution. You don't even really need to change the relationship in that case. You could set up your DataSet with two relationship and then just use the Hidden property on the band in the grid to hide one band or the other.
Cancel
Reply

Cancel
735

Zongwen posted over 15 years ago in reply to Mike Saltzman

I tried to set DataSource to null and it still didn't work. Anyway, I decided to create two separate datatables and link one of them dynamically to the parent table. When I build new relationship, i delete the previous one. In this way, only one relationship is linked to the parent table. This way seems to work fine for me. Thanks.
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 15 years ago in reply to Zongwen

The BindingManager probably doesn't have notifications for the kind of thing you are doing. Try setting the grid's DataSource to null and then back again.
Cancel
Reply

Cancel
735

Zongwen posted over 15 years ago in reply to Mike Saltzman

When I debug more, I found out that since the data source is not removed yet, after I delete the relationship between the two tables, change the schema of the child table, then relink the two tables, the column count of the second band is already zero. Then when I call the databind function, the grid doesn't refresh the layout and still have the second band with no columns. I tried layout.Reset and it didn't work. Thanks. Zongwen
Cancel
Reply

Cancel
735

Zongwen posted over 15 years ago in reply to Mike Saltzman

What I am trying to do is to switch the layout of second band (Band 1) on the fly (through toolstripmenuItem click). Second band contains a matrix of data. User what a difference view of the data by a 90 degree rotation of the matrix (all columns in the datatable will be displayed as rows in Band 1). I was going to accomplish this by restructure the datatable accordingly and repopulate the datatable and relink it with parent table. I checked that the outcome datatable does carry all the data columns. But for some reason the second band won't derive and generate any grid columns (Band.Columns.Count is 0). Zongwen
Cancel
Reply

Cancel