Advertiser Disclosure

Multi DropDowns in ASP with Database

Category:

ASP, HTML and XML

Type:

Difficulty:

Author: Anonymous

Version Compatibility: Visual Basic 6, ASP

More information:

this file contains two Dropdowns and will show values from database selecting value from one dropdown the second dropdown will show the values corresponding to first dropdown from database. If you have any quiries or problems to run this code OR any thing else about ASP and Databases you may e-mail me. E-mail: jam05pgs@hotmail.com

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:
' (None)

Code:

<%@ language = "Javascript" %>
<%

var strBrand = "";
if (Request.Querystring("stateChanged") == "true")
{
strBrand = Request.Form("cboBrand");
}
var strconnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Inetpub/wwwroot/multi_dropdowns/jamal.mdb";
%>
<script language=Javascript>
function initControls()
{
populateBrand();
populateType();
}
function populateBrand()
{
<%
var rs = Server.CreateObject("ADODB.Recordset");
var sql = "select distinct brand from cuitems order by brand"
rs.Open(sql,strconnection);
var n=0;
while (!rs.EOF)
{
var stateID = rs.Fields("brand");
var stateDesc = rs.Fields("brand");
Response.Write("document.frmTest.cboBrand[" + n + "] = new Option('" + stateDesc+ "','" + stateID + "');");

if (new String(strBrand).search(stateID) != -1)

Response.Write("document.frmTest.cboBrand[" + n + "].selected = true;");
rs.MoveNext();
n++;
}
rs.Close();
%>
}

function populateType()
{
<%
if (strBrand != "")
  {
	var rs2 = Server.CreateObject("ADODB.Recordset");
	var strSql = "select distinct cat from cuitems where brand = '" + strBrand + "' ";
	rs2.Open(strSql,strconnection);
	var n=1;
	while (!rs2.EOF)
		{
			var strType = rs2.Fields("cat");
			Response.Write("document.frmTest.cboType[" + n + "] = new Option('" + strType + "','" + strType + "');");
			rs2.MoveNext();
			n++;
		}
		rs2.Close();
	}
%>
}
function fillType()
	{
		document.frmTest.action = "default.asp?stateChanged=true";
		document.frmTest.submit();
	}
		function saveData()
	{
		document.frmTest.action = "./Browse_Product.asp";
		return true;
	}

</script>

<html>
<head>

<meta name="WT.qs_dlk" content="X42ryso6pqKyryWA@Q8SPQAAABg"/>

<meta name="WT.qs_shmv" content="hv20200211-hale.sf.quinstreet.net"/>

<meta name="inject_params" content="WT.qs_dlk=X42ryso6pqKyryWA@Q8SPQAAABg&"/>

<script>!function(){if(!window.BOOMR||!window.BOOMR.version){var e,t,n,o=document.createElement("iframe");o.src="javascript:false",o.title="",o.role="presentation",(o.frameElement||o).style.cssText="width:0;height:0;border:0;display:none;",(n=document.getElementsByTagName("script")[0]).parentNode.insertBefore(o,n);try{t=o.contentWindow.document}catch(n){e=document.domain,o.src="javascript:var d=document.open();d.domain='"+e+"';void(0);",t=o.contentWindow.document}t.open()._l=function(){var t=this.createElement("script");e&&(this.domain=e),t.id="boomr-if-as",t.src="/imageserver/common/sg/1.0/sg.min.js",BOOMR_lstart=(new Date).getTime(),this.body.appendChild(t)},t.write('<body onload="document._l();">'),t.close()}}();</script>
<script>
                document.cookie = 'inject_params=WT.qs_dlk=X42ryso6pqKyryWA@Q8SPQAAABg&; path=/;  domain=freevbcode.com;; SameSite=None; Secure;';
                document.cookie = 'WMUUID=X42ryso6pqKyryWA@Q8SPQAAABg; path=/;  domain=freevbcode.com;; SameSite=None; Secure;';
            </script>
