DropDownList Postback - << VERSIONE VB.NET >>

Utilizzare la propriet� IsPostBack per evitare di caricare pi� volte i dati in una DropDownList

<%@ 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)
{
  if (!IsPostBack)
  {
    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>