Interactive graphic - Visual Basic 2005 [modified]
-
Hi, i am somewhat of a new programmer to visual basic... progamming knowledge at a bit of a sad low level. part of the program i am building requires the following: my so called client leases out spaces on pieces of land for whatever purpose, in a sort of perfect grid. firstly, the layout of how the land will be divided is loaded as a template to the system, details stored on database... total plot dimensions, and vertical and horizontal spaces is stored. the program generates a little grid display of what it might look like, thats simple enough. when the user requires a piece of land to be formatted according to his needs, the template is selected from database, new entry is created in a table dealing with active plots. for each sector of land, a serial number gets generated, each sector state set to "vacant". the problem on my part (due to my pathetic coding skills) comes in with coding the actual bookings part of the system. when the user selects the appropriate plot of land to perform bookings on, an interactive display of the plot needs be generated out of information in the database table. occupied sectors and vacant sectors in different colours, and the user needs to be able to highlight various (multiple) vacant sectors to book for his client. when "book" is clicked, the status field in the land plot table needs to be changed from "vacant" to "occupied". i have a very very vague idea on how this is to be done, but at the moment, am completely stuck. not a clue as to how to generate the plot of land on screen with the different colours from the information in the database table, and beyond that, how to make it "interactive" with mouse events annnnd how to program it to return the values of which sections were selected i'd really appreciate any suggestions. :doh:
modified on Monday, August 18, 2008 8:22 PM
-
Hi, i am somewhat of a new programmer to visual basic... progamming knowledge at a bit of a sad low level. part of the program i am building requires the following: my so called client leases out spaces on pieces of land for whatever purpose, in a sort of perfect grid. firstly, the layout of how the land will be divided is loaded as a template to the system, details stored on database... total plot dimensions, and vertical and horizontal spaces is stored. the program generates a little grid display of what it might look like, thats simple enough. when the user requires a piece of land to be formatted according to his needs, the template is selected from database, new entry is created in a table dealing with active plots. for each sector of land, a serial number gets generated, each sector state set to "vacant". the problem on my part (due to my pathetic coding skills) comes in with coding the actual bookings part of the system. when the user selects the appropriate plot of land to perform bookings on, an interactive display of the plot needs be generated out of information in the database table. occupied sectors and vacant sectors in different colours, and the user needs to be able to highlight various (multiple) vacant sectors to book for his client. when "book" is clicked, the status field in the land plot table needs to be changed from "vacant" to "occupied". i have a very very vague idea on how this is to be done, but at the moment, am completely stuck. not a clue as to how to generate the plot of land on screen with the different colours from the information in the database table, and beyond that, how to make it "interactive" with mouse events annnnd how to program it to return the values of which sections were selected i'd really appreciate any suggestions. :doh:
modified on Monday, August 18, 2008 8:22 PM
brajoez wrote:
somewhat of a new programmer to visual basic
brajoez wrote:
my so called client
brajoez wrote:
due to my pathetic coding skills
Why do you have a client if your skill level is so poor ? You basically need to handle the paint event, draw your land, track your mouse movement and actions and store changes back to the DB. I suspect you know that already, but if you do, I'd suggest making a start and asking specific questions as you get stuck. I'd be inclined to create a class that represents one object in the DB, and write it so that it responds to mouse events and knows how to draw itself, then call the draw code for your collection of objects in onpaint, and find the object your mouse is over in mouse events to pass it the event.
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.
-
brajoez wrote:
somewhat of a new programmer to visual basic
brajoez wrote:
my so called client
brajoez wrote:
due to my pathetic coding skills
Why do you have a client if your skill level is so poor ? You basically need to handle the paint event, draw your land, track your mouse movement and actions and store changes back to the DB. I suspect you know that already, but if you do, I'd suggest making a start and asking specific questions as you get stuck. I'd be inclined to create a class that represents one object in the DB, and write it so that it responds to mouse events and knows how to draw itself, then call the draw code for your collection of objects in onpaint, and find the object your mouse is over in mouse events to pass it the event.
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.
Christian Graus wrote:
Why do you have a client if your skill level is so poor ?
Possibly because his strong marketing skills. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[Image resize DLL] -
Christian Graus wrote:
Why do you have a client if your skill level is so poor ?
Possibly because his strong marketing skills. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[Image resize DLL] -
no my brother. this is africa. i am a plumber, electrician, mechanic and a carpenter as well. we do what it takes to make money. im not too good at the plumbing thing though... :)
brajoez wrote:
this is africa.
Your profile states
USA. :)If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[Image resize DLL] -
brajoez wrote:
this is africa.
Your profile states
USA. :)If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[Image resize DLL] -
brajoez wrote:
my vhost
:confused:
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]
