combobx comparision

Question

i have one table name  is room in this roomno is one column and in front-end windows form i have my design when i select roomnumber using combobox  it start compare weather the roomnumber is already reserved or not

    please any one provide the code