how to validate the combobox item from one table to another.

See more:

C#

Table Design as follows;

Faculty Code Text.

Faculty Code Table Name(schedule)
RK
GS
VB
MK

i have one combo box in that combo box the Faculty Code are displayed from the table schedule.

combo box Insert Faculty(Button)

Another Table Design as follows

code Text

Code Table name(Details)
RK
Sj

in run mode when user select the RK from the combo box and click the button the message shows the selected RK Fauclty is already there.

in Both the table RK is there.if user select the same faculty code from combo box it matches two table.

pop message want to display "Please select different faculty code";

how can i do using c sharp.



i want to show the message.