I used Codesmith to create my DAL for a module to be used in DNN 4.0.3 and everything is working fine.  The module is basically a Gridview that is linked to a table in my DNN Database and it is working the way it supposed to.  The problem I’m having is that I don’t know how to get the Gridview to display an additional field I added to my List procedure. As follows:

 

-- To simplify my code, I’m using a little different example

******The stored Procedure

Select

A.StudentID,

A.StudentName,

A.FacilityID,

‘FacilityName’ = B.FacilityName          --  This is the additional I’m trying to add

From students A inner join Facilities B on A.FacilityID = B.FacilityID

 

 

 

*******I also modified my studentsInfo.vb file as follows:

 

   Public Class StudentsInfo

 

#Region "Private Members"

        Dim _studentID As Integer

        Dim _studentName As String

        Dim _facilityID As Integer

        Dim _facilityName As String ‘ the new added field

 

.

.

.

Public ReadOnly Property FacilityName() As String

            Get

                Return _facilityName

            End Get

End Property

 

 

*******Finally, I added a new column to my GridView that points to FacilityName but it always shows blank.  What am I missing??

 

 

If your business controller class follows the usual DNN pattern of calling CBO.FillObject and/or CBO.FillCollection to obtain a StudentsInfo object or collection of StudentsInfo objects, the FacilityName property cannot be ReadOnly.  If the property is ReadOnly, the reflection used in the CBO class will skip over the property resulting it being blank. Add a setter to the property:

Public Property FacilityName () As String
     Get
         Return _facilityName
     End Get
     Set (ByVal value As String)
         _facilityName = value
     End Set
End Property

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner