H
Hisouka
DBase = 'MYDB'
User = 'Hisouka'
Password = '1234'
HEre is my Table in SQL Server
Tablename: TABLESAMP
Field1 Field2 Field3
abs NULL PRIMARY
aaa aaa Primary 1.1
zzz bbb Primary 1.2
bbb 1234 SECONDARY
ccc zzz Secondary 1.1
ddd abs Secondary 1.2
If Record in Field2 is not exist in column Field1 then the Record in
Field3 must be a root node
If Record in Field2 is exist in Field1 then the Record in Field3 must
be a sub node of last root node
Possible list on my Tree View:
PRIMARY
Primary 1.1
Primary 1.2
SECONDARY
Secondary 1.1
Seconday 1.2
Can anyone give me possible Code? including SQL Connection..
Thanks
Aprreciation if solved..
User = 'Hisouka'
Password = '1234'
HEre is my Table in SQL Server
Tablename: TABLESAMP
Field1 Field2 Field3
abs NULL PRIMARY
aaa aaa Primary 1.1
zzz bbb Primary 1.2
bbb 1234 SECONDARY
ccc zzz Secondary 1.1
ddd abs Secondary 1.2
If Record in Field2 is not exist in column Field1 then the Record in
Field3 must be a root node
If Record in Field2 is exist in Field1 then the Record in Field3 must
be a sub node of last root node
Possible list on my Tree View:
PRIMARY
Primary 1.1
Primary 1.2
SECONDARY
Secondary 1.1
Seconday 1.2
Can anyone give me possible Code? including SQL Connection..
Thanks
Aprreciation if solved..