hai...
u r telling that u have only a text box and two buttons in the page...then frm where came this drop down box...?
again, if user types the name in the name text box , y u want to show the same name in drop down box again?
either u can show the whole names in the database to dropdown box or u can show the names matching to the user typed names...



for both ways...u can use the same method....


<%@ page import="java.sql.*" %>
<%! Connection con;
ResultSet rst;
Statement st;
String url="jdbc:db2://url/dbase:";

%>

<tbody>
<tr>
<td height="65"><a href="http://localhost:9081/voc/logout.jsp">LOG OUT</a></td>
</tr>
<tr>
<td height="244" align="center">
<table border="0" width="208" height="98">
<tbody>


<tr>
<td width="91">NAME</td>


??????????FROM HERE ITS FOR DISPLAYING THE LIST!!!!!!!

<td width="115">
<select name="cid">
<%
try
{
Class.forName("com.ibm.db2.jcc.DB2Driver");
con=DriverManager.getConnection(url,"username","pwd");
System.out.println("After Establishing connection");
}
catch(ClassNotFoundException e)
{
System.out.println("ERROR!1: "+e);
request.setAttribute("message", "ERROR");
ServletContext ctx=getServletContext();
RequestDispatcher dis=ctx.getRequestDispatcher("index.jsp");
dis.forward(request,response);
}
try
{

st=con.createStatement();
rst=st.executeQuery("select * from tbl_namelist");
System.out.println("After name list");
while(rst.next())
{%>

<option value="<%= rst.getString(1) %>"><%= rst.getString(2) %></option>
<% }

System.out.println("After reading values");

}

catch(Exception e)
{
System.out.println("ERROR!!2 :"+e);
request.setAttribute("message", "ERROR");
ServletContext ctx=getServletContext();
RequestDispatcher dis=ctx.getRequestDispatcher("index.jsp");
dis.forward(request,response);
}




this will show all the names in the databse table to the dropdown list....


if u want to show the names similar to the user typed ..then add a text box above the drop down box and change the sql command to select * from tbl-namelist where name= the value from the text box.....

then it will show only the names matching with the user typed names...
aftr selecting a name from the dropdown box, and aftr submittin....use the code i gave on yesterday......

Read for information.

http://www.roseindia.net/jsp/

Thanks.

Amardeep