Use currently logged-in user in query

Question

I am using VisualWebDeveloperExpress2008 with Access as the membership provider.

I have some cases where I want users to edit their own data. This would involve a query where the UserId should equal the UserID of the user who is using the site.

I am expecting to use WHERE UserId = ?, but I have not found out where to direct "?".

The IDE gives several choices, but I am uncertain which to choose. This, while it looks promising does not work:

<SelectParameters>
    <asp:ProfileParameter Name="UserID" PropertyName="UserId" Type="Int32" />
</SelectParameters>

What is best to use for the Select Parameter?

Answer 1

User.Identity.Name should provide you the username of the logged in user.

Now, to get the UserID you will need to check it in the database using the username. Or you can make it so that the select statement uses the username instead.

Answer 2

Try using

<SelectParameters>
    <asp:SessionParameter Name="UserName" SessionField="CurrentUser" Type="String" />
</SelectParameters>

On the Page_Load insert the following...

Session["CurrentUser"] = User.Identity.Name;

This should work for you.