+ Post New Thread
Results 1 to 5 of 5
Coding Thread, Visual Basic Database in Coding and Web Development; Hey all, So we still use an old fasioned system for our Projector Cleaning Rota. Head of I.T. Support set ...
  1. #1

    Join Date
    Feb 2013
    Location
    County Durham
    Posts
    32
    Thank Post
    9
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Visual Basic Database

    Hey all,
    So we still use an old fasioned system for our Projector Cleaning Rota. Head of I.T. Support set up an Excel sheet with all of the projectors in our school listed. The spreadsheet has different colums including the room that the projectors are in, the model of projectors, the date of when the last projector was cleaned and a traffic light system is currently used to check when the projectors need cleaning (Green is 0-99 Days, Yellow is 100-149 days and Red is 150+ days). This is all well and good but it just means that we need to constantly be checking the spreadsheet for which projectors need to be cleaned.

    Now since I am only an apprentice, I go to college 1 day per week. Our next assignment at college is to design or code something in visual basic that will to someones needs. My lecturer suggested doing something to tie into work and to be honest I would love the oppertunity to be able to create something like this (I really love coding!), but I have no idea where to start with it all. I am pretty fluent in the things that I have been taught in visual basic but I don't think that I have the knowledge yet to create this sort of thing.

    If anyone could point me in a good direction in terms of things I will need to know for this sort of project then that would be much appreciatied.

    Thanks again guys,
    Matt

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,225
    Thank Post
    874
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    Oh I hope you mean VB.net rather than VB6 from 1997 or so.

    If so just grab a copy of Visual Studio Express, use it to make a web app with a SQL Express DB, a dataview control and some conditional logic, you should be fine to generate it in a web page. You could also make a basic app that gets run as a scheduled task each day to check the DB and email you if required with the outstanding jobs.

  3. #3

    Join Date
    Feb 2013
    Location
    County Durham
    Posts
    32
    Thank Post
    9
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by SYNACK View Post
    Oh I hope you mean VB.net rather than VB6 from 1997 or so.

    If so just grab a copy of Visual Studio Express, use it to make a web app with a SQL Express DB, a dataview control and some conditional logic, you should be fine to generate it in a web page. You could also make a basic app that gets run as a scheduled task each day to check the DB and email you if required with the outstanding jobs.
    Yeah I was hoping to be able to have it email us, Should work great. Only problem being I don't know much in terms of SQL, Looks like I know how my half term is going to be spent. The college I am at is actually VB6, but I personally use VB.net for projects I do myself.
    Thanks a lot.

  4. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,225
    Thank Post
    874
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    Quote Originally Posted by NerdNamedMatt View Post
    Yeah I was hoping to be able to have it email us, Should work great. Only problem being I don't know much in terms of SQL, Looks like I know how my half term is going to be spent. The college I am at is actually VB6, but I personally use VB.net for projects I do myself.
    Thanks a lot.
    VS is quite good at generating most of that stuff automagicly, you can look at the codebehind. I once did almost a whole app with drag and drop, winforms and a DB.

  5. #5

    Join Date
    Feb 2013
    Location
    County Durham
    Posts
    32
    Thank Post
    9
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by SYNACK View Post
    VS is quite good at generating most of that stuff automagicly, you can look at the codebehind. I once did almost a whole app with drag and drop, winforms and a DB.
    Wow. Maybe I won't spend too much time learning .

SHARE:
+ Post New Thread

Similar Threads

  1. Databases and Visual Basic Express
    By Jobos in forum Coding
    Replies: 2
    Last Post: 1st July 2007, 10:19 AM
  2. visual basic 2005 beta 2 tutorials ?
    By mac_shinobi in forum Coding
    Replies: 4
    Last Post: 14th December 2006, 09:43 PM
  3. Visual Basic 2005 Express
    By Mintsoft in forum Windows
    Replies: 2
    Last Post: 9th June 2006, 08:21 AM
  4. LDAP & Visual basic 2005 ??
    By mac_shinobi in forum Coding
    Replies: 9
    Last Post: 10th January 2006, 10:13 PM
  5. Best manuals for Visual Basic .NET?
    By kingswood in forum Coding
    Replies: 6
    Last Post: 3rd October 2005, 10:41 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •