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).