Thread: How canl I Retrieving CustomerID?

please does anyone knows how to retrieve Current Logged in customerId. Will like to use it to query the datase using SQL.

Here's an example from an xmlpackage :-

HTML Code:

    <query name="Customer" rowElementName="Item">
        <sql>
            <![CDATA[
            SELECT * FROM Customer WHERE CustomerID = @CustomerID
            ]]>
        </sql>
        <queryparam paramname="@CustomerID" paramtype="system" requestparamname="CustomerID" sqlDataType="int" defvalue="0"  validationpattern="^\d{1,10}$" />
    </query>

TTFN

BFG

Thanx for ur help. isnt there anyway I can retrieve it programatically using c#?

If you look at the source of pages such as checkoutpayment.aspx.cs, you'll see in the Page_Load() method:

Code:

ThisCustomer.RequireCustomerRecord();
...
if (!ThisCustomer.IsRegistered)

This allows access to the currently connected and registered customer. And you can then pass ThisCustomer.CustomerID to a SQL query.

C#/VB.NET Code:

Customer.Current.CustomerID 


As long as you are using the aspdotnetstorefrontcore it should work fine.