Hi all,

I've produced a few Modules for DNN now but when i attempted to use the database using the dataproviders i hit a problem.

What i wanted to do is take the defualt DNN module template (the one whith the simple datalist you can add stuff too) and turn it into an editable product advert.  So i now want it to load an image some text and a price instead of just text.  I went through and updated the sqlDataProvider, the DataProvider, the module controller, module info class, and the stored procedures.

I now have a module that lets you edit it by clicking on the pencil icon next to each item in the list.  You can then enter some 'text' and a url.  The 'text' is what was created by the dnn template. I can get the module to update the text and the url but i can't get it to load both from the datbase.  Text appears fine but the url is being returned as null.

I checked the database and it is updating fine.  ie if i type a url into the editpage then click update the new url is in the database just not on the screen.

Anyway i've been stuck on this for a while and wondered if you guys could notice something obvious i'm missing.

I don't think its a problem with how i'm displaying the data, as theres no data to display. 

The module i've created (BestSellers) is able to get its info class from the database but the extra parameter i added 'ImgUrl' is always returned null.  If i look directly at the database i correctly set the url when i entered it in the edit page.  It just can't retrieve it.

I've checked the stored procedures and everything looks fine. 

create procedure {databaseOwner}{objectQualifier}YourCompany_GetBestSellers

    @ModuleId int,
        @ItemId int

as

select ModuleId,
       ItemId,
       Content,
       Url,
       CreatedByUser,
       CreatedDate
from {objectQualifier}YourCompany_BestSellers with (nolock)
left outer join {objectQualifier}Users on {objectQualifier}YourCompany_BestSellers.CreatedByUser = {objectQualifier}Users.UserId
where  ModuleId = @ModuleId
and ItemId = @ItemId
GO
 

Heres some of the load_page code:

BestSellersController objBestSellerss = new BestSellersController();
BestSellersInfo objBestSellers = objBestSellerss.GetBestSellers(ModuleId, ItemId);
if (objBestSellers.ImgUrl != null)
{
    lblStatus.Text = "url: " + objBestSellers.ImgUrl + " contents: " + objBestSellers.Content;
    txtUrl.Text = objBestSellers.ImgUrl;
    txtContent.Text = objBestSellers.Content;
    ctlAudit.CreatedByUser = objBestSellers.CreatedByUser.ToString();
    ctlAudit.CreatedDate = objBestSellers.CreatedDate.ToString();                           
}

In the above code I am trying to retrieve the data to display in the edit page on page_load. txtContent.Text = objBestSellers.Content; works fine.