All,

I'm trying to customize the DAL2 module template to view and insert data from an existing table but I'm getting an error (see below).

After I created the project, I changed the column names to match the columns in my existing table and did the same to the code but it's not working.

Another issue - when I add records, I get the same error although the records do get inserted in to the database. My guess is that the error is occurs after the record gets inserted and the page reloads to display all the records.

Does anyone know how I can trace this error?

Thanks,
Mark

Error:

Message:

System.NullReferenceException: Object reference not set to an instance of an object.
at DotNetNuke.Data.DataUtil.GetColumnName(PropertyInfo propertyInfo, String defaultName)
at DotNetNuke.Data.PetaPoco.PetaPocoRepository`1.GetScopeSql()
at DotNetNuke.Data.PetaPoco.PetaPocoRepository`1.GetByScopeInternal(Object propertyValue)
at DotNetNuke.Data.RepositoryBase`1.<>c__DisplayClass2`1.b__1(CacheItemArgs c)
at DotNetNuke.Common.Utilities.DataCache.GetCachedDataFromRuntimeCache(CacheItemArgs cacheItemArgs, CacheItemExpiredCallback cacheItemExpired)

Cathal,

Sorry for the delay; I just got back to this.

I'm still not having any luck. I did a find --> replace to ensure I had the table and collumns spelled correctly. I also scripted the table to a window and copied and pasted the exact names to the Item.cs file. Everything seems fine and like I stated in my initial post, the insert of new items works fine. The error occurs when the page loads and retrieves and binds the data to the repeater. Below is the error.

What I find odd is that I can remove everything from the repeater in view.ascx and still get the error. Here's my repeater with no mention of columns:

< asp: Repeater ID="rptItemList" runat="server" >
< /asp: Repeater >

This suugests to me that the error is occuring in another part of the project when this line is executed in view.ascx:

rptItemList.DataSource = tc.GetItems(ModuleId);

Again, this project works fine if I use the default settings. Once I remove the sql scripts from the 2 .SqlDatProvider files to use an existing table, I get this error.

I'm open to any tips or suggestions to get this working.

Thanks,
Mark

For others...

When I have run into this, it was because the Scope and Primary Key values are case-sensitive.

---

Will Strohl

Upendo Ventures DNN experts since 2003 Official provider of the Hotcakes Commerce Cloud and SLA support