Tree Chart Of Account

See more:

ASP.NET

Dear All,

I have created Table COA

Create Table COA (Account_Code Char(19), Account_Title varchar(70))


I want to display like this

ALHOA --It is fixed
01 ---- Must Be Auto Increment and input If User comes again then it will become 02
01 ---- Auto Increment all process goes like this when click it will auto generate
01 ---- Auto Increment
01 ---- Auto Increment
01 ---- Auto Increment
0001 ---- Auto Increment Last one is transaction accounts.
I want result when it saved like this ALHOA01010101010001

Anyone have idea how can i do that.

Thanks in Advance