Hi,

I'm trying to populate a dropdownlist control in my module. I've got the script working in an .aspx page but when I had it to my .ascx module it stops working.

Do I need to enable anything?

Many thxs

<%@ Import Namespace="System.Data.SQLClient" %>
<%@ Import Namespace="System.Data" %>

<script language="VB" runat="server">
  
Sub Page_Load(Source As Object, E As EventArgs)
       If Not Page.IsPostBack Then
            Dim SQLConn As SQLConnection
            Dim SQLComm As SQLCommand
            Dim oReader As SQLDataReader
            Dim sSQL As String
            Dim sConn As String

            sSQL = "SELECT * from CN_Policy_Types"
            sConn = "Server=localhost;Database=*********;uid=*********;pwd=***********;"

            SQLConn = New SQLConnection(sConn)
            SQLConn.Open()
            SQLComm = New SQLCommand(sSQL, SQLConn)
            oReader = SQLComm.ExecuteReader()
   
            ddlReason.DataSource = oReader
            ddlReason.DataBind()
            'SQLConn.Close()
        End If    
End Sub

</script>

 
  <form runat="server" ID="Form1">
<asp:DropDownList ID="ddlReason" DataTextField="CN_PolicyName_Nvarchar" DataValueField="CN_PolicyDateIncrement_int" Runat="server" AutoPostBack="True"/>
  </form>