storing the login name in my personal database

saif44 · March 3rd, 2006, 03:06 PM

Hi folks,

does anyone know how to pick the login name that the user type to access the website and store it in a personal database.

what i did:

i took the 'login name' from the toolbox and add it to my page. once the person logs in, his name is displayed on the 'login name'. in my case i want to take that log in name and store it in one of my database tables. so what i did was as follow:

i took the 'username id' from the properties which is [u]'loginname1'</u> and assigned it to this code:
objCmd.Parameters.Add("@RequestedBy", Data.SqlDbType.VarChar).Value = LoginName1.ToString
this then will be stored in my table under the 'requestedby' column. however, data has been successfully entered but when i checked the table, i found under the 'requedby' column the following name: System.Web.UI.WebControls.LoginName.
i have big fate that someone knows how to do this. can you please?

jbenson001 · March 3rd, 2006, 04:01 PM

You are accessing the object itself, not the user name textbox. Try:
objCmd.Parameters.Add("@RequestedBy", Data.SqlDbType.VarChar).Value = LoginName1.Username

saif44 · March 3rd, 2006, 05:30 PM

thank you very much jbenson001. what i would like to say here is that the loginname1 is dragged from the toolbox under the login tab. if you check it you will only see that it has a id property and not a text property.

so the problem here is how can i get the name of the loginname1 assigned to my column after i submit the data.

thanks for all the helps.

Imar · March 3rd, 2006, 08:07 PM

The LoginName control is just to do what its name implies: display the login name and nothing more. So, it doesn't have properties like UserName.

Instead, use this:

string userName = User.Identity.Name;

or

string userName = Membership.GetUser().UserName;

to get the user's name.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

jbenson001 · March 4th, 2006, 12:20 AM

A login control has a username textbox and password textbox, a loginview DOES NOT, as Imar has stated. So, if you are using the login control, you can access it. You are probably best using Imar's code. This way when you get the name, you know the user has been authenticated.

saif44 · March 4th, 2006, 02:12 PM

thank you very much for everyone.

the following script has worked:
objCmd.Parameters.Add("@RequestedBy", Data.SqlDbType.VarChar).Value = user.identity.name

shario · June 8th, 2006, 03:50 PM

I am having the same issue, however, I am new to codeing. Either I am an idiot or this is so simple it is staring me in the face.

Originally I wanted to extend the aspnet_User table. Not an option. I need to store much more information about each user. So... I created an Accounts table with the fields I needed ( pkAccountID, FirstName, lastName, homePhone, etc). I added a field to store their username (accountUsername, nvarchar(256)) just like the aspnet_User.UserName field.

Okay...now, after their account is created they are redirected to an account information page that is attached to this database with a Details View, (default view INSERT). I need to pass the loginName from the aspnet_User table into the accountUserName field so that I can use that as a filter for them to add and update their information later.

I need to know in very basic terms what code I need, exactly where to put it, etc. This post is helpful, but WHERE do I put the code

objCmd.Parameters.Add("@RequestedBy", Data.SqlDbType.VarChar).Value = LoginName1.Username

and/OR

string userName = Membership.GetUser().UserName;

Here is my code:
<body>
    <form id="form1" runat="server">
    <div>
         Welcome
        <asp:LoginName ID="lblLogInName" runat="server" />
        !<br />
        <br />
    </div>
             
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
            DefaultMode="Insert" Height="50px" Width="125px" DataKeyNames="loginName" AutoGenerateInsertButton="True" DataMember="DefaultView" EmptyDataText="No Data">
            <Fields>
                <asp:TemplateField HeaderText="accountUserName" SortExpression="accountUserName">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("accountUserName") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:Label ID="lblAcctUserName" runat="server" OnDataBinding="Page_Load" Text='<%# Eval("accountUserName") %>'></asp:Label>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("accountUserName") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="accountFirstName" HeaderText="accountFirstName" SortExpression="accountFirstName" />
                <asp:BoundField DataField="accountLastName" HeaderText="accountLastName" SortExpression="accountLastName" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connectionName %>"
            DeleteCommand="DELETE FROM [tblUserDetails] WHERE [accountID] = @accountID" InsertCommand="INSERT INTO tblUserDetails(accountUserName, accountFirstName, accountLastName) VALUES (@UserName, @accountFirstName, @accountLastName)"
            ProviderName="<%$ ConnectionStrings:connectionName.ProviderName %>"
            SelectCommand="SELECT accountUserName, accountFirstName, accountLastName FROM tblUserDetails"
            UpdateCommand="UPDATE [tblUserDetails] SET [accountUserName] = 'TEST', [accountFirstName] = @accountFirstName, [accountLastName] = @accountLastName WHERE [accountID] = @accountID">
            <DeleteParameters>
                <asp:Parameter Name="accountID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="UserName" />
                <asp:Parameter Name="accountFirstName" Type="String" />
                <asp:Parameter Name="accountLastName" Type="String" />
                <asp:Parameter Name="accountID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="UserName" DefaultValue = "Test"
            />
                <asp:Parameter Name="accountFirstName" Type="String" />
                <asp:Parameter Name="accountLastName" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
         
    </form>
