vb.net - Objects within Arrays, and changing their properties -

-

this program seat booking system , having problems when checking availability of each seat.

when form loads, array created , stores seat names in. each seat check box displayed button. sql statement runs , finds records null customer id field, seat id of seat , show date of friday. if number of records returned = 1, color of check box button turn green, else turn red.

the code check availability works perfectly, i'm not sure how change colour of checkbox in position of array change. believe because array holding strings, not objects. have done lot of research on , cannot seem find solution.

what need name of seat (a1,a2, etc.) stored in array can used in sql statement, way change color of seat. there 197 seats in total, why going need array.

i appreciate solution problem , provide information below including screenshot of database table, screenshot of form design , code.

database table: http://gyazo.com/0cf669a1c2144b7174066bdbbd29d3a3

form design: http://gyazo.com/b9400018cccd61afb83518e3754df2d4

    private sub frmseatplan_load(sender system.object, e system.eventargs)     handles mybase.load     dim seat(11, 15) string     dim seatname string     dim sql string     dim da oledb.oledbdataadapter      seat(1, 1) = a1.name     seat(1, 2) = a2.name     seat(1, 3) = a3.name     seat(1, 4) = a4.name     seat(1, 5) = a5.name     seat(1, 6) = a6.name     seat(1, 7) = a7.name     seat(1, 8) = a8.name     seat(1, 9) = a9.name     seat(1, 10) = a10.name     seat(1, 11) = a11.name     seat(1, 12) = a12.name     seat(1, 13) = a13.name     seat(1, 14) = a14.name      dim x integer     dim y integer     y = 1 1         x = 1 14             seatname = seat(y, x)              con.connectionstring = dbprovider & dbsource             con.open() 'opens connection database              sql = "select * bookings show_id = 'friday' , customer_id null , seat_id ='" & seatname & "'"             da = new oledb.oledbdataadapter(sql, con) 'create data adapter store filtered data using sql code             msgbox(sql)             da.fill(ds, seat(y, x))              'count number of records empty customer id, show id of friday , seat id of seat.             dim recordcount integer             recordcount = ds.tables(seat(y, x)).rows.count             msgbox(recordcount)              if recordcount = 1                 'change backcolor green               else                 'change backcolor red              end if              con.close()           next x     next y end sub

put controls in array, instead of names. use name property array when need it, , can access backcolor or other properties/methods when need them too.

like this:

private sub frmseatplan_load(sender system.object, e system.eventargs) handles mybase.load     dim seat(11, 15) control    '** changed string **     dim seatname string     dim sql string     dim da oledb.oledbdataadapter      seat(1, 1) = a1     seat(1, 2) = a2     seat(1, 3) = a3     seat(1, 4) = a4     seat(1, 5) = a5     seat(1, 6) = a6     seat(1, 7) = a7     seat(1, 8) = a8     seat(1, 9) = a9     seat(1, 10) = a10     seat(1, 11) = a11     seat(1, 12) = a12     seat(1, 13) = a13     seat(1, 14) = a14      dim x integer     dim y integer     y = 1 1         x = 1 14             seatname = seat(y, x).name              con.connectionstring = dbprovider & dbsource             con.open() 'opens connection database              sql = "select * bookings show_id = 'friday' , customer_id null , seat_id ='" & seatname & "'"             da = new oledb.oledbdataadapter(sql, con) 'create data adapter store filtered data using sql code             msgbox(sql)             da.fill(ds, seat(y, x).name)              'count number of records empty customer id, show id of friday , seat id of seat.             dim recordcount integer             recordcount = ds.tables(seat(y, x).name).rows.count             msgbox(recordcount)              if recordcount = 1                 'change backcolor green                 seat(x, y).backcolor = color.green             else                 'change backcolor red                 seat(x, y).backcolor = color.red             end if              con.close()          next x     next y end sub

Comments

Post a Comment

Popular posts from this blog

Perl - how to grep a block of text from a file -

-
it can in xml or text format. how in general grep block of text in perl? <track type="ws"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>0</locationindex> <propertyindex>0</propertyindex> </range> </track> <track type="ps" id="1"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>1</locationindex> <propertyindex>1</propertyindex> </range> </track> i want grep type="ps" , till </range> . one solution open file, read line line , match block. open(fh, "file.txt"); foreach $line (<fh>) { if ($line =~ m/type="cc"(.*?)<\/range>/) { print $1; } } but there more optimal solution without reading file line l
Read more

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

-
Image
if set mycoolbar.fixedorder true,only grip on first band hidden. well,if use delphi 7 create vcl forms application,then put coolbar on , create 3 coolbans hold other controls,only grip , top coolbands can hidden setting mycoolbar.fixedorder:=true. i've uploaded picture make things clear. you got fixedorder property wrong. fixed property not allow bands rearranged if set true . setting property of coolbar true keep user changing bands order @ runtime, user can still move , resize bands. can give advice can do, actual solution problem, well, have wait answer. my advice use 3 coolbars in row , setting "fixedorder" property true , bandborderstyle bsnone . way grip hidden on of them. about property, it's not bug of ide, actual preference of property.
Read more

javascript - Animating array of divs; only the final element is modified -

-
this baffling me @ moment. i'm experienced programmer looking throw bit of surprise fiancee on countdown page our wedding. desired effect simulated confetti falling behind main page. setup follows: i have array of divs in javascript. each div absolutely positioned on page. have interval set updates every 50 or milliseconds. on each tick, run loop on array of divs, , calculations , update positions. problem problem having, however, though can see divs created, stored array, , modified (in case, each has slight randomized rotation) during initialization phase, once tick update position starts, div stored in whatever last slot of array gets position updated. tried hard-coding each div index testing purposes, strictly last element update position. upon printing current "left" , "top" style values each div before , after calculations shows value has been changed, no visible change noticeable. here's basic code: javascript var container;
Read more