Ok im a huge noob when it comes to DNN, I just started using it and I'm not too familiar with VB.  My experience has been with c++ and c#.  The problem I am having is that I am trying to change the existing Feedback module that comes with 4.0 to add feedback to a table in my database as well as send a message to the Site admin.  I have created the table for the feedback, and a stored procedure to add the feedback but, I have no clue where to tell the module to use my stored procedure when the send button is clicked.  Heres the stored procedure just to clarify table names etc

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 

/** Create Stored Procedures **/

 

CREATE procedure [dbo].[Portal_AddFeedback]

 

      @FeedbackID       int,

      @ModuleID         int,

      @Name             NVARCHAR(50),

      @Email            NVARCHAR(50),

      @Subject          NVARCHAR(100),

      @Message          TEXT,

      @CreatedByUser    NVARCHAR(100)

 

as

 

BEGIN TRANSACTION

insert into Portal_Feedback

values (

 

      @ModuleID,

      @Name,

      @Email,

      @Subject,

      @Message,

      getdate(),

      @CreatedByUser

)

COMMIT TRANSACTION

 

 

select SCOPE_IDENTITY()

I can tell from looking at how add link works in the links module, that i need a directory for the sqldata, so i created that

DesktopModules\Feedback\Providers\DataProvider\SqlDataProvider

 

In there I have the file 03.01.00.SqlDataProvider which I edited to contain the appropriate sql code.  So what as far as I can tell, all I need to do now is let the module know to run this procedure when the send button is clicked.  Any help on this issue would be much appreciated.

 

 

JS

Woo, very nice.  Thanks for the link.  I will definetely look into useing that module but, I am still curious as to how one would go about making the above procedure work.  I guess the biggest problem I have is that with VB, i dont know where in the code to change it so that when the user hits the send button on the module, my stored procedure is run as well.