</body>

Once they leave this screen they will not go back, will never change their username, etc. I only need to create an entry in this table ONE time so that I can use it for future.

Anyone who can help me would be soooo appreciated. I am overdue on this project, my client is furious and I have searched high and low on specific instructions on how to do this for two days.

Thank you!!!

Imar · June 8th, 2006, 04:10 PM

Hi shario,

What you can do, is override the value of the UserName property inside the Inserting event of the DetailsView:

Protected Sub DetailsView1_ItemInserting(ByVal sender As Object, _
   ByVal e As System.Web.UI.WebControls.DetailsViewInsertEventAr gs) _
   Handles DetailsView1.ItemInserting

  e.Values("UserName") = User.Identity.Name

End Sub

The Values collection holds a collection with name / value items thar are to be sent to the database. By accessing the UserName item you can override / set its value with the user's name.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

shario · June 9th, 2006, 01:14 AM

Imar -

OMG!!! How much do I love you? That worked perfectly. I noticed that you answer a lot of postings and I want to thank you, thank you, thank you!

I started the next text and...Next challenge. I thought when that when I had a field in the database that matched the username, I could use a WHERE clause in my database to filter (ie. accountUserName = username)... This is not working.

Here is the scenario
  1. User creates account.
  2. Login lands at the form we just created and enters detailed information in tblAccounts. Username populates accountUserName field (thanks to you). Submit takes them to a page accountDetails.aspx, a detailsview that is filtered by username.
3. User Logs out
4. When User logs back in, the login takes them back to accountDetails.aspx filtered by the username. They can edit details if needed. (WHERE accountUserName = username).

I created the accountDetails.aspx page and filtered the datasource by session field username.

Here is the code from the form...

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
        DataKeyNames="" DataSourceID="SqlDataSource1" Height="50px" Width="125px">
        <Fields>
            <asp:BoundField DataField="accountID" HeaderText="accountID" InsertVisible="False"
                ReadOnly="True" SortExpression="accountID" />
            <asp:BoundField DataField="accountUserName" HeaderText="accountUserName" SortExpression="accountUserName" />
            <asp:BoundField DataField="accountFirstName" HeaderText="accountFirstName" SortExpression="accountFirstName" />
            <asp:BoundField DataField="accountLastName" HeaderText="accountLastName" SortExpression="accountLastName" />
        </Fields>
    </asp:DetailsView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connCPFAAEvents %>"
        DeleteCommand="DELETE FROM [tblUserDetails] WHERE [accountID] = @accountID" InsertCommand="INSERT INTO [tblUserDetails] ([accountUserName], [accountFirstName], [accountLastName]) VALUES (@accountUserName, @accountFirstName, @accountLastName)"
        ProviderName="<%$ ConnectionStrings:connectionName.ProviderName %>"
        SelectCommand="SELECT [accountID], [accountUserName], [accountFirstName], [accountLastName] FROM [tblUserDetails] WHERE ([accountUserName] = @accountUserName)"
        UpdateCommand="UPDATE [tblUserDetails] SET [accountUserName] = @accountUserName, [accountFirstName] = @accountFirstName, [accountLastName] = @accountLastName WHERE [accountID] = @accountID">
        <DeleteParameters>
            <asp:Parameter Name="accountID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="accountUserName" Type="String" />
            <asp:Parameter Name="accountFirstName" Type="String" />
            <asp:Parameter Name="accountLastName" Type="String" />
            <asp:Parameter Name="accountID" Type="Int32" />
        </UpdateParameters>
        <SelectParameters>
            <asp:SessionParameter Name="accountUserName" SessionField="username" Type="String" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="accountUserName" Type="String" />
            <asp:Parameter Name="accountFirstName" Type="String" />
            <asp:Parameter Name="accountLastName" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>

Thank you again!

P.S. Just to clarify for visitors to this post, I am using code-behind. All I had to do was open the webpage.aspx.vb file and paste the text into the page.

Imar · June 9th, 2006, 01:31 AM

Hi shario,

You're welcome. Glad it's working now.

Not sure if you are asking a new question, or explaining to others how you made it work. If it's a question, you seem to be using a Session field in the WHERE clause for the SELECT command. Are you sure that this session variable contains the user's name?

Alternatively, you can perform the same trick as I showed you earlier with the Selecting event:

Code:

  Protected Sub ObjectDataSource1_Selecting(ByVal sender As Object, _
          ByVal e As System.Web.UI.WebControls.ObjectDataSourceSelectingEventArgs) _
          Handles ObjectDataSource1.Selecting
    e.InputParameters("UserName") = User.Identity.Name
  End Sub

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004