Click here to Skip to main content
15,918,125 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionMake a simple pattern/shape Pin
M.S.S.E10-May-20 19:21
M.S.S.E10-May-20 19:21 
AnswerRe: Make a simple pattern/shape Pin
kalberts10-May-20 20:59
kalberts10-May-20 20:59 
Questiondesktop/screen streaming to youtube/twitch by stream key or IP in visual basic.net Pin
sharath Nandakumar9-May-20 0:21
sharath Nandakumar9-May-20 0:21 
AnswerRe: desktop/screen streaming to youtube/twitch by stream key or IP in visual basic.net Pin
Richard MacCutchan9-May-20 1:22
mveRichard MacCutchan9-May-20 1:22 
GeneralRe: desktop/screen streaming to youtube/twitch by stream key or IP in visual basic.net Pin
sharath Nandakumar9-May-20 7:11
sharath Nandakumar9-May-20 7:11 
GeneralRe: desktop/screen streaming to youtube/twitch by stream key or IP in visual basic.net Pin
Richard MacCutchan9-May-20 21:23
mveRichard MacCutchan9-May-20 21:23 
QuestionFill Data of Parents and multi levels of Child tables only Pin
EngrImad2-May-20 13:53
EngrImad2-May-20 13:53 
AnswerRe: Fill Data of Parents and multi levels of Child tables only Pin
Eddy Vluggen2-May-20 21:41
professionalEddy Vluggen2-May-20 21:41 
Kids don't have multiple fathers; there can be only one.

The table-design is wrong, you don't want a table per generation. More simple, like;

VB
SomeAutoId  LONGINT,
ParentId    LONGINT,
Name        TEXT

The ParentId should point to the parent of the this record. The Id of this record in its own turn will be referenced from any children it has.

E.g.; you have a father (called father for simplicity) and two children (child1 and child2). The data would look like below;

VB
SomeAutoId    ParentId    Name
1             NULL        Father  -- Here NULL is used as a parent, 
                                  -- because we don't know about your fathers' father
2             1           EngrImad -- Here we point to record 1 in ParentId, as that is your father
3             2           Child1  -- ParentId pointing to the record with your name
23            2           Child2  -- Ditto as above; points to the record with SomeAutoId 2.
24            13          Chris   -- not your child :)
1654          23          Grandchild1 -- first child of your second child.
This way you can have an entire tree in a database, extend it easy without creating tables on the fly for generations.

That also makes populating the visual tree easier; you query your table for the root-nodes (parents without a ParentId). If that node opens, fetch the children of that node.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

AnswerRe: Fill Data of Parents and multi levels of Child tables only Pin
evry1falls4-May-20 14:41
evry1falls4-May-20 14:41 
QuestionVB.NET Pin
Babayomi28-Apr-20 12:07
Babayomi28-Apr-20 12:07 
GeneralRe: VB.NET Pin
Ralf Meier28-Apr-20 20:01
mveRalf Meier28-Apr-20 20:01 
AnswerRe: VB.NET Pin
Richard MacCutchan28-Apr-20 21:44
mveRichard MacCutchan28-Apr-20 21:44 
QuestionCompare File Date Created Date Modified in VBA ( Allow Download time 20 mintes Buffer Time) Pin
Member 1478441625-Apr-20 3:27
Member 1478441625-Apr-20 3:27 
AnswerRe: Compare File Date Created Date Modified in VBA ( Allow Download time 20 mintes Buffer Time) Pin
Richard MacCutchan25-Apr-20 4:14
mveRichard MacCutchan25-Apr-20 4:14 
QuestionBinding Navigator Movement Event Error Pin
Member 1480975421-Apr-20 23:23
Member 1480975421-Apr-20 23:23 
AnswerRe: Binding Navigator Movement Event Error Pin
Gerry Schmitz22-Apr-20 9:14
mveGerry Schmitz22-Apr-20 9:14 
GeneralRe: Binding Navigator Movement Event Error Pin
Member 1480975422-Apr-20 23:16
Member 1480975422-Apr-20 23:16 
GeneralRe: Binding Navigator Movement Event Error Pin
Mycroft Holmes23-Apr-20 11:16
professionalMycroft Holmes23-Apr-20 11:16 
QuestionLogoff or disconnect system account session at Ctrl + Alt + Delete screen Pin
Member 146239898-Apr-20 17:20
Member 146239898-Apr-20 17:20 
AnswerRe: Logoff or disconnect system account session at Ctrl + Alt + Delete screen Pin
Member 1462398914-Apr-20 9:23
Member 1462398914-Apr-20 9:23 
QuestionVisual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 4:18
raeyoung7-Apr-20 4:18 
QuestionRe: Visual Basic "originated from an internet" EXCEL Pin
Richard MacCutchan7-Apr-20 4:50
mveRichard MacCutchan7-Apr-20 4:50 
AnswerRe: Visual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 7:22
raeyoung7-Apr-20 7:22 
GeneralRe: Visual Basic "originated from an internet" EXCEL Pin
Richard MacCutchan7-Apr-20 7:59
mveRichard MacCutchan7-Apr-20 7:59 
GeneralRe: Visual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 8:07
raeyoung7-Apr-20 8:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.