I bet you were using VB too.  I am using C#, so that is probably the difference ;)

The following is my widgetInfo.vb BLL that was created using the DotNetNuke 4.0.0 Starter Kit and Templates tutorial. I added the CreatedByUserName property to this class and then tried to modify the getWidget stored procedure adding 'dnn_users.userName As CreatedByUserName' into the field listing. I then tried to populate the objWidget.CreatedByUserName property in the Page_Load event of ViewWidget.ascx.vb. At that point I recieved a runtime error after rebuilding and running the DNN instance so I remed everything out that I added and am ready to drive on with the bug. ' ' DotNetNuke® - http://www.dotnetnuke.com ' Copyright (c) 2002-2006 ' by Perpetual Motion Interactive Systems Inc. ( http://www.perpetualmotion.ca ) ' ' Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated ' documentation files (the "Software"), to deal in the Software without restriction, including without limitation ' the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and ' to permit persons to whom the Software is furnished to do so, subject to the following conditions: ' ' The above copyright notice and this permission notice shall be included in all copies or substantial portions ' of the Software. ' ' THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED ' TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL ' THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF ' CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER ' DEALINGS IN THE SOFTWARE. ' Imports System Imports System.Configuration Imports System.Data Namespace YourCompany.Modules.Widget '''

''' The Info class for Widget '''

''' ''' ''' ''' ''' ----------------------------------------------------------------------------- Public Class WidgetInfo ' local property declarations Private _ModuleId As Integer Private _ItemId As Integer Private _Content As String Private _CreatedByUser As Integer ' Private _CreatedByUserName As String Private _CreatedDate As DateTime ' initialization Public Sub New() End Sub ' public properties Public Property ModuleId() As Integer Get Return _ModuleId End Get Set(ByVal Value As Integer) _ModuleId = Value End Set End Property Public Property ItemId() As Integer Get Return _ItemId End Get Set(ByVal Value As Integer) _ItemId = Value End Set End Property Public Property Content() As String Get Return _Content End Get Set(ByVal Value As String) _Content = Value End Set End Property ' Public Property CreatedByUserName() As String ' Get ' Return _CreatedByUserName ' End Get ' Set(ByVal Value As String) ' _CreatedByUserName = Value ' End Set ' End Property' Public Property CreatedByUser() As Integer Get Return _CreatedByUser End Get Set(ByVal Value As Integer) _CreatedByUser = Value End Set End Property Public Property CreatedDate() As DateTime Get Return _CreatedDate End Get Set(ByVal Value As DateTime) _CreatedDate = Value End Set End Property End Class End Namespace