Hi Martijn,

Thanks for reply and your suggestion. But using sqldataprovider will only remove those tasks, when I will uninstall the module. Here I want to remove them at the time of removal/deletion of any module instance from any page.

Please suggest how can I do that. 

Thanks again !

Regards,

Namrata Mathur

Namrata,

You are correct that the uninstall sql script will only remove a custom module's data upon uninstallation of the module, not deletion of a module instance from a page.

Although I don't consider it the best practice, most module developers including myself out of necessity must set up a foreign key relationship (with cascade delete enabled) between the module's custom table's ModuleID column and the ModuleID column of the core Modules table. Note that your custom table's ModuleID column must be set to not allow nulls. Other than that, I'm not sure why you were unable to set up the FK relationship.

Even with this approach note that data for a particular ModuleID will not be deleted until all reference instances of the module are removed from all site pages AND are removed from the recycle bin.

---

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