如何获得自动增量,如00000,00001,00002..in asp.net [英] how to get auto increment like 00000,00001,00002..in asp.net
本文介绍了如何获得自动增量,如00000,00001,00002..in asp.net的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
朋友我有一个 中的表 add id,如 00001 , 00002 , 00003 .. etc..how to get max value from 数据库以及如何编写代码 增量...?请帮帮我...
我的代码是:
< pre lang =C#> sqlcon.Open();
string strgvid = 从tbl_apply中选择max(udid);
SqlCommand cmdgvid = new SqlCommand(strgvid,sqlcon);
int uid = Convert.ToInt32(cmdgvid.ExecuteScalar());
lbl_uid.Text = Convert.ToString(uid);
sqlcon.Close();
解决方案
而不是使用Convert.ToString,只需使用带有格式指示符的ToString: br />
lbl_uid.Text = uid.ToString( D5 );
使用下面的查询。
CREATE TABLE [dbo]。[EmployeeMaster](
[ID] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[PreFix] [ varchar ]( 50 ) NOT < span class =code-keyword> NULL ,
[EmployeeNo] AS ([PreFix] + RI GHT (' 00000' + CAST(Id AS VARCHAR ( 7 )), 7 ))PERSISTED,
[EmployeeName] VARCHAR ( 50 )
)
hi, friend i have one table in that i would like add id like 00001,00002,00003..etc..how to get max value from database and how write code for increment ...? please help me...
my code is :
sqlcon.Open();
string strgvid = "select max(udid) from tbl_apply";
SqlCommand cmdgvid = new SqlCommand(strgvid, sqlcon);
int uid = Convert.ToInt32(cmdgvid.ExecuteScalar());
lbl_uid.Text = Convert.ToString(uid);
sqlcon.Close();
解决方案
Instead of using Convert.ToString, just use ToString with a format indicator:
lbl_uid.Text = uid.ToString("D5");
Use below Query.
CREATE TABLE [dbo].[EmployeeMaster]( [ID] [int] IDENTITY(1,1) NOT NULL, [PreFix] [varchar](50) NOT NULL, [EmployeeNo] AS ([PreFix]+ RIGHT('00000' + CAST(Id AS VARCHAR(7)), 7)) PERSISTED, [EmployeeName] VARCHAR(50) )
for more details please follow below link.
C# Corner : Error Display[^]
Regards,
AARIF SHAIKH
这篇关于如何获得自动增量,如00000,00001,00002..in asp.net的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文