dataset relations

[Cdude]

I have three datatables in my dataset firstly a products then a
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.

[Ignacio Machin ( .NET/ C# MVP )]

On May 30, 9:44*am, Cdude <[e-mail]:

I have three datatables in my dataset firstly a products then a
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.

and your question is?

[Cdude]

On May 30, 3:54 pm, "Ignacio Machin ( .NET/ C# MVP )"
<[e-mail]:

On May 30, 9:44 am, Cdude <[e-mail]:

I have three datatables in my dataset firstly a products then a
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.

and your question is?

Is that i cant display all the stock items linked to a product

[Cdude]

example my product code is 22

in the stocklink table is prodcode;stockcode;qty
22 8888 1
22 9999 2

in the stock table code; desc ;qty
8888 item1 12
9999 item2 10

now when i select product with code 22 i want to display item1 and
item2 in a grid

[Cdude]

How do i display them all

[Ignacio Machin ( .NET/ C# MVP )]

On May 30, 10:10*am, Cdude <[e-mail]:

How do i display them all

display them where?

You can use several controls for it, like a grid, a tree, etc

also is this a web or a win app?

[Ignacio Machin ( .NET/ C# MVP )]

On May 30, 10:03*am, Cdude <[e-mail]:

On May 30, 3:54 pm, "Ignacio Machin ( .NET/ C# MVP )"

<[e-mail]:

On May 30, 9:44 am, Cdude <[e-mail]:

I have three datatables in my dataset firstly a products then a
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.

and your question is?

Is that i cant display all the stock items linked to a product

very easy, if you have a FK relationship you can use
DataRow.GetChildRows()
if not you can create a dataview of the child table