QuestionAsk Questions?
Ragini Shukla
Hi Friends,
I have one option box which is division,
division have dynamically data,if user select any division then
his option box is populated
(work schedule,Peronal Area,personal sub area,business area,trust master,payroll data)
please write the code and let me know..its urgent
I have one option box which is division,
division have dynamically data,if user select any division then
his option box is populated
(work schedule,Peronal Area,personal sub area,business area,trust master,payroll data)
please write the code and let me know..its urgent
View Answers
January 9, 2010 at 11:45 AM
Hi Friend,
Try the following code:
<%@page import="java.sql.*"%>
<html>
<h2>ComboBox</h2>
<script language="javascript">
var arr = new Array();
arr[0] = new Array("-select-");
arr[1] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[2] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[3] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[4] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
function change(combo1){
var comboValue = combo1.value;
document.forms["form"].elements["combo2"].options.length=0;
for (var i=0;i<arr[comboValue].length;i++)
{
var option = document.createElement("option");
option.setAttribute('value',i+1);
option.innerHTML = arr[comboValue][i];
document.forms["form"].elements["combo2"].appendChild(option);
}
}
</script>
<form name="form" method="post">
<select name="combo1" onchange="change(this);">
<option value="0">-Select-</option>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery("Select * from division");
while(rs.next()){
%>
<option value="<%=rs.getString("id")%>"><%=rs.getString("divisions")%></option>
<%
}
}
catch(Exception e){}
%>
</option>
</select><br />
<select name="combo2">
</select>
</form>
</html>
For the above code we have created a table named division(id,divisions) in the database.
Hope that it will be helpful for you.
Thanks
Try the following code:
<%@page import="java.sql.*"%>
<html>
<h2>ComboBox</h2>
<script language="javascript">
var arr = new Array();
arr[0] = new Array("-select-");
arr[1] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[2] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[3] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
arr[4] = new Array("work schedule","Peronal Area","personal sub area","business area","trust master","payroll data");
function change(combo1){
var comboValue = combo1.value;
document.forms["form"].elements["combo2"].options.length=0;
for (var i=0;i<arr[comboValue].length;i++)
{
var option = document.createElement("option");
option.setAttribute('value',i+1);
option.innerHTML = arr[comboValue][i];
document.forms["form"].elements["combo2"].appendChild(option);
}
}
</script>
<form name="form" method="post">
<select name="combo1" onchange="change(this);">
<option value="0">-Select-</option>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery("Select * from division");
while(rs.next()){
%>
<option value="<%=rs.getString("id")%>"><%=rs.getString("divisions")%></option>
<%
}
}
catch(Exception e){}
%>
</option>
</select><br />
<select name="combo2">
</select>
</form>
</html>
For the above code we have created a table named division(id,divisions) in the database.
Hope that it will be helpful for you.
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
