Hi,

I'm very new with ASP.NET, and DNN. I'd greatly appreciate your patience with me, and help me out here.
I'm building my own module, and have problems trying to bind data to my dropdownlist.
Here's a snapshot/extract of what I have done.

1. Stored Procs:
   • I've created a Storedprocedure "YourCompany_MyModule_GetCategories"
   • CREATE PROCEDURE {databaseOwner}[{objectQualifier}YourCompany_MyModule_GetCategories]
     (
     @ModuleID int
     )
     AS
     SELECT CategoryID, CategoryName, CategoryDesc
     FROM {objectQualifier}YourCompany_MyModule_Categories
     WHERE (ModuleID = @ModuleID)
     order by CategoryName
     RETURN
     
2. App_Code\MyModule\SqlDataProvider.vb:
   • Public Overrides Function YourCompany_MyModule_GetCategories(ByVal ModuleId As Integer) As IDataReader
     Return CType(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("YourCompany_MyModule_GetCategories"), ModuleId), IDataReader)
     End Function
     
3. App_Code\MyModule\DataProvider.vb:
   • Public MustOverride Function YourCompany_MyModule_GetCategories(ByVal ModuleId As Integer) As IDataReader
     
4. App_Code\MyModule\MyModuleInfo.vb:
   • I've set and get the various variables : _CategoryID, _CategoryName, _CategoryDesc, _ModuleID, etc...
5. App_Code\MyModule\MyModuleController.vb:
   • In here, I've created a function to return the list.
   • Public Shared Function MyModule_GetCategories(ByVal ModuleId As Integer) As List(Of MyModuleInfo)
      Return CBO.FillCollection(Of MyModuleInfo)(DataProvider.Instance().YourCompany_MyModule_GetCategories(ModuleId))
     End Function
     
6. DesktopModules\MyModule\ViewMyModule.ascx:
   • I'd be displaying the dropdownlist here, to enable users to select the category.
   • <asp:dropdownList ID="list1" runat="server" />

Now, I'm stuck. How do I:

• Initialise the list (to trigger the function, and return the list of categories)
• Bind this list to the dropdownlist - "list1"

Thanks very much for your attention and help.