I need suggestion about user accounts

saf · December 4th, 2006, 04:20 PM

Thank you so much. Works like a charm. Only thing I am trying to do now is only select certain usernames. I put a usertype field in the aspnetdb users table and want to select only usernames that have this value set. Am I going in the right direction? I assume I need some sort of custom paramerter for the getallusers method.
Your help is GREATLY appreciated.

Imar · December 4th, 2006, 04:46 PM

Unfortunately, that is not supported out of the box.

One easy way to do this is to put those users in a specific group and then change the call to Membership.GetAllUsers()

to

Roles.GetUsersInRole(roleName)

That gives you a list of the users in the specified role.

Otherwise, you need to create a custom method that returns a MembershipCollection. Inside this method you could fire a custom stored procedure that returns the users based on your criteria. You can take a look at the standard stored procedures and at the code for the standard SQL providers for some ideas on how to do this.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

saf · December 5th, 2006, 02:49 PM

One last time for a newbie....

I do have all my users that I want to display in a Role (rolename ="Members"), just need a bit more explanation on how to configure the objectdatasource to show all users in role Members...

I changes ODS TypeName to System.Web.Security.Roles, the SelectMethod to GetUsersInRole(StringRolename,returns String[]) and set parameters as follows
<asp:Parameter DefaultValue="Members" Name="roleName" Type="String" />

Am I completely off track...

Once again, thanks in advance for all your help
{

Imar · December 5th, 2006, 06:35 PM

Close, but no cigar.... ;)

Here's what you should do:

Code:

<asp:ObjectDataSource ID="ObjectDataSource1" 
       runat="server" SelectMethod="GetUsersInRole" 
       TypeName="System.Web.Security.Roles">
  <SelectParameters>
    <asp:Parameter DefaultValue="Members" Name="roleName" /> 
  </SelectParameters>
</asp:ObjectDataSource>

Since GetUsersInRole() returns an array of Strings, you don't need to specify the DataValueField and DataKeyField in the dropdown:

Code:

<asp:DropDownList ID="DropDownList1" runat="server" 
        DataSourceID="ObjectDataSource1">
</asp:DropDownList>

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

saf · December 5th, 2006, 07:07 PM

You make it seem so easy. Thank you - Thank You - Thank You!
You save me hours of frustration....
saf

Imar · December 6th, 2006, 08:30 AM

You're welcome. Glad I could help.

In case anyone else is interested in the full solution, I wrote a short article about it here: http://Imar.Spaanjaars.Com/QuickDocId.aspx?quickdoc=409

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Ivo by Cocteau Twins (Track 1 from the album: Treasure) What's This?