Click here to Skip to main content
14,549,467 members

Visual Basic

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder12-Jul-09 22:40
cofounderChris Maunder12-Jul-09 22:40 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
cofounderChris Maunder10-Nov-05 16:30 
QuestionSQL error on bound datagridviews (master detail) Pin
roa20111-Jun-20 6:18
Memberroa20111-Jun-20 6:18 
AnswerRe: SQL error on bound datagridviews (master detail) Pin
Richard Deeming1-Jun-20 7:48
mveRichard Deeming1-Jun-20 7:48 
GeneralRe: SQL error on bound datagridviews (master detail) Pin
roa20112-Jun-20 0:53
Memberroa20112-Jun-20 0:53 
Questionexcel vba combobox and checkbox elements resizing Pin
Mat 25728-May-20 3:14
MemberMat 25728-May-20 3:14 
Questioni want to take average of it of one min. i have tried this code but no result found. please help Pin
Tommy Jo21-May-20 5:23
MemberTommy Jo21-May-20 5:23 
AnswerRe: i want to take average of it of one min. i have tried this code but no result found. please help Pin
Richard MacCutchan21-May-20 5:42
mveRichard MacCutchan21-May-20 5:42 
AnswerRe: i want to take average of it of one min. i have tried this code but no result found. please help Pin
ZurdoDev21-May-20 6:03
mveZurdoDev21-May-20 6:03 
QuestionHow to call a function as a callback parameter Pin
chug100818-May-20 8:58
Memberchug100818-May-20 8:58 
AnswerRe: How to call a function as a callback parameter Pin
Richard Deeming18-May-20 23:56
mveRichard Deeming18-May-20 23:56 
GeneralRe: How to call a function as a callback parameter Pin
chug100820-May-20 9:29
Memberchug100820-May-20 9:29 
QuestionCrystal Report SetDataSource Issue Pin
GeorgeChu15-May-20 6:03
MemberGeorgeChu15-May-20 6:03 
AnswerRe: Crystal Report SetDataSource Issue Pin
Eddy Vluggen15-May-20 7:38
professionalEddy Vluggen15-May-20 7:38 
QuestionMake a simple pattern/shape Pin
M.S.S.E10-May-20 19:21
MemberM.S.S.E10-May-20 19:21 
AnswerRe: Make a simple pattern/shape Pin
Member 798912210-May-20 20:59
MemberMember 798912210-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
Membersharath 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
Membersharath 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
MemberEngrImad2-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;

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;

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
Memberevry1falls4-May-20 14:41 
QuestionVB.NET Pin
Babayomi28-Apr-20 12:07
MemberBabayomi28-Apr-20 12:07 
GeneralRe: VB.NET Pin
Ralf Meier28-Apr-20 20:01
professionalRalf Meier28-Apr-20 20:01 

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.