Jul 24, 2009
I have built a matrix style controlboard ( many pictureboxes used as buttons) To call on a simple database. Being a beginner, I have not yet found any code for doing a query of sunh simple nature as this database. The Northwind samples are far more complex than what i have, but this is my main program, the reason I got into VB in the first place. 2 pictureboxes say PB1 & PB2. PB @ ontop of PB1. PB2 is invisible, but blocks view of PB1. Clickon 2, & it Hides(). Click on 1, & 2 Shows(). a simple math control box counts the events & turns the group inputs into binary output... 4textboxes per group is the way I chose Ther are roughly 200 pairs of these sporadically placed, this is just 1 pair. Textbox 16, & 18=0 @ form load 17 fixed ="1" 15 sets of these, TextBox42= binary value. This is the one that triggers the events for column "C" in the database. ( Their not in perfect order)
View 2 Replies
Anyway, this is where I need to get information tfrom the database to the listbox, heres that situation: Database has simply named columns A,B,C,D,E,F, G, H, ect.. Then the rows are equally simplistic row, rowB, rowC,..Any combination is represented here, Each row has several, but not all of the columns values. Since if only 2, or 3 of the variables clicked can = several different groups, a multiple reurn to the listbox is nessessary. I seen some code in an exercise that I think will do that, but how do I query the database to start the listbox load? The lesson shows a completely different situation for loading the listbox, but I think I can amend that easily enough. I just can't ask the simple question to the database.
Question is, if picturebox related to column "C" is clicked, how do I call the group names ( rows ) of those positive in Column "C" to the listbox? The Database is litterally that simple. Just 1 situation of columns & rows, not mutiple as in the lessons. If anything, I fear I'm too much a simpleton. I have added the PB's code