Populate html dropdown

nlkflynn777 · Mar 12, 2004

Hi,

I have an html listbox on a form, I need to populate it from the database. I’m not sure how to do that in ASP.net, how do I populate/reference it with sever-side code?

Thanks

klaz2002 · Mar 12, 2004

For starters you need to use the <asp:listbox> control. You can hit your database and you return the informion that you need (ie. a list of selections etc...). You then set the Text field and the value field of the listbox control and you DataBind() it. Real simple.

Here is an example:
<%@ Page Language = "C#" Debug = "true" %>
<%@ Import Namespace= "System" %>
<%@ Import Namespace= "System.Data" %>
<%@ Import Namespace= "System.Data.SqlClient" %>
<%@ Import Namespace= "System.Web" %>
<%@ Import Namespace= "System.Web.UI.WebControls" %>

<html>
<body>
<SCRIPT LANGUAGE="C#" RUNAT="SERVER">

protected void Page_Load(Object sender, EventArgs e){
if (!IsPostBack){
string conn= @"server = YOUR_SERVER_NAME;" +
"database= DATABASE_NAME;" +
"User id = USER_NAME;" +
"password= PASSWORD;";

string selstr="Select * from YOUR_TABLE_NAME";

SqlConnection scon = new SqlConnection(conn);
SqlCommand sc = new SqlCommand(selstr,scon);
scon.Open();
ListBox1.DataSource= sc.ExecuteReader();
ListBox1.DataTextField="SELECTION_TEXT";
ListBox1.DataValueField="SELECTION_VALUE";
ListBox1.DataBind();
scon.Close();
}
}
</SCRIPT>
<asp:ListBox id="ListBox1" AutoPostBack="true" runat="server" />
</body>
</html>

This is just an example. There are many examples located on the web. You can try browsing this board or

http://www.google.com/grphp?hl=en&tab=wg&ie=UTF-8&oe=UTF-8&q=

(google groups)
Klaz

nlkflynn777 · Mar 12, 2004

Thanks,

The problem I'm having is our client wants this to act like a combo box. So I pretty much need to have a textbox setting on top of a listbox, the reason I wanted to do it client-side was so I could search the lisbox and bring up any matching entries into the textbox when they entered something.

Thanks again

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Populate html dropdown

nlkflynn777

Programmer

klaz2002

Programmer

nlkflynn777

Programmer

Similar threads

Part and Inventory Search

Sponsor