<title>Multi Dropdown Selecting Value from one second will Display its corresponding values</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<script>
    window.webtrendsAsyncInit=function(){
        var dcs=new Webtrends.dcs().init({
            dcsid:"dcszmx810000004jhhhvshyva_9q4y",
            domain:"www.qsstats.com",
            timezone:-8,
            i18n:true,
            onsitedoms:"freevbcode.com",
            fpcdom:".freevbcode.com",
            plugins:{
                //hm:{src:"//s.webtrends.com/js/webtrends.hm.js"}
            }
            }).track();
    };
    (function(){
        var s=document.createElement("script"); s.async=true; s.src="/imageserver/common/v10/webtrends.min.js";    
        var s2=document.getElementsByTagName("script")[0]; s2.parentNode.insertBefore(s,s2);
    }());
    </script>
    <noscript><img alt="dcsimg" id="dcsimg" width="1" height="1" src="//www.qsstats.com/dcszmx810000004jhhhvshyva_9q4y/njs.gif?dcsuri=/index.php/ShowCode.asp&WT.js=No&WT.tv=10.4.1&dcssip=www.freevbcode.com&WT.qs_dlk=X42ryso6pqKyryWA@Q8SPQAAABg&"/></noscript>
</head>
<body onload = "initControls();" bgcolor="#ffffff" link="#666666" vlink="#666666" alink="#666666" leftmargin="0" topmargin="0">
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  
  <tr>
   <td><table border="0" cellpadding="0" cellspacing="0" width="780">
	  <tr>
	   <td>
        </td>
	   <td><table border="0" cellpadding="0" cellspacing="0" width="560">
		  <tr>
		   <td><table border="0" cellpadding="0" cellspacing="0" width="560">
                    <tr> 
                      <td><div align="right"> </div></td>
                    </tr>
                  </table></td>
		  </tr>
		  <tr>
		   <td>
            </td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
   <td><table border="0" cellpadding="0" cellspacing="0" width="780">
	  <tr>
	      <td valign="top">
<table width="220" border="0" cellpadding="0" cellspacing="0" bgcolor="#D6E6F3">
              <tr> 
                <td valign="top" bgcolor="96C2DD"> <strong style="font-weight: 400"> 
                  <font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"> 
                  Shop By Brand</font></strong></td>
              </tr>
              <tr> 
                <td valign="top"> <form name="frmTest" method="post" action="html/browse_product.asp">
                    <table width="220" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
                      <tr valign="top" bgcolor="#D6E6F3"> 
                        <td height="25" colspan="2" width="220"> 
                        <select name="cboBrand" onChange="fillType()">
                            <option value="Select Brand" selected> Select Brand 
                            </option>
                          </select> </td>
                      </tr>
                      <tr bgcolor="#D6E6F3"> 
                        <td width="153" valign="top" bgcolor="#D6E6F3">
                        <select name="cboType">
                            <option selected value="Select Products">Select Products</option>
                          </select> </td>
                        <td width="67" bgcolor="#D6E6F3"> 
                        <INPUT TYPE = "Submit" VALUE = "GO>>>>"> 
                        </td>
                      </tr>
                    </table>
                  </form></td>
              </tr>
              <tr> 
                <td height="387" valign="top" bgcolor="#D6E6F3"> <p align="justify" style="margin-top: 2; margin-bottom: 2"><font size="2" face="Arial"><br>
                   
                    </font></p>
                  <p> </p></td>
              </tr>
            </table></td>
	      <td align="right">
<table border="0" cellpadding="0" cellspacing="0" width="545">
		  <tr>
		   <td><table border="0" cellpadding="0" cellspacing="0" width="545">
			  <tr>
			   <td> </td>
			   <td> </td>
			   <td> </td>
			  </tr>
			</table></td>
		  </tr>
		  <tr>
		   <td>
            </td>
		  </tr>
		  <tr>
		   <td><table border="0" cellpadding="0" cellspacing="0" width="545">
			  <tr>
			   <td> </td>
			   <td> </td>
			   <td> </td>
			  </tr>
			</table></td>
		  </tr>
		  <tr>
		   <td>
            </td>
		  </tr>
		  <tr>
		   <td><table border="0" cellpadding="0" cellspacing="0" width="545">
			  <tr>
			   <td> </td>
			   <td> </td>
			   <td> </td>
			   <td> </td>
			   <td>
               <img name="default_r8_c16" src="../images/default_r8_c16.jpg" width="1" height="141" border="0" alt=""></td>
			  </tr>
			</table></td>
		  </tr>
		  <tr>
		   <td bgcolor="#ffffff">
            </td>
		  </tr>
		</table>
            <div align="right"></div></td>
	  </tr>
	</table></td>
  </tr>
</table>
</body>
</html>