populate listbox from a database in html

**See29596** · 16-10-2013

Hi

i have the following html code that is working.
<html>
<head>
<title>Entitled Document</title>
<script language="JavaScript" >

function condb()
{

var cn = new ActiveXObject("ADODB.Connection");
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = d:\siel.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
var SQL = "select fname, mname, lname from hd where fname = 'Joe'";
cn.Open(strConn);
rs.Open(SQL, cn);

fname.value = rs(0);
lname.value = rs(2);
mname.value = rs(1);
rs.Close();
cn.Close();

}

</script>
</head>
<body>

<br />
 

First <input type="text" name="fname" /> 
Middle
<input type="text" name="mname" />
Last <input type="text" name="lname" />
<input type="button" value="submit" onClick="condb()"> 

</body>
</html>

I want to store the dataset in an array then use it to populate a listbox.
and I need the listbox.value to be lname
can you help ?
thank you

**See29596** · 18-10-2013

I have the following html code:

<html>
<body>
<script language="javascript">
var cn = new ActiveXObject("ADODB.Connection");
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\contact.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
var rs2 = new ActiveXObject("ADODB.Recordset");
var SQL = "select fname, mname, lname from hd where fname = 'joe'";
var SQL2= "select count(fname) as rcount from hd where fname = 'joe'";
rst=cn.Open(strConn);
rs1=rs.Open(SQL, cn);
rs0=rs2.Open(SQL2, cn);

rcnt= rs2(0);
var numArr = new Array (rcnt);
var i;
var j;
for (i = 0; i < rcnt; i++)
{
numArr[i] = rs(0);
}
i = 0;
while (i < rcnt)
{
//document.write ("numArr[" + i + "] = " + numArr[i] + "<br>");;
i++;
}
</script>

<script type="text/javascript">

</script>

<tr>
<td colspan="2"><p>Populate list box from array :
<select name="locationList" id="locationList" size="4" onChange="alert(value);
tf.value=value;" style="font-family:arial; font-size:12; color:#000000; text-decoration:none; padding-left:10px; width:200px; border:2;">
</select>
</p>
<p>
</body>
</html>

I am trying to create a list box that holds fname from table hd and the value lname.

I dont know what to do next. so can anyone help and suggest what to do next.
thank you

Thread: populate listbox from a database in html

Thread Tools

populate listbox from a database in html

Re: populate listbox from a database in html

Similar Threads

Populate a list box

How to create ListBox in VB.net?

HTML Listbox ActiveX Control

C# Listbox control

Combobox Selection To Populate Listbox

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions