how to load list from database,in drop-drag box

[bohiyaanam]

Hi!

I have one page to add infornation to database.
In that page their are some drop-drag boxes,in which i want ,it must show list after loading from database.........like
name is one drop-drag box when i clik to select,it should show names from database.
Is their any way to do this?

[r035198x]

Hi!

I have one page to add infornation to database.
In that page their are some drop-drag boxes,in which i want ,it must show list after loading from database.........like
name is one drop-drag box when i clik to select,it should show names from database.
Is their any way to do this?

This sounds like a Javascript/Ajax problem.
So I'll move it over there.

[bohiyaanam]

might be......ok.......

[r035198x]

might be......ok.......

You're connecting to the database right. So which server side language are you using?

[bohiyaanam]

jsp
installed tomcat+mysql+jdbc.

[r035198x]

jsp
installed tomcat+mysql+jdbc.

You should have mentioned that in your first post.
Do you know how to connect to a database using JDBC then? Because that's all you need to do and then you can use a while loop to populate the drop down box.

Edit: This may end up going back to the Java forum

[bohiyaanam]

oh sorrry,
i know how to access database.i could able to fire queries through page also.
i am not getting how to use that while loop?

[r035198x]

oh sorrry,
i know how to access database.i could able to fire queries through page also.
i am not getting how to use that while loop?

You don't need to fire queries when the drop down is clicked. You simply need to create the options of the drop down using the values from the database.

  while(rs.next()) {
%> 
       <option value="<%=rs.getString(1)%>"><%=rs.getString(1)%> </option>
<%
      }
%>

[bohiyaanam]

Thanks sir
Now its working.