Hi,
I am using asp.net membership provider, I have a Country profile field, and now I need to access it for all users (To see which users belongs to specified country).

How can i do that?

Thanx in advance,
Haris

Hi Haris,

The ProfileProvider class has a GetAllProfiles method. As it name suggests, it returns all the available profiles.

Then you can loop through the results and look at each individual profile.

This is not very efficient, but currently you're pretty much limited to this, because of the awkward format that the data is stored in. This makes it pretty hard to write custom methods that query the aspnet_Profiles table.

You can take a look at the Table Profile Provider for a replacement of the current provider, making it easier to fire custom queries: http://www.asp.net/sandbox/samp_prof...ndex=0&tabid=1

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
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: Digital by Joy Division (Track 1 from the album: Heart And Soul (CD 1)) What's This?

Thnks Imar,
I will read it for sure.