how to create unique id for each user in asp.net C#
I was used random number for each profile but its not unique.
4
-
1Why not leave that to an Identity field in the database?Adriaan Stander– Adriaan Stander2013-10-10 04:49:05 +00:00Commented Oct 10, 2013 at 4:49
-
u mean to say autonumber?farhat– farhat2013-10-10 04:53:12 +00:00Commented Oct 10, 2013 at 4:53
-
Yes, depending on the RDBMS you could say autonumber X-)Adriaan Stander– Adriaan Stander2013-10-10 04:53:51 +00:00Commented Oct 10, 2013 at 4:53
-
okk but i want to create id like suposse personname is shaikh and city is pune,state is maharashtra, country is india then combination of all this field like INMHPU123333......?farhat– farhat2013-10-10 04:58:18 +00:00Commented Oct 10, 2013 at 4:58
Add a comment
|
2 Answers
Guid.NewGuid() is almost unique.
Usage:
Guid id = Guid.NewGuid();
// Output: e62e2706-a8db-4fae-891a-65985fd80351
5 Comments
farhat
How to use this method..could u please tel me
Win
I updated the answer. If you want string value, you can use
id.ToString();. C# Guid is equivalent to SQL uniqueidentifier.farhat
okk but i want to create id like suposse personname is shaikh and city is pune,state is maharashtra, country is india then combination of all this field like INMHPU123333.
geedubb
Sounds more like you want a hashing function. Check out stackoverflow.com/questions/11454004/…
If you’re using SQL Server (I’m pretty sure something similar exists in Oracle and MySQL but I can’t confirm) you can use identity column with integer value that will automatically generate unique ID for new user.
If you need something different like you shown in one of the comments “INMHPU123333” then you’ll need to create a separate function for this.
Note that this is not really ideal from the performance perspective because it will cause big index fragmentation. Not a huge deal though if you don’t have large number of records.
