<html>
<head>
<script>
function myFunction()
{
var con = new ActiveXObject('ADODB.Connection');
var rs = new ActiveXObject('ADODB.Recordset');
con.ConnectionString="Provider=MSDAORA.1;User ID=hr_man;Password=hr_man;Data Source=ORCL;Persist Security Info=False";
con.Open();
rs.Open("select emp_id,emp_name from employee_master order by emp_name").value,con);
var s="<select>";
while(!rs.EOF)
{
s+="<option value='" + rs.Fields("emp_id").Value + "'>" + rs.Fields("emp_name").Value + "</option>";
rs.MoveNext();
}
s+-"</select> ";
rs.Close();
con.close;
document.getElementById("comboDiv").innerHTML=s;
}
</script>
</head>
<body>
<div id="comboDiv">
</div>
</body>
</html>
<head>
<script>
function myFunction()
{
var con = new ActiveXObject('ADODB.Connection');
var rs = new ActiveXObject('ADODB.Recordset');
con.ConnectionString="Provider=MSDAORA.1;User ID=hr_man;Password=hr_man;Data Source=ORCL;Persist Security Info=False";
con.Open();
rs.Open("select emp_id,emp_name from employee_master order by emp_name").value,con);
var s="<select>";
while(!rs.EOF)
{
s+="<option value='" + rs.Fields("emp_id").Value + "'>" + rs.Fields("emp_name").Value + "</option>";
rs.MoveNext();
}
s+-"</select> ";
rs.Close();
con.close;
document.getElementById("comboDiv").innerHTML=s;
}
</script>
</head>
<body>
<div id="comboDiv">
</div>
</body>
</html>
No comments:
Post a Comment