Use currently logged-in user in query

Posted by Degan on Stack Overflow See other posts from Stack Overflow or by Degan
Published on 2009-06-11T14:23:57Z Indexed on 2010/05/16 20:40 UTC
Read the original article Hit count: 158

Filed under:

visual-web-developer

|

visual-studio-express

|

ms-access

|

asp.net-membership

|

c#

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?

© Stack Overflow or respective owner

Related posts about visual-web-developer

Creating an ASP.NET Database using MS SQL 2008 in Visual Web Developer 2008

as seen on ASP Free - Search for 'ASP Free'
This article illustrates how to create a database in ASP.NET. We ll be using Microsoft SQL Server 2 8 and developing it in Visual Web Developer Express 2 8. Given the importance of databases to most websites nowadays you should find this information useful when building just about any website… >>> More
ASP.NET 3.5 Debugging Using Visual Web Developer Express 2008

as seen on ASP Free - Search for 'ASP Free'
One of the most important features in Visual Web Developer Express 2 8 in developing ASP.NET 3.5 websites is the debugging feature. Having a debugger is important in troubleshooting source code and application-related problems. It will save you a lot of time if you encounter and fix problems during… >>> More
Visual Web Developer 2008 Express Edition Solution File

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a new ASP.NET website using Visual Web Developer 2008 Express edition and am not able to find the solution file. Does Visual Web Developer 2008 Express edition generate a solution file when we create a new ASP.NET website ? How can I open multiple websites within the same IDE window? Thanks… >>> More
Visual Web Developer 2008 Express and XHTML 1.1 (not applying)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. I may be missing something since I'm not used to work with IDEs for web development, so please understand if I'm doing something stupid. I've picked a copy of Beginning ASP.NET 3.5 in C# and VB to try and learn this thing quickly. I'm no HTML guru, but I know something about the DTDs and… >>> More
Spell checker 2.3 for Visual Studio 2008 SP1

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Minor update for the Spell checker add-in for VS 2008 SP1. It is now available at Visual Studio Gallery . Direct link: http://visualstudiogallery.msdn.microsoft.com/en-us/2f3d691d-8838-4d84-ad64-44a02db37e30 What's new in version 2.3: Updated native Read More......(read more) >>> More

Related posts about visual-studio-express

IE7 Debugging with Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I debug IE7 javascript with Visual Studio Express and which version should I use? >>> More
IE Debugging with Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I debug IE javascript with Visual Studio Express and which version should I use? >>> More
Behavior of deployment tool in Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a quick game in VS Express (2008) and used the built-in deployment tool (click once?) to create an installer. I took it to another computer, ran it (Windows XP) to install from a burned CD. It created the program but only for the logged in user. Is there a setting I'm missing for installing… >>> More
Windows Forms in Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
Good day, can I ask one question about Windows Forms? As far as I know Windows Forms is Win32 wrapper like MFC, created for use with .NET. But, what I dont know is, can you use windows forms and compile directly to native code? Becouse in Visual Studio Express, there is windows forms available only… >>> More
Source Versioning for Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any Visual Studio Express plug ins for source versioning? I am starting a project on my own and only have the Express version of Visual Studio 2008. >>> More