<form method="get" action="simpleform.asp">
<select name="itemid" id="itemid">
<option value="1">Choose1</option>
<option value="2">Choose2</option>
<select>
<input type="submit" name="btn" value="submit">
</form>
ASP:
'to get value from dropdown(user form method 'post')
empname=request.form("itemid")
Rs.Open("select * from emp_data where emp ='" + empname + "'", Cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
room_no.Text = Rs("room_no").Value
Rs.Close()
Dina Shahin, if this helps please login to Mark As Answer. | Alert Moderator