> 
- Home Page
- > Script C#
- > Script C# Web Controls
- > DropDownList
DropDownList - << VB.NET VERSION >>
Pupulate a DropDownList reading data from SQLServer
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
OleDbConnection objCon;
objCon = new OleDbConnection("Provider=sqloledb;Data Source=NOME_DATABASE_SERVER;
Initial catalog=NOME_DATABASE;User Id=USER_NAME;Password=PASSWORD;");
DataSet ds = new DataSet();
OleDbDataAdapter objAdapter = new OleDbDataAdapter("Select ID, TESTO from TABELLA order by TESTO desc", objCon);
objAdapter.Fill(ds);
catList.DataSource=ds.tables[0].DefaultView;
catList.DataValueField="ID";
catList.DataTextField="TESTO";
catList.DataBind();
}
</script>
<html>
<body>
<form runat="server" ID="Form1">
<asp:DropDownList id="myDropDownList" runat="server"/>
</form>
</body>
</html>
