Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 03-01-2009
Member
 
Join Date: May 2008
Posts: 2,383
How to store Additional information in Database

Hi,
I want to store some additional information such as users IP Adress, Age, etc inside the database during registration. Can't guess which table to look out for to insert additional information. Will it be aspnet_Membership or aspnet_Users.

Thanks
Reply With Quote
  #2  
Old 03-01-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: How to store Additional information in Database

Hi,
Why dont you create your own table alongwith the custom coloumns then use the USERID to correlate it to the correct USER via the USER table, either as a foriegn key or the way the Standard Asp.Net 2.0 membership provider does it with the other tables.

Try learning from Standard Membership Schema (the aspnet db) in SQL Management Studio and study the schema as well as the providers and classes in the Standard ASP.NET 2.0 Membership flow doing this you will have a good grasp over how it all fits together. Then after you see how Microsoft fits it's tables together and relates them, there's no reason you can't follow the same pattern and add your own tables, but it's important that you know how the whole thing fits together as to not overwrite built in functionality or otherwise conflict with it.

Microsoft uses the built in USER table and it's unique ID to relate that user with all the other tables that come with the built in membership you can create your own tables and persist the membership data you want as well using the same approach and relations with the unique USERID.
Reply With Quote
  #3  
Old 03-01-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: How to store Additional information in Database

This is best handled by using the Profile Provider. Like the Membership Provider, there's some configuration work you need to do to get started, but it doesn't require much coding to make it work.

The standard profile data are stored in a blob field in the database, so I prefer to use the Table Profile Providers. These providers let you store each data element in its own column, which I think is a little easier.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to store Additional information in Database"
Thread Thread Starter Forum Replies Last Post
Additional Logon Information Required error on Windows XP Darpad Windows Vista Network 6 07-10-2011 08:56 PM
Is there any place to Store additional items in Deus Ex: Human Revolution Where-TO Video Games 3 26-08-2011 10:40 PM
c1041724 when mounting exchange store... Microsoft broke my database IpsA Small Business Server 1 10-08-2010 03:41 PM
Is it possible to store video files in a database?? Chandranath Software Development 3 27-11-2009 05:03 AM
How to store byte array to database with JDBC? RogerFielden Software Development 3 23-09-2009 10:52 AM


All times are GMT +5.5. The time now is 10:25 PM.