Click here to Skip to main content
12,507,058 members (64,120 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160927.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2016
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