DataBinding for two comboboxes

[david.kao]

Hi All:
I have a dataset contains two tables, one parent child relation between two
tables. I have no trouble to bind parent table to a combobox, relation to a
win grid control. But I am having trouble to bind relation into another combo
box. DotNet does not give me a run time error. But it did not perform the way
I am expecting.

Thanks in advance

DK

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

DK,

Are you binding to the relation for the combobox as well? Can you show
some code, as well as what your expectations are?
"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:A8******** *************** ***********@mic rosoft.com...

Hi All:
I have a dataset contains two tables, one parent child relation between
two
tables. I have no trouble to bind parent table to a combobox, relation to
a
win grid control. But I am having trouble to bind relation into another
combo
box. DotNet does not give me a run time error. But it did not perform the
way
I am expecting.

Thanks in advance

DK

[david.kao]

combo1.DataSour ce = parent table;
combo1.DisplayM ember = col name from parent table;
combo1.ValueMem ber = col name from parent table;

combo2.DataSour ce = child table;
combo2.DisplayM ember = col name from child table;
combo2.ValueMem ber = col name from child table;
combo2.DataBind ings.Add("Selec tedValue", parent table, name of relation);

when the user changed value in combo1, the code should refresh data in combo2.
However, I can have other way around this issue. I just like to know I can
use relation to do this kind of binding, like I often do for Combox and
DataGrid (grid.SetDataBi nding(parent table, name of relation)).

Thanks

"Nicholas Paldino [.NET/C# MVP]" wrote:

DK,

Are you binding to the relation for the combobox as well? Can you show
some code, as well as what your expectations are?
"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:A8******** *************** ***********@mic rosoft.com...

Hi All:
I have a dataset contains two tables, one parent child relation between
two
tables. I have no trouble to bind parent table to a combobox, relation to
a
win grid control. But I am having trouble to bind relation into another
combo
box. DotNet does not give me a run time error. But it did not perform the
way
I am expecting.

Thanks in advance

DK

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

David,

Set the data source of combo2 to the relation itself, not to the child
table.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:AB******** *************** ***********@mic rosoft.com...

combo1.DataSour ce = parent table;
combo1.DisplayM ember = col name from parent table;
combo1.ValueMem ber = col name from parent table;

combo2.DataSour ce = child table;
combo2.DisplayM ember = col name from child table;
combo2.ValueMem ber = col name from child table;
combo2.DataBind ings.Add("Selec tedValue", parent table, name of relation);

when the user changed value in combo1, the code should refresh data in
combo2.
However, I can have other way around this issue. I just like to know I can
use relation to do this kind of binding, like I often do for Combox and
DataGrid (grid.SetDataBi nding(parent table, name of relation)).

Thanks

"Nicholas Paldino [.NET/C# MVP]" wrote:

DK,

Are you binding to the relation for the combobox as well? Can you
show
some code, as well as what your expectations are?
"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:A8******** *************** ***********@mic rosoft.com...

> Hi All:
> I have a dataset contains two tables, one parent child relation between
> two
> tables. I have no trouble to bind parent table to a combobox, relation
> to
> a
> win grid control. But I am having trouble to bind relation into another
> combo
> box. DotNet does not give me a run time error. But it did not perform
> the
> way
> I am expecting.
>
> Thanks in advance
>
> DK
>

[david.kao]

No this does not work.

Here is what I try:
combo2.DataSour ce = DataSet.Relatio ns[name of relation];
combo2.DisplayM ember = col name from child table;
combo2.ValueMem ber = col name from child table;

"Nicholas Paldino [.NET/C# MVP]" wrote:

David,

Set the data source of combo2 to the relation itself, not to the child
table.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:AB******** *************** ***********@mic rosoft.com...

combo1.DataSour ce = parent table;
combo1.DisplayM ember = col name from parent table;
combo1.ValueMem ber = col name from parent table;

combo2.DataSour ce = child table;
combo2.DisplayM ember = col name from child table;
combo2.ValueMem ber = col name from child table;
combo2.DataBind ings.Add("Selec tedValue", parent table, name of relation);

when the user changed value in combo1, the code should refresh data in
combo2.
However, I can have other way around this issue. I just like to know I can
use relation to do this kind of binding, like I often do for Combox and
DataGrid (grid.SetDataBi nding(parent table, name of relation)).

Thanks

"Nicholas Paldino [.NET/C# MVP]" wrote:

DK,

Are you binding to the relation for the combobox as well? Can you
show
some code, as well as what your expectations are?
"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:A8******** *************** ***********@mic rosoft.com...
> Hi All:
> I have a dataset contains two tables, one parent child relation between
> two
> tables. I have no trouble to bind parent table to a combobox, relation
> to
> a
> win grid control. But I am having trouble to bind relation into another
> combo
> box. DotNet does not give me a run time error. But it did not perform
> the
> way
> I am expecting.
>
> Thanks in advance
>
> DK
>

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

David,

Does it throw an exception, or nothing happens?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:E0******** *************** ***********@mic rosoft.com...

No this does not work.

Here is what I try:
combo2.DataSour ce = DataSet.Relatio ns[name of relation];
combo2.DisplayM ember = col name from child table;
combo2.ValueMem ber = col name from child table;

"Nicholas Paldino [.NET/C# MVP]" wrote:

David,

Set the data source of combo2 to the relation itself, not to the
child
table.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote in
message news:AB******** *************** ***********@mic rosoft.com...

> combo1.DataSour ce = parent table;
> combo1.DisplayM ember = col name from parent table;
> combo1.ValueMem ber = col name from parent table;
>
> combo2.DataSour ce = child table;
> combo2.DisplayM ember = col name from child table;
> combo2.ValueMem ber = col name from child table;
> combo2.DataBind ings.Add("Selec tedValue", parent table, name of
> relation);
>
> when the user changed value in combo1, the code should refresh data in
> combo2.
> However, I can have other way around this issue. I just like to know I
> can
> use relation to do this kind of binding, like I often do for Combox and
> DataGrid (grid.SetDataBi nding(parent table, name of relation)).
>
> Thanks
>
> "Nicholas Paldino [.NET/C# MVP]" wrote:
>
>> DK,
>>
>> Are you binding to the relation for the combobox as well? Can you
>> show
>> some code, as well as what your expectations are?
>> "da*******@opco .com" <da************ *@discussions.m icrosoft.com> wrote
>> in
>> message news:A8******** *************** ***********@mic rosoft.com...
>> > Hi All:
>> > I have a dataset contains two tables, one parent child relation
>> > between
>> > two
>> > tables. I have no trouble to bind parent table to a combobox,
>> > relation
>> > to
>> > a
>> > win grid control. But I am having trouble to bind relation into
>> > another
>> > combo
>> > box. DotNet does not give me a run time error. But it did not
>> > perform
>> > the
>> > way
>> > I am expecting.
>> >
>> > Thanks in advance
>> >
>> > DK
>> >
>>
>>
>>