? about currencymanager & relations

[D]

hi

I have a form with 2 datagrids showing related table data in a master /
child or order / order details type relationship. I would like to auto
select the row in the order details table which contains the highest priced
item. My thoughts were to get the currency manager from the orderdetails
table and iterate thru each row and keep track of the highest item and row
and select that when done. I have found that for some reason the currency
manager of the order details table is always a position 0 regardless of what
is actually showing in the order details datagrid.

What am I doing wrong?

Thanks !!

[Nicholas Paldino [.NET/C# MVP]]

D,

Are you sure you are getting the correct currency mananger? When you
are getting the currency manager, you need to get the manager which is
returned to you by using the DataRelation as the key, not the child data
table (which is why the position is probably always zero).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:uF******** ******@TK2MSFTN GP15.phx.gbl...

hi

I have a form with 2 datagrids showing related table data in a master /
child or order / order details type relationship. I would like to auto
select the row in the order details table which contains the highest
priced item. My thoughts were to get the currency manager from the
orderdetails table and iterate thru each row and keep track of the highest
item and row and select that when done. I have found that for some reason
the currency manager of the order details table is always a position 0
regardless of what is actually showing in the order details datagrid.

What am I doing wrong?

Thanks !!

[D]

I thought of that but I must have the syntax wrong because I'm getting
exceptions

_dsTests.Relati ons.Add("MyTest Relation",
_dsCombinations .Tables["Tests"].Columns["ID"],
_dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
later...
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["MyTestRelation "];
cast not valid
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
cast not valid

Thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

D,

Are you sure you are getting the correct currency mananger? When you
are getting the currency manager, you need to get the manager which is
returned to you by using the DataRelation as the key, not the child data
table (which is why the position is probably always zero).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:uF******** ******@TK2MSFTN GP15.phx.gbl...

hi

I have a form with 2 datagrids showing related table data in a master /
child or order / order details type relationship. I would like to auto
select the row in the order details table which contains the highest
priced item. My thoughts were to get the currency manager from the
orderdetails table and iterate thru each row and keep track of the
highest item and row and select that when done. I have found that for
some reason the currency manager of the order details table is always a
position 0 regardless of what is actually showing in the order details
datagrid.

What am I doing wrong?

Thanks !!

[Nicholas Paldino [.NET/C# MVP]]

D,

Don't pass the string with the data relation name to the BindingContext.
Rather, pass the data relation itself, and you should get it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eX******** ******@TK2MSFTN GP12.phx.gbl...

I thought of that but I must have the syntax wrong because I'm getting
exceptions

_dsTests.Relati ons.Add("MyTest Relation",
_dsCombinations .Tables["Tests"].Columns["ID"],
_dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
later...
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["MyTestRelation "];
cast not valid
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
cast not valid

Thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

D,

Are you sure you are getting the correct currency mananger? When you
are getting the currency manager, you need to get the manager which is
returned to you by using the DataRelation as the key, not the child data
table (which is why the position is probably always zero).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:uF******** ******@TK2MSFTN GP15.phx.gbl...

hi

I have a form with 2 datagrids showing related table data in a master /
child or order / order details type relationship. I would like to auto
select the row in the order details table which contains the highest
priced item. My thoughts were to get the currency manager from the
orderdetails table and iterate thru each row and keep track of the
highest item and row and select that when done. I have found that for
some reason the currency manager of the order details table is always a
position 0 regardless of what is actually showing in the order details
datagrid.

What am I doing wrong?

Thanks !!

[D]

I'm afraid I'm still getting an invalid cast exception error when trying to
do

CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];

I have a feeling that I'm going to have to get current id from the Tests
table and seek out the highest totals in the DailyTotals manually.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:uC******** ******@TK2MSFTN GP12.phx.gbl...

D,

Don't pass the string with the data relation name to the
BindingContext. Rather, pass the data relation itself, and you should get
it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eX******** ******@TK2MSFTN GP12.phx.gbl...

I thought of that but I must have the syntax wrong because I'm getting
exceptions

_dsTests.Relati ons.Add("MyTest Relation",
_dsCombinations .Tables["Tests"].Columns["ID"],
_dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
later...
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["MyTestRelation "];
cast not valid
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
cast not valid

Thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

D,

Are you sure you are getting the correct currency mananger? When you
are getting the currency manager, you need to get the manager which is
returned to you by using the DataRelation as the key, not the child data
table (which is why the position is probably always zero).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:uF******** ******@TK2MSFTN GP15.phx.gbl...
hi

I have a form with 2 datagrids showing related table data in a master /
child or order / order details type relationship. I would like to auto
select the row in the order details table which contains the highest
priced item. My thoughts were to get the currency manager from the
orderdetails table and iterate thru each row and keep track of the
highest item and row and select that when done. I have found that for
some reason the currency manager of the order details table is always a
position 0 regardless of what is actually showing in the order details
datagrid.

What am I doing wrong?

Thanks !!

[Nicholas Paldino [.NET/C# MVP]]

D,

What is the type that is returned when you key on the relation? What
does the debugger tell you?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl...

I'm afraid I'm still getting an invalid cast exception error when trying
to do

CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];

I have a feeling that I'm going to have to get current id from the Tests
table and seek out the highest totals in the DailyTotals manually.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:uC******** ******@TK2MSFTN GP12.phx.gbl...

D,

Don't pass the string with the data relation name to the
BindingContext. Rather, pass the data relation itself, and you should get
it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eX******** ******@TK2MSFTN GP12.phx.gbl...

I thought of that but I must have the syntax wrong because I'm getting
exceptions

_dsTests.Relati ons.Add("MyTest Relation",
_dsCombinations .Tables["Tests"].Columns["ID"],
_dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
later...
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["MyTestRelation "];
cast not valid
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
cast not valid

Thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
D,

Are you sure you are getting the correct currency mananger? When
you are getting the currency manager, you need to get the manager which
is returned to you by using the DataRelation as the key, not the child
data table (which is why the position is probably always zero).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:uF******** ******@TK2MSFTN GP15.phx.gbl...
> hi
>
> I have a form with 2 datagrids showing related table data in a master
> / child or order / order details type relationship. I would like to
> auto select the row in the order details table which contains the
> highest priced item. My thoughts were to get the currency manager from
> the orderdetails table and iterate thru each row and keep track of the
> highest item and row and select that when done. I have found that for
> some reason the currency manager of the order details table is always
> a position 0 regardless of what is actually showing in the order
> details datagrid.
>
> What am I doing wrong?
>
> Thanks !!
>
>
>
>
>
>
>
>

[D]

I'm not sure where to look for that, I mean I catch the exception but I
don't see where it reads about the actual object. After reading MSDN a bit I
tried casting it to a propertymanager which workd but I'm not sure what to
do next. More reading I guess.

Any thoughts?

Thanks for your help.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:ek******** ******@TK2MSFTN GP12.phx.gbl...

D,

What is the type that is returned when you key on the relation? What
does the debugger tell you?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl...

I'm afraid I'm still getting an invalid cast exception error when trying
to do

CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];

I have a feeling that I'm going to have to get current id from the Tests
table and seek out the highest totals in the DailyTotals manually.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:uC******** ******@TK2MSFTN GP12.phx.gbl...

D,

Don't pass the string with the data relation name to the
BindingContext. Rather, pass the data relation itself, and you should
get it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eX******** ******@TK2MSFTN GP12.phx.gbl...
I thought of that but I must have the syntax wrong because I'm getting
exception s

_dsTests.Relati ons.Add("MyTest Relation",
_dsCombinations .Tables["Tests"].Columns["ID"],
_dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
later...
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["MyTestRelation "];
cast not valid
CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
cast not valid

Thanks
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
> D,
>
> Are you sure you are getting the correct currency mananger? When
> you are getting the currency manager, you need to get the manager
> which is returned to you by using the DataRelation as the key, not the
> child data table (which is why the position is probably always zero).
>
> Hope this helps.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mv*@spam.guard. caspershouse.co m
>
> "D" <Da**@nothing.n et> wrote in message
> news:uF******** ******@TK2MSFTN GP15.phx.gbl...
>> hi
>>
>> I have a form with 2 datagrids showing related table data in a master
>> / child or order / order details type relationship. I would like to
>> auto select the row in the order details table which contains the
>> highest priced item. My thoughts were to get the currency manager
>> from the orderdetails table and iterate thru each row and keep track
>> of the highest item and row and select that when done. I have found
>> that for some reason the currency manager of the order details table
>> is always a position 0 regardless of what is actually showing in the
>> order details datagrid.
>>
>> What am I doing wrong?
>>
>> Thanks !!
>>
>>
>>
>>
>>
>>
>>
>>
>
>

[Nicholas Paldino [.NET/C# MVP]]

D,

Did you try looking in the debugger? Before you make the assignment,
paste:

this.BindingCon text[_dsTests.Relati ons["MyTestRelation "]]

Into the watch window.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:ex******** ******@TK2MSFTN GP10.phx.gbl...

I'm not sure where to look for that, I mean I catch the exception but I
don't see where it reads about the actual object. After reading MSDN a bit
I tried casting it to a propertymanager which workd but I'm not sure what
to do next. More reading I guess.

Any thoughts?

Thanks for your help.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:ek******** ******@TK2MSFTN GP12.phx.gbl...

D,

What is the type that is returned when you key on the relation? What
does the debugger tell you?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl...

I'm afraid I'm still getting an invalid cast exception error when trying
to do

CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];

I have a feeling that I'm going to have to get current id from the Tests
table and seek out the highest totals in the DailyTotals manually.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:uC******** ******@TK2MSFTN GP12.phx.gbl...
D,

Don't pass the string with the data relation name to the
BindingContext. Rather, pass the data relation itself, and you should
get it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eX******** ******@TK2MSFTN GP12.phx.gbl...
>I thought of that but I must have the syntax wrong because I'm getting
>exceptio ns
>
> _dsTests.Relati ons.Add("MyTest Relation",
> _dsCombinations .Tables["Tests"].Columns["ID"],
> _dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
> later...
> CurrencyManager myCurrencyManag er =
> (CurrencyManage r)this.BindingC ontext["MyTestRelation "];
> cast not valid
> CurrencyManager myCurrencyManag er =
> (CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
> cast not valid
>
> Thanks
>
>
> "Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
>> D,
>>
>> Are you sure you are getting the correct currency mananger? When
>> you are getting the currency manager, you need to get the manager
>> which is returned to you by using the DataRelation as the key, not
>> the child data table (which is why the position is probably always
>> zero).
>>
>> Hope this helps.
>>
>>
>> --
>> - Nicholas Paldino [.NET/C# MVP]
>> - mv*@spam.guard. caspershouse.co m
>>
>> "D" <Da**@nothing.n et> wrote in message
>> news:uF******** ******@TK2MSFTN GP15.phx.gbl...
>>> hi
>>>
>>> I have a form with 2 datagrids showing related table data in a
>>> master / child or order / order details type relationship. I would
>>> like to auto select the row in the order details table which
>>> contains the highest priced item. My thoughts were to get the
>>> currency manager from the orderdetails table and iterate thru each
>>> row and keep track of the highest item and row and select that when
>>> done. I have found that for some reason the currency manager of the
>>> order details table is always a position 0 regardless of what is
>>> actually showing in the order details datagrid.
>>>
>>> What am I doing wrong?
>>>
>>> Thanks !!
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>

[D]

its propertymanager .

and its bindtype is DataRelation.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:uH******** ********@TK2MSF TNGP15.phx.gbl. ..

D,

Did you try looking in the debugger? Before you make the assignment,
paste:

this.BindingCon text[_dsTests.Relati ons["MyTestRelation "]]

Into the watch window.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:ex******** ******@TK2MSFTN GP10.phx.gbl...

I'm not sure where to look for that, I mean I catch the exception but I
don't see where it reads about the actual object. After reading MSDN a
bit I tried casting it to a propertymanager which workd but I'm not sure
what to do next. More reading I guess.

Any thoughts?

Thanks for your help.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:ek******** ******@TK2MSFTN GP12.phx.gbl...

D,

What is the type that is returned when you key on the relation? What
does the debugger tell you?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl...
I'm afraid I'm still getting an invalid cast exception error when
trying to do

CurrencyManager myCurrencyManag er =
(CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];

I have a feeling that I'm going to have to get current id from the
Tests table and seek out the highest totals in the DailyTotals
manually.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
wrote in message news:uC******** ******@TK2MSFTN GP12.phx.gbl...
> D,
>
> Don't pass the string with the data relation name to the
> BindingContext. Rather, pass the data relation itself, and you should
> get it.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mv*@spam.guard. caspershouse.co m
>
> "D" <Da**@nothing.n et> wrote in message
> news:eX******** ******@TK2MSFTN GP12.phx.gbl...
>>I thought of that but I must have the syntax wrong because I'm getting
>>exception s
>>
>> _dsTests.Relati ons.Add("MyTest Relation",
>> _dsCombinations .Tables["Tests"].Columns["ID"],
>> _dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
>> later...
>> CurrencyManager myCurrencyManag er =
>> (CurrencyManage r)this.BindingC ontext["MyTestRelation "];
>> cast not valid
>> CurrencyManager myCurrencyManag er =
>> (CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
>> cast not valid
>>
>> Thanks
>>
>>
>> "Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
>> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
>>> D,
>>>
>>> Are you sure you are getting the correct currency mananger? When
>>> you are getting the currency manager, you need to get the manager
>>> which is returned to you by using the DataRelation as the key, not
>>> the child data table (which is why the position is probably always
>>> zero).
>>>
>>> Hope this helps.
>>>
>>>
>>> --
>>> - Nicholas Paldino [.NET/C# MVP]
>>> - mv*@spam.guard. caspershouse.co m
>>>
>>> "D" <Da**@nothing.n et> wrote in message
>>> news:uF******** ******@TK2MSFTN GP15.phx.gbl...
>>>> hi
>>>>
>>>> I have a form with 2 datagrids showing related table data in a
>>>> master / child or order / order details type relationship. I would
>>>> like to auto select the row in the order details table which
>>>> contains the highest priced item. My thoughts were to get the
>>>> currency manager from the orderdetails table and iterate thru each
>>>> row and keep track of the highest item and row and select that when
>>>> done. I have found that for some reason the currency manager of the
>>>> order details table is always a position 0 regardless of what is
>>>> actually showing in the order details datagrid.
>>>>
>>>> What am I doing wrong?
>>>>
>>>> Thanks !!
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

[Nicholas Paldino [.NET/C# MVP]]

D,

That's not right then. What exactly is your data source? The property
manager is used when you bind to objects, not lists.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

its propertymanager .

and its bindtype is DataRelation.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:uH******** ********@TK2MSF TNGP15.phx.gbl. ..

D,

Did you try looking in the debugger? Before you make the assignment,
paste:

this.BindingCon text[_dsTests.Relati ons["MyTestRelation "]]

Into the watch window.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:ex******** ******@TK2MSFTN GP10.phx.gbl...

I'm not sure where to look for that, I mean I catch the exception but I
don't see where it reads about the actual object. After reading MSDN a
bit I tried casting it to a propertymanager which workd but I'm not sure
what to do next. More reading I guess.

Any thoughts?

Thanks for your help.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in message news:ek******** ******@TK2MSFTN GP12.phx.gbl...
D,

What is the type that is returned when you key on the relation?
What does the debugger tell you?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"D" <Da**@nothing.n et> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl...
> I'm afraid I'm still getting an invalid cast exception error when
> trying to do
>
> CurrencyManager myCurrencyManag er =
> (CurrencyManage r)this.BindingC ontext[_dsTests.Relati ons["MyTestRelation "]];
>
> I have a feeling that I'm going to have to get current id from the
> Tests table and seek out the highest totals in the DailyTotals
> manually.
>
>
> "Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
> wrote in message news:uC******** ******@TK2MSFTN GP12.phx.gbl...
>> D,
>>
>> Don't pass the string with the data relation name to the
>> BindingContext. Rather, pass the data relation itself, and you should
>> get it.
>>
>>
>> --
>> - Nicholas Paldino [.NET/C# MVP]
>> - mv*@spam.guard. caspershouse.co m
>>
>> "D" <Da**@nothing.n et> wrote in message
>> news:eX******** ******@TK2MSFTN GP12.phx.gbl...
>>>I thought of that but I must have the syntax wrong because I'm
>>>gettin g exceptions
>>>
>>> _dsTests.Relati ons.Add("MyTest Relation",
>>> _dsCombinations .Tables["Tests"].Columns["ID"],
>>> _dsCombinations .Tables["DailyTotal s"].Columns["ID"]);
>>> later...
>>> CurrencyManager myCurrencyManag er =
>>> (CurrencyManage r)this.BindingC ontext["MyTestRelation "];
>>> cast not valid
>>> CurrencyManager myCurrencyManag er =
>>> (CurrencyManage r)this.BindingC ontext["Tests.MyTestRe lation"];
>>> cast not valid
>>>
>>> Thanks
>>>
>>>
>>> "Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
>>> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
>>>> D,
>>>>
>>>> Are you sure you are getting the correct currency mananger?
>>>> When you are getting the currency manager, you need to get the
>>>> manager which is returned to you by using the DataRelation as the
>>>> key, not the child data table (which is why the position is
>>>> probably always zero).
>>>>
>>>> Hope this helps.
>>>>
>>>>
>>>> --
>>>> - Nicholas Paldino [.NET/C# MVP]
>>>> - mv*@spam.guard. caspershouse.co m
>>>>
>>>> "D" <Da**@nothing.n et> wrote in message
>>>> news:uF******** ******@TK2MSFTN GP15.phx.gbl...
>>>>> hi
>>>>>
>>>>> I have a form with 2 datagrids showing related table data in a
>>>>> master / child or order / order details type relationship. I would
>>>>> like to auto select the row in the order details table which
>>>>> contains the highest priced item. My thoughts were to get the
>>>>> currency manager from the orderdetails table and iterate thru each
>>>>> row and keep track of the highest item and row and select that
>>>>> when done. I have found that for some reason the currency manager
>>>>> of the order details table is always a position 0 regardless of
>>>>> what is actually showing in the order details datagrid.
>>>>>
>>>>> What am I doing wrong?
>>>>>
>>>>> Thanks !!
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>