how to find dropdownlist selectedvalue in dataset datatable to update foreign key in another table

[TSA]

Hi all,

Here's scenario:

Table 1:
Table1_pk
A
B
C
Table2_fk

Table 2:
Table2_pk
A
B
C
I have dropdownlist on a webform which selects value B from Table 2.
When I select a value from the dropdownlist, I need able find
Table2_pk for that selected value and insert into Table2_fk column
when updating Table 1.
Thanks for your help.

[Earl]

All depends on how it's bound. Typically, the PK is bound to the combo as
the ValueMember. Then to pick it up on selection, it's simply
Cint(cmbWhatever.SelectedValue).

"TSA" <am***********@yahoo.com> wrote in message
news:92*************************@posting.google.co m...

Hi all,

Here's scenario:

Table 1:
Table1_pk
A
B
C
Table2_fk

Table 2:
Table2_pk
A
B
C
I have dropdownlist on a webform which selects value B from Table 2.
When I select a value from the dropdownlist, I need able find
Table2_pk for that selected value and insert into Table2_fk column
when updating Table 1.
Thanks for your help.