Using Visual Web Developer 2008 Express Edition and C# I am attempting to build a page on my site where a user can edit information about themeselves. I am using the built-in membership provider (AspNetSqlProvider) which is working fine to add users, send passwords via email, etc...
I have created an additional table in ASPNETDB.MDF which has a foreign key relationship to UserID in the table aspnet_Users.
In the Configure Data Source tool for the ListView, I "Add a WHERE Clause" attempting to retrieve records where UserID in my additional table = UserID of the currently logged in user. I see the Source Session, but setting the Session Field to "UserID" or "UserName" (when attempting instead to link the tables using that value) always results only in the Default Value.
I have seen in other posts the direction to use NON as the data source and set @UserID by seeting the parameter using:
...
Go to the complete details ...