I am choosing table data from the current user:

SELECT [ConfidenceLevel], [LoveLevel], [HappinessLevel] FROM [UserData] WHERE ([UserProfileID] = @UserProfileID)

I've set a control towards the unique user ID which is obtaining the correct value:

HTML: <asp:Label ID="userID" runat="server" Text="Labeluser"></asp:Label>

C#: userID.Text = Membership.GetUser().ProviderUserKey.ToString();  

Then i utilize it within the where clause while using Configure Databases window
unique ID = control then controlID userID (fills instextual content for me personally)

I compile and run but nothing turns up in which the table ought to be. Any suggestions?

This is actually the code it's produced:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        <asp:BoundField DataField="ConfidenceLevel" HeaderText="ConfidenceLevel" 
            SortExpression="ConfidenceLevel" />
        <asp:BoundField DataField="LoveLevel" HeaderText="LoveLevel" 
            SortExpression="LoveLevel" />
        <asp:BoundField DataField="HappinessLevel" HeaderText="HappinessLevel" 
            SortExpression="HappinessLevel" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionStringToDB %>" 
    SelectCommand="SELECT [ConfidenceLevel], [LoveLevel], [HappinessLevel] FROM [UserData] WHERE ([UserProfileID] = @UserProfileID)">
        <asp:ControlParameter ControlID="userID" Name="UserProfileID" 
            PropertyName="Text" Type="Object" />

i've clarified around the asp.internet page too but just in case you do not see that certain i'll get it done because well...

remove any mention of the "object" the sqldatasource code creates...

it will read:

PropertyName="Text" />

for those who have update and place and remove you will need to take it out of there too...