> 
- Home Page
- > Script C#
- > Script C# Web Controls
- > Reader DropDownList
Reader DropDownList - << VB.NET VERSION >>
Pupulate a DropDownList using a Reader
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e )
{
OleDbConnection myConn = new OleDbConnection(
"Provider=Microsoft.Jet.OleDb.4.0; Data Source=" +
Server.MapPath("database/utenti.mdb"));
OleDbCommand myCmd = new OleDbCommand("select Nome, Cognome, email from utenti", myConn);
if (!IsPostBack)
{
try
{
myConn.Open();
OleDbDataReader aReader = myCmd.ExecuteReader();
try
{
while (aReader.Read())
{
ListItem li = new ListItem(
aReader["nome"] + " " + aReader["cognome"],
aReader["email"].ToString());
DropDownList1.Items.Add(li);
}
}
finally
{
aReader.Close();
}
}
finally
{
myConn.Close();
}
}
}
</script>
<body>
<form name="Form1" runat="server">
<asp:DropDownList id="DropDownList1" runat="server"></asp:DropDownList>
</form>
</body>
</HTML>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e )
{
OleDbConnection myConn = new OleDbConnection(
"Provider=Microsoft.Jet.OleDb.4.0; Data Source=" +
Server.MapPath("database/utenti.mdb"));
OleDbCommand myCmd = new OleDbCommand("select Nome, Cognome, email from utenti", myConn);
if (!IsPostBack)
{
try
{
myConn.Open();
OleDbDataReader aReader = myCmd.ExecuteReader();
try
{
while (aReader.Read())
{
ListItem li = new ListItem(
aReader["nome"] + " " + aReader["cognome"],
aReader["email"].ToString());
DropDownList1.Items.Add(li);
}
}
finally
{
aReader.Close();
}
}
finally
{
myConn.Close();
}
}
}
</script>
<body>
<form name="Form1" runat="server">
<asp:DropDownList id="DropDownList1" runat="server"></asp:DropDownList>
</form>
</body>
</HTML>
