Hello,
I am using vb.net. I have a dataset with 2 tables, joined by a relationship. I need to create a dataview that shows all of the child records, but with one field from the corresponding parent record.
The parent table is named quantity (PK of part_no) and the child table is detail (FK of JobName11). Here is what I have now, that only shows all of the children:
Dim ModelDV As DataView
ModelDV = New DataView(ds1.Tables("detail"))
If somebody could tell me how to create this view preserving the relationship and including the "count" field of the quantity table, I would greatly appreciate it. Thanks a ton.
I am using vb.net. I have a dataset with 2 tables, joined by a relationship. I need to create a dataview that shows all of the child records, but with one field from the corresponding parent record.
The parent table is named quantity (PK of part_no) and the child table is detail (FK of JobName11). Here is what I have now, that only shows all of the children:
Dim ModelDV As DataView
ModelDV = New DataView(ds1.Tables("detail"))
If somebody could tell me how to create this view preserving the relationship and including the "count" field of the quantity table, I would greatly appreciate it. Thanks a ton.