make a submit type button then the page form action post back to same page

asp top page detect post back and fruitname and update table


or use a javascript function detect the combobox change, and post back
then do the update


i think use button better

1st)
<FORM NAME="fmMain" ACTION="Fruit.asp?fruitName=<%=fruitName%>" METHOD="post" TARGET="_top">

2nd)
<input value ="View Bill" type="submit" name="bttSubmit" />



3rd) 'Request balik the fruitname on the top page
<%@ LANGUAGE="VBSCRIPT" %>

fruitName= Request("fruitName")

if fruitName="" then
Response.Write "<script>alert('Please Select The Fruit Type.')</script>"
else
' SQL UPDATE STATEMENT HERE
'
'
'

end if

%>