Code for filling up a combobox in ASP - ASP

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

Code for filling up a combobox in ASP
Author: Hemant D.
Website: http://www.freeecommersetips.com
Submitted: 8/4/2009
Version: ASP
Compatibility: ASP3.0
Category: Databases
Views: 5723
The code given below populates the combo box in ASP.
Declarations:
<% Dim Connectdata Dim Connectstring Dim SQLstring Dim Recorddata
Code:
Connectstring = "Provider=SQLOLEDB; Datasource=datasource; Database=Testdata; UID=user id of database; PWD= Password for database;" Set Connectdata = Server.Createobject("ADODB.Connection") Connectdata.connectionstring = Connectstring Connectdata.mode = Readwrite Connectdata.open Set Recorddata = Server.Createobject("ADODB.Recordset") SQLstring = "select * from testdata" Recorddata.open SQLString, Connectdata, [Locktypes for the database] Recorddata.movefirst %> < select name = cbobox > <%while rs.EOF <> true%> < option value = "<%Response.Write (recorddata("fieldname"))%>"> <% Response.Write(recorddata("fieldname")) %> </option> <% recorddata.movenext wend %> </select>