Returning UserId from Membership.GetAllUsers()

Question

User940894612 posted

Hi,

I am trying to implement a user access management area where a gridview is displayed with users details.  I am however trying to return the userid from the Membership.GetAllUsers() function via a Gridview.  My current code is like so:   

<asp:GridView ID="UserGrid" AutoGenerateColumns="False" runat="server">
        <Columns>
                <asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" SortExpression="UserName" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="PasswordQuestion" HeaderText="PasswordQuestion" ReadOnly="True"
                    SortExpression="PasswordQuestion" />
                <asp:BoundField DataField="Comment" HeaderText="Comment" SortExpression="Comment" />
                <asp:CheckBoxField DataField="IsApproved" HeaderText="IsApproved" SortExpression="IsApproved" />
                <asp:CheckBoxField DataField="IsLockedOut" HeaderText="IsLockedOut" ReadOnly="True"
                    SortExpression="IsLockedOut" />
                <asp:BoundField DataField="LastLockoutDate" HeaderText="LastLockoutDate" ReadOnly="True"
                    SortExpression="LastLockoutDate" />
                <asp:BoundField DataField="CreationDate" HeaderText="CreationDate" ReadOnly="True"
                    SortExpression="CreationDate" />
                <asp:BoundField DataField="LastLoginDate" HeaderText="LastLoginDate" SortExpression="LastLoginDate" />
                <asp:BoundField DataField="LastActivityDate" HeaderText="LastActivityDate" SortExpression="LastActivityDate" />
                <asp:BoundField DataField="LastPasswordChangedDate" HeaderText="LastPasswordChangedDate"
                    ReadOnly="True" SortExpression="LastPasswordChangedDate" />
                <asp:CheckBoxField DataField="IsOnline" HeaderText="IsOnline" ReadOnly="True" SortExpression="IsOnline" />
            </Columns>
    </asp:GridView>

Code behind:

UserGrid.DataSource = Membership.GetAllUsers(currentPage, pageSize, out totalUsers);
UserGrid.DataBind();

I would like to create a column at the start listing the userid - any ideas how to do it? 

Thanks

Rob

Answer 1

User283571144 posted

Hi Robbied81,

I would like to create a column at the start listing the userid - any ideas how to do it? 

As far as I know, Membership.GetAllUsers() method allow us to get a collection of all the users in the database.

Membership class GetAllUsers() method exists in System.Web.Security namespace.

GetAllUesrs() method return value type is System.Web.Security.MembershipUserCollection.

This return value is a MembershipUserCollection of MembershipUser objects representing all of the users in the database.

According to MSDN, MembershipUser class contains a property named ProviderUserKey, this is userID in membership.

So you just add this datafield in the gridview.

More details, you could refer to follow codes:

<asp:GridView ID="UserGrid" AutoGenerateColumns="False" runat="server">
        <Columns>
                <asp:BoundField DataField="ProviderUserKey" HeaderText="ProviderUserKey" ReadOnly="True" SortExpression="ProviderUserKey" />
                <asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" SortExpression="UserName" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="PasswordQuestion" HeaderText="PasswordQuestion" ReadOnly="True"
                    SortExpression="PasswordQuestion" />
                <asp:BoundField DataField="Comment" HeaderText="Comment" SortExpression="Comment" />
                <asp:CheckBoxField DataField="IsApproved" HeaderText="IsApproved" SortExpression="IsApproved" />
                <asp:CheckBoxField DataField="IsLockedOut" HeaderText="IsLockedOut" ReadOnly="True"
                    SortExpression="IsLockedOut" />
                <asp:BoundField DataField="LastLockoutDate" HeaderText="LastLockoutDate" ReadOnly="True"
                    SortExpression="LastLockoutDate" />
                <asp:BoundField DataField="CreationDate" HeaderText="CreationDate" ReadOnly="True"
                    SortExpression="CreationDate" />
                <asp:BoundField DataField="LastLoginDate" HeaderText="LastLoginDate" SortExpression="LastLoginDate" />
                <asp:BoundField DataField="LastActivityDate" HeaderText="LastActivityDate" SortExpression="LastActivityDate" />
                <asp:BoundField DataField="LastPasswordChangedDate" HeaderText="LastPasswordChangedDate"
                    ReadOnly="True" SortExpression="LastPasswordChangedDate" />
                <asp:CheckBoxField DataField="IsOnline" HeaderText="IsOnline" ReadOnly="True" SortExpression="IsOnline" />
            </Columns>
    </asp:GridView>

Link:

MembershipUser Class

Best Regards,

Brando

Answer 2

User940894612 posted

Thanks for that :-)