Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
COURSE of the MONTH
12 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
ASP.NET 4 Visual Studio 2010. Membership Website Question
Posted on 2011-03-09
I have a asp.net 4 membership web with roles. When a user goes to change his password, I want to display that particular users Password Questiion. I added a dataset form view to the membership database and am able to achieve this by a sql query when I specify the users actual name in the query. I want to change my code to query the databased based on the user that is logged in.
Basically I want to change the part in my code that says
WHERE (aspnet_Users.UserName = 'RICK')
to something like
Where aspnet_users.username = (the currently logged in user)
I am not sure what to replace "the logged in user" with to make it equal the currently logged in user
any help would be appreciated.
Basically I want to change the part in my code that says
WHERE (aspnet_Users.UserName = 'RICK')
to something like
Where aspnet_users.username = (the currently logged in user)
I am not sure what to replace "the logged in user" with to make it equal the currently logged in user
any help would be appreciated.
SELECT aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserName = 'RICK')
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
8
6
14 Comments
Active 3 days ago
Are you using inline SQL or calling a stored procedure? If it is inline you would do something like (assuming C#):
string username = Membership.GetUser().UserName;
string sql = string.Format("SELECT aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserName = '{0}')
", username);
Active 3 days ago
In that case:
Dim username As String = Membership.GetUser().UserName
Dim sql As String = String.Format("SELECT aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserName = '{0}')
", username)
Active 4 days ago
Ok, I will give it a try. Do I just paste the code into in the "define custum sql or stored procedure"?
Active 4 days ago
I added a list view, then made a connection string to the membership database. Then I am at the part where I am creating the custom sql query to return the question. Thank you so much
Active 3 days ago
Ah, ok, that sounds like you are using a SqlDataSource, which means you need to massage things a little to get it to work. In the dialog choose "Custom sql query...." then for the "select statement" paste your SQL statement as:
SELECT aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE aspnet_Users.UserName = @UserName
<asp:SqlDataSource ID="SqlDataSource1" runat="server" OnSelecting="SqlDataSource1_Selecting"
SelectCommand="SELECT aspnet_Membership.PasswordQuestion, aspnet_Membership.PasswordAnswer FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE aspnet_Users.UserName = @UserName">
<SelectParameters>
<asp:Parameter Name="UserName" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
Protected Sub SqlDataSource1_Selecting(sender As Object, e As SqlDataSourceSelectingEventArgs)
SqlDataSource1.SelectParameters("UserName").DefaultValue = Membership.GetUser().UserName
End Sub
Active 4 days ago
OK. When I put the first code in, it takes me to another screen that says it recognizes I have a parameter "username" It is asking me for a parameter source, a query string fiels and a default value
Active 3 days ago
Ah, it's a little smarter than I gave it credit for :) Leave the source set to "None" and the default value empty, unless you want to give it a default.
Featured Post
We will be discussing what Azure Stack is, how does it fit into the suit of offerings that Azure has currently, and where can it fit into your organizations technology stack. We will also be discussing limitations of the platform while covering various applicable scenarios.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
The viewer will learn how to count occurrences of each item in an array.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
Suggested Courses
Course of the Month12 days, 11 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.