sql server and membership provider

[Amir Ghezelbash]

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 ***

[Peter Bromberg [C# MVP]]

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 ***