Loading

Duplicate values

Sandy

Hi..............
I have one column named 'Code' and other 'IdNumber' when i enter 'code' as a1 it should display 'IdNumber' as 1,again if i enter a1 it should display 'IdNumber' as 2 in this manner it should increase its value while 'code' is a1 but if i enter b1 again the 'IdNumber' should be 1,again if i enter it should display 2 same manner it should increase.This should be in mvc 4,Pls help in this.Thanks in advance

3 Replies

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

Praveen N12y ago
use Identity column it will resolve your issue.

Create Table TableAutoIncrement (IdNumber int identity,Code varchar(20) )

Regards,
Praveen Nelge
Sasi Reddy12y ago
You can set default value in database itself ,so it can increase automatically by 1
Munesh Sharma12y ago
where you are using this. means in window application or other, becoz we can do this by C# code.