Hello everybody,

I'm creating a module using C#. I have a table MyModule_Category which has three columns: ItemId, ModuleId and Category. The items of this table will fill a dropdownlist on the first access to page. I need to insert some items in this table when the module is created (then the users which have edit permissions can delete the items they won't or add other items). I'm thinking to create a stored procedured (to which I pass the ModuleId) which does it. This stored procedure is called by a method. The question is: when have I to call the method? I need to call it only when the module is created. How can I do this? 

I really need your help, please reply!

I would probably check if a modulesetting exists or not.

If the modulesetting doesn't exist create the items and then create the modulesetting.

So it will only run once.

Hi deven83,

Here a small example that you can include in your page_load of your module

If not Settings.Contains("yourkey") Then

// do your stuff here

Dim objModuleController as New DotNetNuke.Entitities.Modules.ModuleController
objModuleController.UpdateModuleSetting(Me.ModuleID,"yourkey","any data you want")

End if

The second time the module loads the setting will be created and the code in the if-statement will not be executed

More on modulesettings here : www.adefwebserver.com/DotNetNukeHELP/Personalization/