how to position records in detail table???

[krzys]

here is the following situation :

I have a dataset with two tables

this.daCustomers.Fill(dsData1, "Customers");
this.daOrders.Fill(dsData1, "Orders");

as You see there are tables from Northwind :)
these tables have a relation
this.dsData1.Relations.Add("CustOrd",
dsData1.Tables[0].Columns["Customerid"],
dsData1.Tables[1].Columns["Customerid"]);
this.dsData1.Relations.Add("OrdDet",
dsData1.Tables[1].Columns["OrderId"], dsData1.Tables[2].Columns["OrderId"]);

and currencymanager

crmCustomers =
(CurrencyManager)this.BindingContext[dsData1.Tables["Customers"]];

I bind these two tables to to datagrids
first one as master:

this.grdCustomers.DataSource = dsData1.Tables[0];

sencond one as detial:

this.grdOrders.DataSource = dsData1.Tables[0];
this.grdOrders.DataMember= "CustOrd";

finally I add a label with current position of active record in the
master table.

this.lblCustomers.Text=(crmCustomers.Position+1).T oString() + "/" +
crmCustomers.Count.ToString();

until now everything is clear and it works. Now please tell me how to
create similiar label which allows me to show position of active record
in the detail table ???? It must be very easy but I have been thinking
on it second day and I still have no ideas :( All tutorials and
examples show how to use currency manager to master table but I didn't
find any peace of code with currency manager in detail table

The next question is how to sort, filter and search this detial table
but this question I'm going to ask when I solve problem with positioning

thanks in advance for any help
K.

[Dmitriy Lapshin [C# / .NET MVP]]

Hi,

Won't something like the following work:

crmOrders =
(CurrencyManager)this.BindingContext[grdOrders.DataSource,
grdOrders.DataMember];

this.lblOrders.Text=(crmOrders.Position+1).ToStrin g() + "/" +
crmOrders.Count.ToString();

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

"krzys" <kr*********@XXgazeta.pl> wrote in message
news:cs**********@inews.gazeta.pl...

here is the following situation :

I have a dataset with two tables

this.daCustomers.Fill(dsData1, "Customers");
this.daOrders.Fill(dsData1, "Orders");

as You see there are tables from Northwind :)
these tables have a relation
this.dsData1.Relations.Add("CustOrd",
dsData1.Tables[0].Columns["Customerid"],
dsData1.Tables[1].Columns["Customerid"]);
this.dsData1.Relations.Add("OrdDet", dsData1.Tables[1].Columns["OrderId"],
dsData1.Tables[2].Columns["OrderId"]);

and currencymanager

crmCustomers =
(CurrencyManager)this.BindingContext[dsData1.Tables["Customers"]];

I bind these two tables to to datagrids
first one as master:

this.grdCustomers.DataSource = dsData1.Tables[0];

sencond one as detial:

this.grdOrders.DataSource = dsData1.Tables[0];
this.grdOrders.DataMember= "CustOrd";

finally I add a label with current position of active record in the master
table.

this.lblCustomers.Text=(crmCustomers.Position+1).T oString() + "/" +
crmCustomers.Count.ToString();

until now everything is clear and it works. Now please tell me how to
create similiar label which allows me to show position of active record in
the detail table ???? It must be very easy but I have been thinking on it
second day and I still have no ideas :( All tutorials and examples show
how to use currency manager to master table but I didn't find any peace of
code with currency manager in detail table

The next question is how to sort, filter and search this detial table but
this question I'm going to ask when I solve problem with positioning

thanks in advance for any help
K.