WinGrid databinding problem | Infragistics Forums

State See Verified Answer
Replies 6 replies
Subscribers 6 subscribers
Views 1234994 views
Users 0 members are here

UltraGrid

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

Parents

469350

Verified Answer
Offline Mike Saltzman posted over 15 years ago

What exactly are you doing to the DataSet? It sounds to me like either:
A) The grid is still holding on to it's old layout. In which case, you should be able to get around this by calling grid.Layout.Reset.
B) Something is wrong with the data source and it doesn't actually have any columns in the child band. But since you didn't say what you are doing, it's hard to tell if this is the case.
Cancel
Reply

Reject Answer

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

Reply

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

Children

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