Asp.Net News
Free Tech Magazines
Asp.Net Web Hosting
Suggest Us
Link to Us
Feeds Subscription
Questions & Answers
Tips & Tricks
 to generate unique id
Posted by Ram Pravesh Goswami on  3/26/2009 2:59:09 AM Category: ADO.NET
Add to my favorites
Email to friend
i want to generate unique id in database sql server 2005 such as 'as122','as123'....n but this unique id should not be shown in the front tool,if fetch then i should be on the application.

Post Your Reply Post New Question

 Viewer's Reply
Use our Component to generate your unique code
Answered By Moderator1 on 3/26/2009 8:55:19 PM
Go to this url and download the dll.

You can find code sample and try that way to generate your unique code.
Generation of unique ID
Answered By sujany on 4/18/2009 1:20:38 PM

we can get unique id for Int.(I hope its not possible for char)

Simply open ur database ---> in the object explorer window on right hand side,choose your table ---->Right click on the table--->Click on design--->Select your column on the top---> in the column properties window----> go to identity Specification--->expand it---->and change IS IDENTITY to yes---<then you can see identity increment and identity seed--->chnage the values as you need.

I hope this might be useful..
Post Your Reply If you still have problem, post it again under this reply for better response.

Sponsored by
Web Application Security — How to Minimize Prevalent Risk of Attacks
Building a Web Application Security Program