Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1035
Binding in multiband grid
posted

Hi,

 

There are 3 tables in the DB: AàBàC

(A is the father, B is the son, C is the grandson).

 

I have 2 grids: grdA and grdC.

grdA has 2 Bands: band0 displays the data of tableA, band1 displays the data of table B.

grdC displays the data if table C.

 

I want that when I select a row in grdA-band1, the data in grdC will be updated accordingly.

Problem is that the data in grdC is updated according to the selected row in grdA-band0.

 

The grids are bounded to the tables in that way:

 

bsA – hold the data of table A.

grdA.DataSource = bsA;

 

bsB.DataSource = bsA;

bsB.DataMember = "B";

 

bsC.DataSource = bsB;

bsC.DataMember = "C";

grdC.DataSource = bsC;

 

Thanks ahead,

Yael