471,618 Members | 1,062 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,618 software developers and data experts.

sql server and membership provider

Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
i am using .net 2.0 membership provider interface to provide a
membership in my website...now i also am using the sql server 2005 for
the backbone of the site..now when a new user is created their
information is saved into asp_ membership and their userid is
automactially saved into another table called asp_users...now these are
defaults by membership provider...what i would like to do is to create
another table which i have called "Rank" and i would a column in this
"rank" table that would keep the user ids, now i have noticed that the
asp_user.UserId has a releationship with asp_Membership.userId so when a
new user is created asp_user.Userid automactially gets updated..i have
created a colum called Rank.UserId which has a relationship with
asp_users.userid and asp_membershi.Userid but it doesnot get updated
automatically when a new user is created...what can i do so i can have
this table "Rank" also gets updated automactially as soon a a new user
is created or a user has been deleted...just like asp_users gets updated
...thanks in advance

---
Best Regards
Amir

---
Best Regards
Amir

*** Sent via Developersdex http://www.developersdex.com ***
Feb 19 '06 #1
1 2955
Amir,
In order to handle this you need to write a custom SqlMembership / Role
provider class derived from the respective base classes and implement your
"extra table" stuff in the apporpriate overridden methods.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Amir Ghezelbash" wrote:
Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
Hello all,
I need help with sql server which i was wondering if someone can shed
some light on my problem

The problem:
i am using .net 2.0 membership provider interface to provide a
membership in my website...now i also am using the sql server 2005 for
the backbone of the site..now when a new user is created their
information is saved into asp_ membership and their userid is
automactially saved into another table called asp_users...now these are
defaults by membership provider...what i would like to do is to create
another table which i have called "Rank" and i would a column in this
"rank" table that would keep the user ids, now i have noticed that the
asp_user.UserId has a releationship with asp_Membership.userId so when a
new user is created asp_user.Userid automactially gets updated..i have
created a colum called Rank.UserId which has a relationship with
asp_users.userid and asp_membershi.Userid but it doesnot get updated
automatically when a new user is created...what can i do so i can have
this table "Rank" also gets updated automactially as soon a a new user
is created or a user has been deleted...just like asp_users gets updated
...thanks in advance

---
Best Regards
Amir

---
Best Regards
Amir

*** Sent via Developersdex http://www.developersdex.com ***

Feb 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Amir Ghezelbash | last post: by
2 posts views Thread by Richard Hallgren | last post: by
3 posts views Thread by LamSoft | last post: by
1 post views Thread by =?Utf-8?B?WmhlbmcgQ2hlbg==?= | last post: by
2 posts views Thread by Bobby Edward | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
1 post views Thread by ZEDKYRIE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.