Hey Gang,

I'm trying to tie in the Telerik RadComboBox
with my Dnn 4.0.2 installation.

I am running MS SQL, and I want to to connect the RadCombobox to a table that lists product categories.

A major conceptual problem I'm having is how to tie into the existing Dotnetnuke DB connection. I'm absolutely positive that the way i'm doing it, creating a new (OLE at that) connection is moronic..  declarative datarsource is what I need? I mean, it -works- (I was more successful with the telerik grid), but it would totally be outside of the scope of the native DNN caching I guess.

I created a little DNN module.. but no luck.. I am getting an error something to this effect:

DotNetNuke.Services.Exceptions.ModuleLoadException: C:\Inetpub\vhosts\mysite.com\httpdocs\DesktopModules\ArtCategories\ArtCategories.ascx.vb(1): error ASPNET: Make sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl)

My Ascx file is so:

<%@ Control Language="vb" CodeFile="ArtCategories.ascx.vb" Inherits="Telerik.DNN.Modules.ArtCategories.ArtCategories" %>
<%@ Register TagPrefix="radcb" Namespace="Telerik.WebControls" Assembly="RadComboBox.Net2" %>
<div>
           <radcb:radcombobox id="RadComboBox1" Runat="server" Height="140px" Skin="WhiteRound" Width="150px" ShowToggleImage="True"
                            Sort="Ascending"></radcb:radcombobox>
</div>


and the codebehind is so:

Imports System
Imports System.Data.OleDb
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports DotNetNuke.Services
Imports DotNetNuke.Entities.Modules
Imports Telerik.WebControls

Namespace Telerik.DNN.Modules.ArtCategoriesModule
    Inherits DotNetNuke.Entities.Modules.PortalModuleBase
        Implements DotNetNuke.Entities.Modules.IActionable
    Public Class ArtCategories
        Private Sub BindComboBox()
           Dim connectionString As String = String.Format("Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=mydb; User ID=,myuserid; Password=mypassword;")
            Dim dbCon As New OleDbConnection(connectionString)
            dbCon.Open()

            Dim adapter As New OleDbDataAdapter("select CategoryID, CategoryName, MasterCategoryID FROM PortalStore_Categories WHERE PortalStore_Categories.MasterCategoryID = 3", dbCon)
            Dim ds As New DataSet()
            adapter.Fill(ds)

            RadComboBox1.DataTextField = "Text"
            RadComboBox1.DataSource = ds
            RadComboBox1.DataBind()
        End Sub 'BindComboBox


        Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
            If Not Page.IsPostBack Then
                BindComboBox()
            End If
        End Sub 'Page_Load


#Region "Web Form Designer generated code"

        Protected Overrides Sub OnInit(ByVal e As EventArgs)
            '
            ' CODEGEN: This call is required by the ASP.NET Web Form Designer.
            '
            InitializeComponent()
            MyBase.OnInit(e)
        End Sub 'OnInit


        '/        Required method for Designer support - do not modify
        '/        the contents of this method with the code editor.
        '/ </summary>
        Private Sub InitializeComponent()
        End Sub 'InitializeComponent

#End Region
    End Class
End Namespace