Click here to Skip to main content
13,346,397 members (64,114 online)
Rate this:
Please Sign up or sign in to vote.
See more:

i am devloping a website in it I want to do when new user register he can add update delete contact information to only his profile.

like in gmail when new user create Sign up he can add update delete his friends email id information like that.

so what should do??


[edit]SHOUTING removed - OriginalGriff[/edit]
Posted 16-Feb-13 22:52pm
Updated 16-Feb-13 22:58pm
OriginalGriff 17-Feb-13 3:58am
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.
Member 9784436 17-Feb-13 7:41am
thanx sir for telling about "capitals is considered shouting on the internet"
OriginalGriff 17-Feb-13 7:44am
You're welcome - it is general Netiquette, not specific to this site. Ignore it at your peril! :laugh:
OriginalGriff 17-Feb-13 3:59am
What have you tried?
Where are you stuck?
Member 9784436 17-Feb-13 7:24am
that means sir when new user sine up, c# create automatically database for that particular user.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

"that means sir when new user sine up, c# create automatically database for that particular user."

That is a spectacularly bad idea! :laugh:
Creating a database or even a table for each user is a massive waste of space, memory, and time.

If you want a list of "contacts" which is specific to each user then create a table which holds cross references:
User Table:
ID      Name     Email
1       Joe
2       Mike
1000    Fred

Contacts table:
ID      UserID   ContactID
1       1        2
2       1        1000
3       1        777
4       2        1000
5       2        666
In this example, User 1 (Joe) knows user 2 (Mike), another user with the id 777 and user 1000 (Fred).
User 2 (Mike) knows Fred, and another user with the ID 666)
To find out which contacts a user has, you select the records from the Contacts table, asking only for those records with his User ID:
SELECT ContactID FROM Contacts WHERE UserID=1
Member 9784436 17-Feb-13 9:13am
thanx a lot sir i got whole concept.
OriginalGriff 17-Feb-13 9:34am
You're welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 17 Feb 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100