| Groups | Blog | Home |
asp.net webcontrols : getting Membership userid to use and store in a custom database
Hello,
What is the code to retrive the userid of the currently loged in user from the asp)user membership databse using the new login controls of asp.net 2. How do i use that in the "configure database source. What is the source would it be profile or from the cookie, and if it is profile what would be in teh propery name? Tdar
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 free to post here if you have anything unclear. 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 database | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== | X-WBNR-Posting-Host: 24.73.223.27 | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> | Subject: getting Membership userid to use and store in a custom database | Date: Sat, 5 Nov 2005 11:01:03 -0800 | Lines: 13 | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | 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:11708 | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | | Hello, | What is the code to retrive the userid of the currently loged in user | from the asp)user membership databse using the new login controls of | asp.net 2. | | How do i use that in the "configure database source. What is the source | would it be profile or from the cookie, and if it is profile what would be in | teh propery name? | | | Tdar | | |
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@noemail.nospam> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> | 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@microsoft.com> | 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 | [quoted text, click to view] | "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 | > [quoted text, click to view] | > "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 free to post | > > here if you have anything unclear. | > > | > > 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 | > > database | > > | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== | > > | X-WBNR-Posting-Host: 24.73.223.27 | > > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> | > > | Subject: getting Membership userid to use and store in a custom database | > > | Date: Sat, 5 Nov 2005 11:01:03 -0800 | > > | Lines: 13 | > > | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | > > | 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:11708 | > > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | > > | | > > | Hello, | > > | What is the code to retrive the userid of the currently loged in user | > > | from the asp)user membership databse using the new login controls of | > > | asp.net 2. | > > | | > > | How do i use that in the "configure database source. What is the source | > > | would it be profile or from the cookie, and if it is profile what would | > > be in | > > | teh propery name? | > > | | > > | | > > | Tdar | > > | | > > | | > > | | > > | > > |
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 [quoted text, click to view] "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 free to post > here if you have anything unclear. > > 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 > database > | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== > | X-WBNR-Posting-Host: 24.73.223.27 > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> > | Subject: getting Membership userid to use and store in a custom database > | Date: Sat, 5 Nov 2005 11:01:03 -0800 > | Lines: 13 > | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > | 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:11708 > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > | > | Hello, > | What is the code to retrive the userid of the currently loged in user > | from the asp)user membership databse using the new login controls of > | asp.net 2. > | > | How do i use that in the "configure database source. What is the source > | would it be profile or from the cookie, and if it is profile what would > be in > | teh propery name? > | > | > | Tdar > | > | > | >
What is this in VB?
MembershipUser user = Membership.GetUser(); Thanks, Tdar [quoted text, click to view] "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 free to post > here if you have anything unclear. > > 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 > database > | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== > | X-WBNR-Posting-Host: 24.73.223.27 > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> > | Subject: getting Membership userid to use and store in a custom database > | Date: Sat, 5 Nov 2005 11:01:03 -0800 > | Lines: 13 > | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > | 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:11708 > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > | > | Hello, > | What is the code to retrive the userid of the currently loged in user > | from the asp)user membership databse using the new login controls of > | asp.net 2. > | > | How do i use that in the "configure database source. What is the source > | would it be profile or from the cookie, and if it is profile what would > be in > | teh propery name? > | > | > | Tdar > | > | > | >
Sorry,
I accually know how to convert it to VB now Dim UserInfo as MembershipUser Finally understand all this :) Tdar [quoted text, click to view] "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 free to post > > here if you have anything unclear. > > > > 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 > > database > > | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== > > | X-WBNR-Posting-Host: 24.73.223.27 > > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> > > | Subject: getting Membership userid to use and store in a custom database > > | Date: Sat, 5 Nov 2005 11:01:03 -0800 > > | Lines: 13 > > | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > > | 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:11708 > > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > > | > > | Hello, > > | What is the code to retrive the userid of the currently loged in user > > | from the asp)user membership databse using the new login controls of > > | asp.net 2. > > | > > | How do i use that in the "configure database source. What is the source > > | would it be profile or from the cookie, and if it is profile what would > > be in > > | teh propery name? > > | > > | > > | Tdar > > | > > | > > | > >
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 ?? [quoted text, click to view] "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@noemail.nospam> > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > | 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@microsoft.com> > | 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 free to > post > | > > here if you have anything unclear. > | > > > | > > 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 > | > > database > | > > | thread-index: AcXiO0UBc5CrmfpOQsuTIEeMy9+g4Q== > | > > | X-WBNR-Posting-Host: 24.73.223.27 > | > > | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> > | > > | Subject: getting Membership userid to use and store in a custom > database > | > > | Date: Sat, 5 Nov 2005 11:01:03 -0800 > | > > | Lines: 13 > | > > | Message-ID: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > | > > | 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:11708 > | > > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > | > > | > | > > | Hello, > | > > | What is the code to retrive the userid of the currently loged in > user > | > > | from the asp)user membership databse using the new login > controls of > | > > | asp.net 2. > | > > | > | > > | How do i use that in the "configure database source. What is the > source > | > > | would it be profile or from the cookie, and if it is profile what > would > | > > be in > | > > | teh propery name? > | > > | > | > > | > | > > | Tdar > | > > | > | > > | > | > > | > | > > > | > > > | >
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@noemail.nospam> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> | 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@microsoft.com> | 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. | | [quoted text, click to view] | "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@noemail.nospam> | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> | > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> | > <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> | > <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> | > | 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@microsoft.com> | > | 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 ?? | > | | > | | > | [quoted text, click to view] | > | "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
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. [quoted text, click to view] "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@noemail.nospam> > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> > <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> > | 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@microsoft.com> > | 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@noemail.nospam> > | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > | > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > | > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > | > | 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@microsoft.com> > | > | 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)?
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@noemail.nospam> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> | 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@microsoft.com> | 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 ?? | | | [quoted text, click to view] | "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@noemail.nospam> | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> | > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> | > | 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@microsoft.com> | > | 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 | > | [quoted text, click to view] | > | "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 | > | > [quoted text, click to view] | > | > "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
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 [quoted text, click to view] "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@noemail.nospam> > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> > <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> > <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> > <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> > | 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@microsoft.com> > | 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 > | >
Hi Tdar,
Thanks for your further followup. After viewing the code you provided and performing some tests on ourside, here are some of my suggestions on this: 1. As for the ASP.NET Profiles, it is user specific, so please make sure when you update the Profile , the current user has actually login the web site. In other word, the current user is not under anonymous status. (We can enable anonymousIdentify so as to enable anonymous user for profile services....) 2. If #1 is ok. Then, we should make sure that each time after we set new values on user's profile, we have actually update the Profile values into the underlying persistent store (database....). Though we can set the Profile service to update Automatically as below: <system.web> <profile enabled="true" automaticSaveEnabled="true" > this only works when our page is normally ends, there is no other code which end the page request in the middle. And in your code you use Response.Redirect, it may cause the Profile values haven't been updated to db, so to make sure this, I suggest you call the "Profile.Save()" before you call Response.Redirect, like below: ========= 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 Profile.Save() Response.Redirect(Request.Url.LocalPath) End Sub ========= This works well on my side. BTW, as for System.Drawing.Color, you need to reference the System.Drawing.dll in your web application first, then we can access the System.Drawing Namespace.... Also, we can define the Color propety in profile like: <group name="Favorite" > <add name="Color" type="System.Drawing.Color" serializeAs="Binary"/> ................. In addition, to use CustomClass in Profile, we can just define a custom class(better to make it as [Serializable]) and deinfe it in profile like; <add name="MyUnit" readOnly="false" type="CustomProfileClasses.MyUnit" serializeAs="Binary"/> =======code for custom class===== [Serializable] public class MyUnit { public string Name = string.Empty; public int Count =0; public bool Enabled = false; } =============== Then, we can access the custom class properties in Profile, just as other buildin type properteis, e.g: Profile.MyUnit.Name = "name" Profile.MyUnit.Count = 3 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: AcXp/zUzrhXhQnO4RrGHcNcjFu+dSg== | X-WBNR-Posting-Host: 24.73.223.27 | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> | Subject: RE: getting Membership userid to use and store in a custom databas | Date: Tue, 15 Nov 2005 08:11:16 -0800 | Lines: 376 | Message-ID: <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> | 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: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.aspnet.webcontrols:31150 | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | | 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:PreferredBackgro undColor: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
Hi Tdar,
Does the information in my last reply helps you on the new problem? If there're anything else we can help, please feel free to post here. Regards, Steven Cheng Microsoft Online Support Get Secure! www.microsoft.com/security (This posting is provided "AS IS", with no warranties, and confers no rights.) -------------------- | X-Tomcat-ID: 295933607 | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain | Content-Transfer-Encoding: 7bit | From: stcheng@online.microsoft.com (Steven Cheng[MSFT]) | Organization: Microsoft | Date: Thu, 17 Nov 2005 13:30:27 GMT | Subject: RE: getting Membership userid to use and store in a custom databas | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | Message-ID: <yj4DYs36FHA.1236@TK2MSFTNGXA02.phx.gbl> | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols | Lines: 491 | Path: TK2MSFTNGXA02.phx.gbl | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.aspnet.webcontrols:31192 | NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182 | | Hi Tdar, | | Thanks for your further followup. | After viewing the code you provided and performing some tests on ourside, | here are some of my suggestions on this: | | 1. As for the ASP.NET Profiles, it is user specific, so please make sure | when you update the Profile , the current user has actually login the web | site. In other word, the current user is not under anonymous status. (We | can enable anonymousIdentify so as to enable anonymous user for profile | services....) | | 2. If #1 is ok. Then, we should make sure that each time after we set new | values on user's profile, we have actually update the Profile values into | the underlying persistent store (database....). Though we can set the | Profile service to update Automatically as below: | | <system.web> | <profile enabled="true" automaticSaveEnabled="true" > | | this only works when our page is normally ends, there is no other code | which end the page request in the middle. And in your code you use | Response.Redirect, it may cause the Profile values haven't been updated to | db, so to make sure this, I suggest you call the "Profile.Save()" before | you call Response.Redirect, like below: | | ========= | 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 | | Profile.Save() | | | Response.Redirect(Request.Url.LocalPath) | End Sub | ========= | | This works well on my side. BTW, as for System.Drawing.Color, you need to | reference the System.Drawing.dll in your web application first, then we can | access the System.Drawing Namespace.... Also, we can define the Color | propety in profile like: | | <group name="Favorite" > | <add name="Color" type="System.Drawing.Color" | serializeAs="Binary"/> | ................ | | | In addition, to use CustomClass in Profile, we can just define a custom | class(better to make it as [Serializable]) and deinfe it in profile like; | | <add name="MyUnit" readOnly="false" type="CustomProfileClasses.MyUnit" | serializeAs="Binary"/> | | =======code for custom class===== | [Serializable] | public class MyUnit | { | public string Name = string.Empty; | public int Count =0; | public bool Enabled = false; | } | =============== | | | Then, we can access the custom class properties in Profile, just as other | buildin type properteis, e.g: | | Profile.MyUnit.Name = "name" | Profile.MyUnit.Count = 3 | | | 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: AcXp/zUzrhXhQnO4RrGHcNcjFu+dSg== | | X-WBNR-Posting-Host: 24.73.223.27 | | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> | | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> | <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> | <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> | <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> | <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> | <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> | <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> | <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> | | Subject: RE: getting Membership userid to use and store in a custom | databas | | Date: Tue, 15 Nov 2005 08:11:16 -0800 | | Lines: 376 | | Message-ID: <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> | | 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: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl | | Xref: TK2MSFTNGXA02.phx.gbl | microsoft.public.dotnet.framework.aspnet.webcontrols:31150 | | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | | | | 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:PreferredBackgro | undColor: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>
Thanks for your followup.
Glad that you've already got it working. And when there is anything else we can help, please feel free to post here. Regards, 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: AcXuxLMV7pYe2B0uQjyZ5NKaPo6rGw== | X-WBNR-Posting-Host: 24.73.223.27 | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> <yj4DYs36FHA.1236@TK2MSFTNGXA02.phx.gbl> <rUwNFdp7FHA.4000@TK2MSFTNGXA02.phx.gbl> | Subject: RE: getting Membership userid to use and store in a custom databas | Date: Mon, 21 Nov 2005 09:55:03 -0800 | Lines: 312 | Message-ID: <9F4D6B72-4E6F-435B-BCCC-17C9661ADC6A@microsoft.com> | 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: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.aspnet.webcontrols:31244 | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | | Hello, | Well I went over everything again and went thru the autosave profile | example, the only thing I can think that may have been affecting this from | working right before was i was using a code behind, i decided not to use code | behind for this page and everything is working as designed. Sorry for the | delay i have to get away from the pc for a while.. Thanks for your time.. | | Tdar | | [quoted text, click to view] | "Steven Cheng[MSFT]" wrote: | | > Hi Tdar, | > | > Does the information in my last reply helps you on the new problem? If | > there're anything else we can help, please feel free to post here. | > | > Regards, | > | > Steven Cheng | > Microsoft Online Support | > | > Get Secure! www.microsoft.com/security | > (This posting is provided "AS IS", with no warranties, and confers no | > rights.) | > -------------------- | > | X-Tomcat-ID: 295933607 | > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> | > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> | > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> | > <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> | > <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> | > <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> | > <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> | > <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> | > <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> | > <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> | > | MIME-Version: 1.0 | > | Content-Type: text/plain | > | Content-Transfer-Encoding: 7bit | > | From: stcheng@online.microsoft.com (Steven Cheng[MSFT]) | > | Organization: Microsoft | > | Date: Thu, 17 Nov 2005 13:30:27 GMT | > | Subject: RE: getting Membership userid to use and store in a custom | > databas | > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols | > | Message-ID: <yj4DYs36FHA.1236@TK2MSFTNGXA02.phx.gbl> | > | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols | > | Lines: 491 | > | Path: TK2MSFTNGXA02.phx.gbl | > | Xref: TK2MSFTNGXA02.phx.gbl | > microsoft.public.dotnet.framework.aspnet.webcontrols:31192 | > | NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182 | > | | > | Hi Tdar, | > | | > | Thanks for your further followup. | > | After viewing the code you provided and performing some tests on ourside, | > | here are some of my suggestions on this: | > | | > | 1. As for the ASP.NET Profiles, it is user specific, so please make sure | > | when you update the Profile , the current user has actually login the web | > | site. In other word, the current user is not under anonymous status. (We | > | can enable anonymousIdentify so as to enable anonymous user for profile | > | services....) | > | | > | 2. If #1 is ok. Then, we should make sure that each time after we set new | > | values on user's profile, we have actually update the Profile values into | > | the underlying persistent store (database....). Though we can set the | > | Profile service to update Automatically as below: | > | | > | <system.web> | > | <profile enabled="true" automaticSaveEnabled="true" > | > | | > | this only works when our page is normally ends, there is no other code | > | which end the page request in the middle. And in your code you use | > | Response.Redirect, it may cause the Profile values haven't been updated | > to | > | db, so to make sure this, I suggest you call the "Profile.Save()" before | > | you call Response.Redirect, like below: | > | | > | ========= | > | 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 | > | | > | Profile.Save() | > | | > | | > | Response.Redirect(Request.Url.LocalPath) | > | End Sub | > | ========= | > | | > | This works well on my side. BTW, as for System.Drawing.Color, you need to | > | reference the System.Drawing.dll in your web application first, then we | > can | > | access the System.Drawing Namespace.... Also, we can define the Color | > | propety in profile like: | > | | > | <group name="Favorite" > | > | <add name="Color" type="System.Drawing.Color" | > | serializeAs="Binary"/> | > | ................ | > | | > | | > | In addition, to use CustomClass in Profile, we can just define a custom | > | class(better to make it as [Serializable]) and deinfe it in profile like; | > | | > | <add name="MyUnit" readOnly="false" type="CustomProfileClasses.MyUnit" | > | serializeAs="Binary"/> | > | | > | =======code for custom class===== | > | [Serializable] | > | public class MyUnit | > | {
Hello,
Well I went over everything again and went thru the autosave profile example, the only thing I can think that may have been affecting this from working right before was i was using a code behind, i decided not to use code behind for this page and everything is working as designed. Sorry for the delay i have to get away from the pc for a while.. Thanks for your time.. Tdar [quoted text, click to view] "Steven Cheng[MSFT]" wrote:
> Hi Tdar, > > Does the information in my last reply helps you on the new problem? If > there're anything else we can help, please feel free to post here. > > Regards, > > Steven Cheng > Microsoft Online Support > > Get Secure! www.microsoft.com/security > (This posting is provided "AS IS", with no warranties, and confers no > rights.) > -------------------- > | X-Tomcat-ID: 295933607 > | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> > <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> > <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> > <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> > <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> > <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> > <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> > | MIME-Version: 1.0 > | Content-Type: text/plain > | Content-Transfer-Encoding: 7bit > | From: stcheng@online.microsoft.com (Steven Cheng[MSFT]) > | Organization: Microsoft > | Date: Thu, 17 Nov 2005 13:30:27 GMT > | Subject: RE: getting Membership userid to use and store in a custom > databas > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > | Message-ID: <yj4DYs36FHA.1236@TK2MSFTNGXA02.phx.gbl> > | Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols > | Lines: 491 > | Path: TK2MSFTNGXA02.phx.gbl > | Xref: TK2MSFTNGXA02.phx.gbl > microsoft.public.dotnet.framework.aspnet.webcontrols:31192 > | NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182 > | > | Hi Tdar, > | > | Thanks for your further followup. > | After viewing the code you provided and performing some tests on ourside, > | here are some of my suggestions on this: > | > | 1. As for the ASP.NET Profiles, it is user specific, so please make sure > | when you update the Profile , the current user has actually login the web > | site. In other word, the current user is not under anonymous status. (We > | can enable anonymousIdentify so as to enable anonymous user for profile > | services....) > | > | 2. If #1 is ok. Then, we should make sure that each time after we set new > | values on user's profile, we have actually update the Profile values into > | the underlying persistent store (database....). Though we can set the > | Profile service to update Automatically as below: > | > | <system.web> > | <profile enabled="true" automaticSaveEnabled="true" > > | > | this only works when our page is normally ends, there is no other code > | which end the page request in the middle. And in your code you use > | Response.Redirect, it may cause the Profile values haven't been updated > to > | db, so to make sure this, I suggest you call the "Profile.Save()" before > | you call Response.Redirect, like below: > | > | ========= > | 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 > | > | Profile.Save() > | > | > | Response.Redirect(Request.Url.LocalPath) > | End Sub > | ========= > | > | This works well on my side. BTW, as for System.Drawing.Color, you need to > | reference the System.Drawing.dll in your web application first, then we > can > | access the System.Drawing Namespace.... Also, we can define the Color > | propety in profile like: > | > | <group name="Favorite" > > | <add name="Color" type="System.Drawing.Color" > | serializeAs="Binary"/> > | ................ > | > | > | In addition, to use CustomClass in Profile, we can just define a custom > | class(better to make it as [Serializable]) and deinfe it in profile like; > | > | <add name="MyUnit" readOnly="false" type="CustomProfileClasses.MyUnit" > | serializeAs="Binary"/> > | > | =======code for custom class===== > | [Serializable] > | public class MyUnit > | { > | public string Name = string.Empty; > | public int Count =0; > | public bool Enabled = false; > | } > | =============== > | > | > | Then, we can access the custom class properties in Profile, just as other > | buildin type properteis, e.g: > | > | Profile.MyUnit.Name = "name" > | Profile.MyUnit.Count = 3 > | > | > | 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: AcXp/zUzrhXhQnO4RrGHcNcjFu+dSg== > | | X-WBNR-Posting-Host: 24.73.223.27 > | | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam> > | | References: <E58FF96B-6338-46C8-8F9F-388A6BAF2262@microsoft.com> > | <40eCR904FHA.3936@TK2MSFTNGXA01.phx.gbl> > | <046814B3-856E-4548-9E84-E23C676D0E0C@microsoft.com> > | <F0207F1B-014F-4D1C-82DE-40006E155E1E@microsoft.com> > | <Q#Y$CMA5FHA.1144@TK2MSFTNGXA01.phx.gbl> > | <9CCA3901-4DBB-46C6-912E-0E57289558AB@microsoft.com> > | <3UzYg7C5FHA.2880@TK2MSFTNGXA01.phx.gbl> > | <3B555CBB-EBB9-4509-B4E1-C127C80F1733@microsoft.com> > | <2Fd#GAN5FHA.3908@TK2MSFTNGXA02.phx.gbl> > | | Subject: RE: getting Membership userid to use and store in a custom > | databas > | | Date: Tue, 15 Nov 2005 08:11:16 -0800 > | | Lines: 376 > | | Message-ID: <6147488E-F1B1-4FB4-B870-FFFAC6F04774@microsoft.com> > | | 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: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl > | | Xref: TK2MSFTNGXA02.phx.gbl > | microsoft.public.dotnet.framework.aspnet.webcontrols:31150 > | | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols > | | > | | Hello,
Hi
I was seeing the post and got my attention coz I would like to know how to do that. My Database has many tables related to mey PersonalData (I can shift it to the providers table) and they have forein keys that point to the PersonalData table. What I want to know is how to get an ID (UserID or whatever) that can connect all the tables together. Thanks in advance
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |