Hello, I am working on a module that pull data from a sql server 2005 database table. This table contains some information that is tied to the DNN user ID. In my module, I have a GridView control that gets this data from the table using a stored procedure in my database. The stored procedure has an input parameter of UserID.

I am calling this stored procedure using the following code:

<asp:SqlDataSource ID="rebateDB" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
    SelectCommand="RT_ViewAllRebates" SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:SessionParameter DefaultValue="0" Name="UserID" SessionField="UserInfo.UserID" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

I want to be able to pass in the DNN user ID of the current user so my module will only display the results for that particular user. For the SessionField="", I have tried just using "UserID" but that didn't display any results in my GridView. I tested out the stored procedure using test values for the userID input param in the Configure Data Source wizard in VS2005 and it gave me the results like it is supposed to. So, I guess my question is, what should I use for SessionField so it will pass the integer value of the current user's ID?

Thank you for your help.

Thank you Ian for your response. I used PortalModuleBase.UserID for the SessionField property, but I still did not receive any records in my GridView that are related to the current logged in user (Note: there should be 1 record that shows for the user that I log in as).

Here is how my ascx page is setup:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ViewRebateDB.ascx.cs" Inherits="DotNetNuke.Modules.ViewRebateDB" Explicit="True"%>

It inherits from DotNetNuke.Modules.ViewRebateDB, so should I set that to Inherits="DotNetNuke.Entities.Modules.PortalModuleBase"?

Also here is my ascx.cs code behind:

namespace DotNetNuke.Modules
{
    public partial class ViewRebateDB : DotNetNuke.Entities.Modules.PortalModuleBase
    {
        protected void Page_Load(object sender, EventArgs e)
        {}

    }

}