Re: Typed DataSet Navigation (Multiple Tables)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Cor,

Thanks for example. However, this really doesn't meet my needs. I can
do this by binding the DataSet to controls (2 data grids) but I need to
be able to do this in code as this is for a windows service.

I need to be able to filter one of the tables and get a view from the
other table(s) that will only contain associated records.

Best regards,

Rick

Cor Ligthert [MVP] wrote:
Rick,

With a version 2.0 typed dataset this is a piece of cake.

With 1.1 I assume that most people have taken the route from the non typed
dataset (it is not changed for nothing in my idea).

I thought that this sample shows a little bit your needs

http://www.vb-tips.com/default.aspx?ID=cb1408ff-030d-4ea8-80b1-af26354b1fa0

I hope this helps,

Cor

<rryerson@xxxxxxxxxx> schreef in bericht
news:1150145592.200147.257100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I don't know if my terminology is correct so please bear with me.

I have a Typed DataSet that contains a number of related Tables. I am
trying to filter the parent table, child table and then traverse a
grand child table with the expected result of the only grand child
records in the data view would be those related to the Parent/Child and
pass through the filter.

I can't seem to do this.

I could possibly be able to extend an answer that is based on Northwind
Orders and order Details. I.e. I want to see only Order Detail records
in the Dataview that pass the filter applied to the master Orders
(Orders.EmployeeId = 6 [I only want to see Order Details that relate to
Employee 5])

If someone could please help me understand the process of setting this
up, I would greatly appreciate it.

.NET 1.1 or 1.0.


Best regards,

Rick


.

Relevant Pages

  • Typed DataSet Navigation (Multiple Tables)
    ... grand child table with the expected result of the only grand child ... pass through the filter. ... Orders and order Details. ... I want to see only Order Detail records ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed DataSet Navigation (Multiple Tables)
    ... I have a Typed DataSet that contains a number of related Tables. ... grand child table with the expected result of the only grand child ... pass through the filter. ... Orders and order Details. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed DataSet Navigation (Multiple Tables)
    ... Please keep it with one message thread, ... I need to be able to filter one of the tables and get a view from the ... I have a Typed DataSet that contains a number of related Tables. ... Orders and order Details. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed DataSet Navigation (Multiple Tables)
    ... But applying a filter to the parent view will contain ... I just want to see and manipulate the order details. ... With a version 2.0 typed dataset this is a piece of cake. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: serious prob pls help
    ... i read this and i think i am lost. ... Refresh the subform for combo box rowsource to be loaded [or requery for the ... As i don't know of any way to filter the rowsource of a combo box your ... to filter the order details to the customer's order, ...
    (microsoft.public.access.formscoding)