With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Course Of The Month
1 day, 13 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 today
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 today
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)
Ok, I will give it a try. Do I just paste the code into in the "define custum sql or stored procedure"?
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 today
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
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 today
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
Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses
Course of the Month1 day, 13 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.