Auto increment of Number with String using C# Winforms

Jeff ,

 

One option would be to create a autonumber field as below:

http://www.techonthenet.com/access/tables/autoinc2007.php

 

Concatenate the autoincrement number and the string using & operator . This could server as a no code solution. 

 

If we go via code ,

.Query the database and get the record by the largest id or by the largest autoincrement field (This will obviously have the largest number in the format CHHTP003)
.Increment the number and Concatenate the string CHHTP to the number

 

Thanks,

Priyan 

 

wasn't it just using a simple increment operation? e.g.:

 

int serial = 0; 

Console.WriteLine ("CHHTP");

if (serial < 10)

Console.WriteLine ("00{0}", serial);

else if (serial < 100)

Console.WriteLine ("0{0}", serial);

else if (serial < 1000)

Console.WriteLine ("{0}", serial);

else

Console.WriteLine ("out of range!");

 

btw, how to use the code tag in this web? 

Hi Jeff,

 

The best and correct way to handle such scenerio is First get the last number inserted in database trim the value to the digits only and increment the digits by 1 and populate the digits with text appended to it in a textbox then save the textbox value directly in to the DB.

 

Thanks

 

If helpful Mark as Correct Answer.