One dropdown box , One textbox

Contributed by
Rating: 4 stars4 stars4 stars4 stars4 stars / 9
January 28, 2000
Rate this Article:
MEH MEH++


SEARCH ASP FREE
TOOLS YOU CAN USE

advertisement

Combo and textbox example

Here is the code for this Example

<!-- Author: Adrian Forbes -->
<%
strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name
set conn = server.createobject("adodb.connection")
conn.open strconn
set objRS = createobject("ADODB.Recordset")
objRS.Open "select ID, strParent, intValue from Parents", strconn
    if Request("cboPrimary") = "" then
        lPrimary = objRS("ID")
    else
        lPrimary = clng(Request("cboPrimary"))
    end if
%>
<form name=frmTest action="ComboTextboxLinked.asp" method=POST>
<p>
<select name=cboPrimary size=1 onChange="PopulateTextbox();">
<%while not objRS.EOF
lID = clng(objRS("ID"))%>
<option value="<%=lID%>"<%if lPrimary = lID then Response.Write " SELECTED"%>><%=objRS("strParent")%>
<%    objRS.MoveNext
wend
%>
</select>&nbsp;&nbsp;&nbsp;<input type=TEXT name=txtValue>
</p>
<p>
<input type=SUBMIT value="Select" id=SUBMIT1 name=SUBMIT1>
</p>
</form>
<%
objRS.MoveFirst
while not objRS.EOF%>
<input type=HIDDEN ID="intValue<%=objRS("ID")%>" value="<%=objRS("intValue")%>">
    <%objrs.MoveNext
wend
objRS.Close
set objRS.ActiveConnection = nothing
set objRS = nothing
%>
<script language=VBScript>
sub window_onLoad
    PopulateTextbox
end sub

sub PopulateTextbox
    lID = document.frmTest.cboPrimary.value
    document.frmTest.txtValue.value = document.all("intValue" & lID).value
end sub
</script>

blog comments powered by Disqus
ASP CODE ARTICLES

- ASP Forms
- ASP: The Beginning
- Getting Remote Files With ASP Continued
- Inbox and Outbox Manipulation in ASP
- Relational DropDownList Using VB.NET
- Ad Tracking URL Hits
- Use ViewState to display one record per page...
- Send Email using ASP.NET formatted in HTML
- ASP File Explorer
- ASP/XML Interview questions by Srivatsan Sri...
- Pressing RETURN won't submit the form
- This shows how you get the TEXT of a combo r...
- Group Data by Adrian Forbes
- Multiple checkbox select sample
- Multiple checkbox select with all values sam...

ASP Web Hosting ASP.Net Web Hosting Windows Web Hosting
 
 
 

ASP Free Forums 
 RSS  Tutorials RSS
 RSS  Forums RSS
 RSS  All Feeds
Site Map 
Request Media Kit
Write For Us Get Paid 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Privacy Policy 
Support 


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 2 - Follow our Sitemap
Most Popular Topics
All ASP.Net Tutorials