Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
Dears ,
 
I have millions of records in SQL Database which are upto 25 digits Numbers like Policy Numbers,Account Numbers etc...,I just want to generate 10 Digits Numbers for Every Records which is retrieving from the table.
 
Example :
 
Type < Data > < Unique ID>
 
Policy No<215-163202-1121521532> < Null>
A/C No < 612-9650-15264859632> < Null>
Ref No < 9635-5621452-2986597542 > < Null>
Contract No < 98652-365215-20123202323 > < Null>
 
I want to generate unique Numbers with prefix based on type of Data,Data might be 10 or 12 Digits Numbers
 
Please help me to generate in Vb.net
 
thanks in advance,
Posted 30-Jan-13 2:29am

1 solution

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 480
1 mhegazy94 460
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,205
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,644
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web04 | 2.8.140922.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2014
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