How i can select data from user profiles

ssomchai · April 29th, 2008, 09:28 PM

if i want to select data from user profiles such as member who live in thailand ,or member who have occupation is "xxxxx" and so on how i can do this.
thank

Lee Dumond · April 30th, 2008, 11:57 AM

I think the easiest way to do this would be to loop through all of the users, getting their profiles, and checking the profile property you are interested in for the criterion you specify (for example, if the country is Thailand). For display purposes, you could add each matching user to a collection and bind that to a GridView.

Lee Dumond · April 30th, 2008, 01:17 PM

I went ahead and did up a little example of it below.

================================================== =====

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            ddlCountries.DataSource = MB.TheBeerHouse.Helpers.GetCountries();
            ddlCountries.DataBind();
        }
    }

    protected void ddlCountries_SelectedIndexChanged(object sender, EventArgs e)
    {
        MembershipUserCollection myUsers = new MembershipUserCollection();
        string searchCountry = ddlCountries.SelectedItem.Text;

        foreach (MembershipUser user in Membership.GetAllUsers())
        {
            ProfileCommon profile = Profile.GetProfile(user.UserName);
            if (profile.Address.Country == searchCountry)
            {
                myUsers.Add(user);
            }
        }

        gvwUsers.DataSource = myUsers;
        gvwUsers.DataBind();
    }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Profile Search</title>
</head>
<body>
    <form id="form1" runat="server">
        Choose country:
        <asp:DropDownList ID="ddlCountries" runat="server" AppendDataBoundItems="True" OnSelectedIndexChanged="ddlCountries_SelectedIndex Changed"
            AutoPostBack="True">
            <asp:ListItem Value="" Selected="True">Please select one...</asp:ListItem>
        </asp:DropDownList>
        <asp:GridView ID="gvwUsers" runat="server">
            <EmptyDataTemplate>
                There are no users in that country.
            </EmptyDataTemplate>
        </asp:GridView>
    </form>
</body>
</html>

kalel_4444 · April 30th, 2008, 04:55 PM

ssomchai,

To recap a topic you started: "How i can modify the User profle" http://p2p.wrox.com/topic.asp?TOPIC_ID=69543. A discussion about using the SqlTableProfileProvider was opened up.

Myself, I ended up downloading, installing, and using it. Once I got through a couple of small problems, it has been quite easy to work with. Adding and removing profile fields, and using simple SQL queries in SPROC's against the ProfileTable to select information in it, and then simply dump them into a GridView.

If you use the SqlTableProfileProvider, you'll be able to create queries as simple as:

Code:

SELECT * FROM ProfileTable WHERE Country = 'Thailand';

and then drop it into a GridView.

Hope this opens up another alternative,
Ronnie

ssomchai · April 30th, 2008, 09:07 PM

very Thank everyone

ssomchai · April 30th, 2008, 09:22 PM

Another question, if i want to send Newletters in group such as group of membership in thailand, or group of gender, or group of occupation, how i can do this?