01.sqlcommand chk = new ("select Count(*) FROM tb_member",conn);
02.int tamp = convert.toint32(chk.excutescalar());
03.if(tamp == 0)
04.{
05. label1.text = A0001
06.}
07.else
08.{
09. sqlcomand chkmax = new ("SELECT MAX(ID) FROM tb_member",conn);
10. int newid = convert.toint32(chkmax.excutescaler().replase('A',''));
11. newid++
12. label1.text = "A" + newid.tostring("0000");
