AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
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.

http://www.aspdotnetcodes.com/CodeGenerator.aspx.

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
Hello,

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
Windows 8: 50 Questions and Answers You Need to Make a Decision (Normally $9.95)
Integrating Silverlight 4 with SharePoint 2010 - Free 42 Page Sample Chapter
Backup and Recovery Best Practices for Microsoft SQL Server 2005