How do I specify table data only for the current user's ID (VWD asp.net 3.5) ?

Posted by Greg McNulty on Stack Overflow See other posts from Stack Overflow or by Greg McNulty
Published on 2010-06-07T05:27:50Z Indexed on 2010/06/07 5:32 UTC
Read the original article Hit count: 395

I'm using the Details View control of VWD asp.net 2008

I have a users database table and one of the columns contain the "unique" user's profile ID, created by VWD from the automatic profiles table.

From my table, I would like to select only the data pertaining to the logged in user. How do I get the current unique user profileID and then have that used for the query?

What I have so far:
In the configure data source option of the control I select the columns I would like to display, select the check box for "Return Only Unique IDs" and the WHERE option. In this new window I select the Column to the profile userID ... "=" and then assumed I should select Source: "Profile".

Now what should the parameter properties or value be to select only the logged userID specific data of the table?

Any help is appreciated.
Thank You!

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql-server