3

Now this might just be straightforward, but I can't seem to figure it out..

I have set up the Custom Membership provider, and gave it the proper connection stuff. What I know is that it connects to the correct database, but I know for sure that it doesn't look at the correct table.

How would I set it up to use a specific table? As the table already has users in them.

The table name is: members_info.

the column names are: member___id(key), member_name, member__pwd, member_perm

member___id => Being the Key and the account name to login with
member_name => Being the users Name or Nickname
member__pwd => 10 chars long (for now)
member_perm => holds 1 of the following values: 0) User 1)Admin 2)Banned

now I know that the later one is to be setup by the Role Provider, and I'm sure once I know how to do the membership one that one is similar in some way.

So my question is, how do I point the Custom Membership Provider to the table: members_info and to use member___id for username, members__pwd for password (and possibly get member_name out to say: Welcome {member_name}! when they login).

Thanks in advance for any help you can provide!

===

Added info. Members__uid is the key value as it increases on each new entry.

===

Since you can't tell it to use a specific table

How can I set it up so, that it works with the tool provided in visual studio? (Website > ASP.net Configuration).

As it now says 0 users, on the security tab. I want to be able to manage the users through here too.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Raskaroth
  • 639
  • 1
  • 9
  • 25
  • Just take a look at first method in answer, that I have linked to. You will see what you have to do. – Damb Apr 03 '11 at 13:41

1 Answers1

2

You don't tell "Use this table" to your membership provider. Instead you just implement methods, that will look for data in your table. You have to manually implement methods (from MembershipProvider interface) that will have access to db and will execute your logic (validation o users credentials for example) based on data from your table.

You an get more specific info in this question.

Community
  • 1
  • 1
Damb
  • 14,410
  • 6
  • 47
  • 49
  • I was hoping to use it with the tool provided with visual studio. (Website > ASP.net Configuration). As it now says 0 users, on the security tab. I want to be able to manage the users through here too. – Raskaroth Apr 03 '11 at 13:43
  • Hmm.. I haven't done this before so dunno. You can definitely create your custom user class through memership interface, but I do not know if it will automatically integrate with ASP.NET configuration tool. You will probably have to investigate msdn (and other) articles about extending default membership implementation since nobody is giving you direct answer here so far. – Damb Apr 03 '11 at 16:26