VB.NET Problem..

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Hisouka

    #1

    VB.NET Problem..

    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..

Working...