RE: getting Membership userid to use and store in a custom databas



Hello,
Ok I have been this profile stuff somewhat working,
however it is not saving the profile info for each user right here is the
record of the two differnt users from the asp_profile table:
record 1 shippingtest user
{AF8020C2-4D36-47EE-B4EE-4D42AE080FD0}
PreferredBackgroundColor:B:0:187:<Binary> 11/15/2005 3:57:22 PM
record 2 djp user
{8DFE1B7D-2637-4DB8-862C-296F277BA77E}dbman_id_letter:S:0:1:PreferredBackgroundColor:B:0:187:dbman_user_password:S:1:4: QDP99 <Binary> 11/15/2005
3:55:20 PM

the page code is : ( i do use master pages)

Enter your preferred background color:
<asp:DropDownList ID="ddlColor" runat="server">
<asp:ListItem>Aqua</asp:ListItem>
</asp:DropDownList><br />
<br />
Enter your dbman email letter(case sensitive):<br />
<asp:TextBox ID="dbmanletter" runat="server"></asp:TextBox><br />
<br />
Enter your dbman sales code:<br />
<asp:TextBox ID="dbmancode" runat="server"></asp:TextBox><br />
<br />
<asp:button id="btnUpdatePreferences" runat="server" text="Click
to update your profile" onclick="btnUpdatePreferences_Click" />
<br />

The code behind is:

Partial Class MyProfile
Inherits System.Web.UI.Page

Sub btnUpdatePreferences_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
'Profile.PreferredBackgroundColor =
Color.FromName(ddlColor.SelectedValue)
Profile.dbman_id_letter = dbmanletter.Text
Profile.dbman_user_password = dbmancode.Text
Response.Redirect(Request.Url.LocalPath)
End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
dbmancode.Text = Profile.dbman_user_password
dbmanletter.Text = Profile.dbman_id_letter
End Sub
End Class

I commented out this time because i am not sure yet and have not researched
yet how to put system.drawing in a code behind page thus i commented out
that line
'Profile.PreferredBackgroundColor = Color.FromName(ddlColor.SelectedValue)

for the djp user the stuff works file, but for the other shiptest users the
dbman letter and dbman code do not save

I really hope you expand on this prfile area in the future because I dont
see it being a viable for storeing a customers multiple shipping address
(unless it is because i have nto played with the seralization yet) and then
for creating reports such as mailing list using there address i see there has
to be alot of extra work splitting up the fields to pull the data directly
from the database for say a crystal report..

Tdar









"Steven Cheng[MSFT]" wrote:

