dataset relations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cdude - 30 May 2008 14:44 GMT

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.

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 30 May 2008 14:54 GMT

> 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
[quoted text clipped - 6 lines]
> the product it only displays one of the linked items not all of them i
> need them all.

and your question is?

Reply to this Message

Cdude - 30 May 2008 15:03 GMT

On May 30, 3:54 pm, "Ignacio Machin ( .NET/ C# MVP )"
<ignacio.mac...@gmail.com> wrote:

> > 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
[quoted text clipped - 8 lines]
>
> and your question is?

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

Reply to this Message

Cdude - 30 May 2008 15:08 GMT

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

Reply to this Message

Cdude - 30 May 2008 15:10 GMT

How do i display them all

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 30 May 2008 16:15 GMT

> 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?

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 30 May 2008 16:16 GMT

> On May 30, 3:54 pm, "Ignacio Machin ( .NET/ C# MVP )"
>
[quoted text clipped - 14 lines]
>
> 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

Reply to this Message

dataset relations

Free Magazines