Auto increment request number

Dheeraj Sharma

8y3.8kLearn iOS Programming

i have issue with autoincrement in request number,

like, PR0001

PR0002

PR0003

same like alpha numeric auto increment

PR will be same but the integer value will be increasing in MVC view

do anyone have any code or hint for it...

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
create an ID INT IDENTITY column and use that as your primary key (it's unique, narrow, static - perfect)

if you really need an ID with a letter or something, create a computed column based on that ID INT IDENTITY
CREATE TABLE dbo.Demo(ID INT IDENTITY PRIMARY KEY,
IDwithChar AS 'C' + RIGHT('000000' + CAST(ID AS VARCHAR(10)), 6) PERSISTED
)
This table would contain ID values from 1, 2, 3, 4........ and the IDwithChar would be something like C000001, C000002, ....., C000042 and so forth.
0
Ramesh Palanivel8y ago
Hi Deeraj,

Set Id,ProductKey columns in your table. Set Id as PK with Identity 1, Productkey as composite primary Key.

Get the Id value 1 and find length, if Id is 12, Then concatenate string PR0012 ,
0
Suraj Kumar8y ago
Hello Dheeraj,
You can use this to generate auto alpha numeric request number

public ActionResult AutoPRNo(string lastPRNo)
{
string letter = startValue.Substring(0, 2);
int len = startValue.Length - 1;
int number = int.Parse(startValue.Substring(2));
number++;
if (number >= Math.Pow(10, len)) number = 1;
ViewBag.AutoPRNo = String.Format("{0}{1:D" + len.ToString() + "}", letter, number);
return View(); //You can return your another action here also
}

+1
Laxmidhar Sahoo8y ago
1)sir PR is constant .
2)If taking from database table select Max(id) into max variable
3) If(max , 10)
"PR" + "000" + max
else if(max <1000)
"PR" + "00" + max

.
.
.
0
Sagar Pandurang Kap8y ago
Hi,
Try this :-

http://www.dotnetspider.com/resources/43204-How-create-Alphanumeric-Auto-Increment.aspx

Hopw it will helps..
0