> Thanks for your response Tdar,
>
> As for the profile service, it can be configured to use any different
> underlying data strorage as long as there is proper provider for it(By
> default we use Sql data store). And of course we can store mutliple lists
> or other class instance or objects in the profile db for each user , the
> requirement is that those class must be serializable (since it'll be
> serialized before persisted into profile db...).
>
> Thanks,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --------------------
> | Thread-Topic: getting Membership userid to use and store in a custom
> databas
> | thread-index: AcXkbmloXup2uoowQ5Kem787opk45A==
> | X-WBNR-Posting-Host: 65.35.95.187
> | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@xxxxxxxxxxxxxx>
> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@xxxxxxxxxxxxx>
> <40eCR904FHA.3936@xxxxxxxxxxxxxxxxxxxxx>
> <046814B3-856E-4548-9E84-E23C676D0E0C@xxxxxxxxxxxxx>
> <F0207F1B-014F-4D1C-82DE-40006E155E1E@xxxxxxxxxxxxx>
> <Q#Y$CMA5FHA.1144@xxxxxxxxxxxxxxxxxxxxx>
> <9CCA3901-4DBB-46C6-912E-0E57289558AB@xxxxxxxxxxxxx>
> <3UzYg7C5FHA.2880@xxxxxxxxxxxxxxxxxxxxx>
> | Subject: RE: getting Membership userid to use and store in a custom
> databas
> | Date: Tue, 8 Nov 2005 06:12:11 -0800
> | Lines: 301
> | Message-ID: <3B555CBB-EBB9-4509-B4E1-C127C80F1733@xxxxxxxxxxxxx>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.dotnet.framework.aspnet.webcontrols:11763
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> |
> | Ok cool, was looking at it and only one question I can think of is say
> | besides the shipping cart items, can i store more then one many item
> list,
> | say one list is shopping cart items and antother for say a list of items
> they
> | are interested in. or even another for list of websites they like. OR
> | mutliple shipping address, or well etc etc for that user.
> |
> | I am going to assume this is yes, because you all are very talented.
> |
> |
> | "Steven Cheng[MSFT]" wrote:
> |
> | > Hi Tdar,
> | >
> | > As for the ID , it is used internally by the ServiceProvider which may
> not
> | > expose public interfaces for us to query data through that UserKey. So
> | > what's the information you want to get through this userkey?
> | > In your former message, you mentioned that
> | > ===================
> | >
> | > I would like to use the key in a many to one database the (one being
> your
> | > memebership database, many being favorate items for that user) for
> there
> | > custom home page. In order to accomplish this I would need the userid
> | > (unique key) that i can populate as a relationship between the two SQL
> | > tables. And I would need to query for that information in that table
> after
> | > words.
> | >
> | > =================
> | >
> | > If I understand well, what you'd like to do is something like the
> Profile
> | > service in ASP.NET 2.0. The Profile service can help store personal
> datas
> | > (specific to a certain user) so that we can provide some customizable
> datas
> | > for users( can work together with MembershipService...) Have you tried
> the
> | > Profile service to see if it meet your requirement?
> | >
> | > Here are some related reference on ASP.NET 2.0's profile service:
> | >
> | > #ASP.NET Profile Properties Overview
> | > http://msdn2.microsoft.com/en-us/library/2y3fs9xs.aspx
> | >
> | > #Storing User Profiles
> | > http://www.asp.net/QUICKSTART/aspnet/doc/profile/default.aspx#schema
> | >
> | > #Storing User Information with ASP.NET 2.0 Profiles
> | >
> http://msdn.microsoft.com/library/en-us/dnvs05/html/userprofiles.asp?frame=t
> | > rue
> | >
> | > Hope helps. Thanks,
> | >
> | > Steven Cheng
> | > Microsoft Online Support
> | >
> | > Get Secure! www.microsoft.com/security
> | > (This posting is provided "AS IS", with no warranties, and confers no
> | > rights.)
> | >
> | >
> | >
> | >
> | >
> | >
> | > --------------------
> | > | Thread-Topic: getting Membership userid to use and store in a custom
> | > databas
> | > | thread-index: AcXkG7DvAqUyrXRVTSWGiRQq1SEVWw==
> | > | X-WBNR-Posting-Host: 65.35.95.187
> | > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@xxxxxxxxxxxxxx>
> | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@xxxxxxxxxxxxx>
> | > <40eCR904FHA.3936@xxxxxxxxxxxxxxxxxxxxx>
> | > <046814B3-856E-4548-9E84-E23C676D0E0C@xxxxxxxxxxxxx>
> | > <F0207F1B-014F-4D1C-82DE-40006E155E1E@xxxxxxxxxxxxx>
> | > <Q#Y$CMA5FHA.1144@xxxxxxxxxxxxxxxxxxxxx>
> | > | Subject: RE: getting Membership userid to use and store in a custom
> | > databas
> | > | Date: Mon, 7 Nov 2005 20:20:03 -0800
> | > | Lines: 184
> | > | Message-ID: <9CCA3901-4DBB-46C6-912E-0E57289558AB@xxxxxxxxxxxxx>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> | > microsoft.public.dotnet.framework.aspnet.webcontrols:11753
> | > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> | > |
> | > | I am wondering how i could use that in when configuring the data
> | > connection.
> | > | should i just throw the userid in a hidden text box and they use the
> | > control
> | > | function in the configure dataconnection to do a where query on that
> user
> | > id,
> | > | or is there a better easier way to do that ??
> | > |
> | > |
> | > |
> | > | "Steven Cheng[MSFT]" wrote:
> | > |
> | > | > Hi Tdar,
> | > | >
> | > | > Glad that you've fot it working. Also, it's my pleasure to be of
> | > | > assistance. If there're any further things we can help, please feel
> | > free to
> | > | > post here.
> | > | >
> | > | > Thanks,
> | > | >
> | > | > Steven Cheng
> | > | > Microsoft Online Support
> | > | >
> | > | > Get Secure! www.microsoft.com/security
> | > | > (This posting is provided "AS IS", with no warranties, and confers
> no
> | > | > rights.)
> | > | >
> | > | >
> | > | > --------------------
> | > | > | Thread-Topic: getting Membership userid to use and store in a
> custom
> | > | > databas
> | > | > | thread-index: AcXjrk2hkYaS5LRoRZWhNEOKedvxLw==
> | > | > | X-WBNR-Posting-Host: 24.73.223.27
> | > | > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@xxxxxxxxxxxxxx>
> | > | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@xxxxxxxxxxxxx>
> | > | > <40eCR904FHA.3936@xxxxxxxxxxxxxxxxxxxxx>
> | > | > <046814B3-856E-4548-9E84-E23C676D0E0C@xxxxxxxxxxxxx>
> | > | > | Subject: RE: getting Membership userid to use and store in a
> custom
> | > | > databas
> | > | > | Date: Mon, 7 Nov 2005 07:17:01 -0800
> | > | > | Lines: 109
> | > | > | Message-ID: <F0207F1B-014F-4D1C-82DE-40006E155E1E@xxxxxxxxxxxxx>
> | > | > | MIME-Version: 1.0
> | > | > | Content-Type: text/plain;
> | > | > | charset="Utf-8"
> | > | > | Content-Transfer-Encoding: 7bit
> | > | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | > | Content-Class: urn:content-classes:message
> | > | > | Importance: normal
> | > | > | Priority: normal
> | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | > | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols
> | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | > | Xref: TK2MSFTNGXA01.phx.gbl
> | > | > microsoft.public.dotnet.framework.aspnet.webcontrols:11743
> | > | > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> | > | > |
> | > | > | Sorry,
> | > | > | I accually know how to convert it to VB now
> | > | > |
> | > | > | Dim UserInfo as MembershipUser
> | > | > |
> | > | > | Finally understand all this :)
> | > | > |
> | > | > | Tdar
> | > | > |
> | > | > | "TdarTdar" wrote:
> | > | > |
> | > | > | > I would like to use the key in a many to one database the (one
> | > being
> | > | > your
> | > | > | > memebership database, many being favorate items for that user)
> for
> | > | > there
> | > | > | > custom home page. In order to accomplish this I would need the
> | > userid
> | > | > | > (unique key) that i can populate as a relationship between the
> two
> | > SQL
> | > | > | > tables. And I would need to query for that information in that
> | > table
> | > | > after
> | > | > | > words.
> | > | > | >
> | > | > | > Tdar
> | > | > | >
> | > | > | > "Steven Cheng[MSFT]" wrote:
> | > | > | >
> | > | > | > > Hi Tdar,
> | > | > | > >
> | > | > | > > Welcome to ASPNET newsgroup.
> | > | > | > > Regarding on the getting Membership userid question, do you
> mean
> | > how
> | > | > to
> | > | > | > > access the underlying MembershipUser's identity value(primary
> | > key)?
> | > | > Based
> | > | > | > > on my understanding, we can get the MembershipUser's
> underlying
> | > | > database
> | > | > | > > identity through the following code:
> | > | > | > >
> | > | > | > > ================
> | > | > | > > protected void Page_Load(object sender, EventArgs e)
> | > | > | > > {
> | > | > | > > MembershipUser user = Membership.GetUser();
> | > | > | > >
> | > | > | > > Response.Write("<br>Username: " + user.UserName);
> | > | > | > > Response.Write("<br>:LastLoginDate " +
> | > user.LastLoginDate);
> | > | > | > > Response.Write("<br>ProviderUserKey: " +
> | > | > | > > user.ProviderUserKey.ToString());
> | > | > | > > }
> | > | > | > > ================
> | > | > | > >
> | > | > | > > the above code help display the current login user's
> | > ProviderUserKey.
> | > | >
> | > | > | > > However, the "ProviderUserKey contains the underlying user
> key
> | > | > identity
> | > | > | > > which is provider specific(generally it should be transparent
> to
> | > | > | > > developers...). So we do not recommend that we directly use
> it in
> | > our
> | > | > | > > asp.net web application. Also, for FormsAuthentication, the
> | > | > authentication
> | > | > | > > ticket is cookie based, and I think the authentication
> ticket
> | > only
> | > | > | > > contains username as the identity rather than the underlying
> | > UserKey.
> | > | > | > > Is there any particular scenario in your application that you
> | > need to
> | > | > use
> | > | > | > > the underlying Provider specific UserKey value? Please feel
.