Seat reservation program RSS

• • Reply
  

  j0zef

  None

  0 Points

  55 Posts

  Seat reservation program

  Jan 23, 2013 04:13 PM|LINK

  Hello,

  I would like to make a seat reservation program with a access database.

  I have 150 seats I use 150 buttons for this.

  In my database ik have a columm seatnumber from 1 to 150 and I have a columm booked with "0" and "1" values: 0 = free 1 = booked.

  In my page_load i want to make a query that looks which seats are booked en which seats are free.

  The free seats buttons are green and the booked are red. 

  so thats my problem I cant find the qeury that the buttons change the colors.

  Can someone help me?

• • Reply
  

  bbcompent1

  All-Star

  32994 Points

  8509 Posts

  Moderator

  Re: Seat reservation program

  Jan 23, 2013 04:52 PM|LINK

  Take a look at this link: http://forums.asp.net/post/5268934.aspx

  This was a thread I was part of recently and it sounds like you want to do something similar.

  Mark as answer posts that helped you.
  
• • Reply
  

  j0zef

  None

  0 Points

  55 Posts

  Re: Seat reservation program

  Jan 23, 2013 04:58 PM|LINK

  I have no problem with the design but i have a problem with my query.

  I cant found a query that when Booked = 1 then the buttons that are booked that the color doens't change to red

• • Reply
  

  bbcompent1

  All-Star

  32994 Points

  8509 Posts

  Moderator

  Re: Seat reservation program

  Jan 23, 2013 05:01 PM|LINK

  Can you post your code?

  Mark as answer posts that helped you.
  
• • Reply
  

  j0zef

  None

  0 Points

  55 Posts

  Re: Seat reservation program

  Jan 23, 2013 05:12 PM|LINK

  I dont have much code, i'm still trying :)

  but so it should look like.  

  the black seats are reserved and the red seat are the selected seats. 

  

   this is my access database table

  the first columm are the seat number and the second columm are the 0 and 1 booked or free

• • Reply
  

  bbcompent1

  All-Star

  32994 Points

  8509 Posts

  Moderator

  Re: Seat reservation program

  Jan 23, 2013 05:15 PM|LINK

  So, how are you generating this layout you show in the picture? The code that generates the grid you are showing, can you show us that?

  Mark as answer posts that helped you.
  
• • Reply
  

  j0zef

  None

  0 Points

  55 Posts

  Re: Seat reservation program

  Jan 23, 2013 05:18 PM|LINK

  I selected 150 buttons in my toolbox and set them in my design :) i have no code for that :)

  the buttons id names are: button1,button2,button3,... 

• • Reply
  

  bbcompent1

  All-Star

  32994 Points

  8509 Posts

  Moderator

  Re: Seat reservation program

  Jan 23, 2013 05:19 PM|LINK

  You could post the page's HTML so we can see what the html is doing.

  Mark as answer posts that helped you.
  
• • Reply
  

  j0zef

  None

  0 Points

  55 Posts

  Re: Seat reservation program

  Jan 23, 2013 05:22 PM|LINK

  this is my html code

  <%@ Page Title="Zitjes" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Zitjes.aspx.vb" Inherits="GP_FILMCLUB_ZULTE.WebForm9" %>
  <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
      </asp:Content>
  <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
      <h2>
          <br />
          <b><strong>Zitjes</strong></b></h2>
      <p>
          <asp:Button ID="Button1" runat="server" Text="Button" />
          <asp:Button ID="Button2" runat="server" Text="Button" />
          <asp:Button ID="Button3" runat="server" Text="Button" />
          <asp:Button ID="Button4" runat="server" Text="Button" />
          <asp:Button ID="Button5" runat="server" Text="Button" />
          <asp:Button ID="Button6" runat="server" Text="Button" />
          <asp:Button ID="Button7" runat="server" Text="Button" />
          <asp:Button ID="Button8" runat="server" Text="Button" />
          <asp:Button ID="Button9" runat="server" Text="Button" />
          <asp:Button ID="Button10" runat="server" Text="Button" />
          <asp:Button ID="Button12" runat="server" Text="Button" />
          <asp:Button ID="Button14" runat="server" Text="Button" />
          <asp:Button ID="Button15" runat="server" Text="Button" />
          <asp:Button ID="Button16" runat="server" Text="Button" />
          <asp:Button ID="Button17" runat="server" Text="Button" />
          <asp:Button ID="Button18" runat="server" Text="Button" />
          <asp:Button ID="Button19" runat="server" Text="Button" />
          <asp:Button ID="Button20" runat="server" Text="Button" />
          <asp:Button ID="Button11" runat="server" Text="Button" />
          <asp:Button ID="Button13" runat="server" Text="Button" />
          <asp:Button ID="Button21" runat="server" Text="Button" />
          <asp:Button ID="Button22" runat="server" Text="Button" />
          <asp:Button ID="Button23" runat="server" Text="Button" />
          <asp:Button ID="Button24" runat="server" Text="Button" />
          <asp:Button ID="Button25" runat="server" Text="Button" />
          <asp:Button ID="Button26" runat="server" Text="Button" />
          <asp:Button ID="Button27" runat="server" Text="Button" />
          <asp:Button ID="Button28" runat="server" Text="Button" />
          <asp:Button ID="Button29" runat="server" Text="Button" />
          <asp:Button ID="Button30" runat="server" Text="Button" />
          <asp:Button ID="Button31" runat="server" Text="Button" />
          <asp:Button ID="Button32" runat="server" Text="Button" />
          <asp:Button ID="Button33" runat="server" Text="Button" />
          <asp:Button ID="Button34" runat="server" Text="Button" />
          <asp:Button ID="Button35" runat="server" Text="Button" />
          <asp:Button ID="Button36" runat="server" Text="Button" />
          <asp:Button ID="Button37" runat="server" Text="Button" />
          <asp:Button ID="Button38" runat="server" Text="Button" />
          <asp:Button ID="Button39" runat="server" Text="Button" />
          <asp:Button ID="Button40" runat="server" Text="Button" />
          <asp:Button ID="Button41" runat="server" Text="Button" />
          <asp:Button ID="Button42" runat="server" Text="Button" />
          <asp:Button ID="Button43" runat="server" Text="Button" />
          <asp:Button ID="Button44" runat="server" Text="Button" />
          <asp:Button ID="Button45" runat="server" Text="Button" />
          <asp:Button ID="Button46" runat="server" Text="Button" />
          <asp:Button ID="Button47" runat="server" Text="Button" />
          <asp:Button ID="Button48" runat="server" Text="Button" />
          <asp:Button ID="Button49" runat="server" Text="Button" />
          <asp:Button ID="Button50" runat="server" Text="Button" />
          <asp:Button ID="Button51" runat="server" Text="Button" />
          <asp:Button ID="Button52" runat="server" Text="Button" />
          <asp:Button ID="Button53" runat="server" Text="Button" />
          <asp:Button ID="Button54" runat="server" Text="Button" />
          <asp:Button ID="Button55" runat="server" Text="Button" />
          <asp:Button ID="Button56" runat="server" Text="Button" />
          <asp:Button ID="Button57" runat="server" Text="Button" />
          <asp:Button ID="Button58" runat="server" Text="Button" />
          <asp:Button ID="Button59" runat="server" Text="Button" />
          <asp:Button ID="Button60" runat="server" Text="Button" />
          <asp:Button ID="Button61" runat="server" Text="Button" />
          <asp:Button ID="Button62" runat="server" Text="Button" />
          <asp:Button ID="Button63" runat="server" Text="Button" />
          <asp:Button ID="Button64" runat="server" Text="Button" />
          <asp:Button ID="Button65" runat="server" Text="Button" />
          <asp:Button ID="Button66" runat="server" Text="Button" />
          <asp:Button ID="Button67" runat="server" Text="Button" />
          <asp:Button ID="Button68" runat="server" Text="Button" />
          <asp:Button ID="Button69" runat="server" Text="Button" />
          <asp:Button ID="Button70" runat="server" Text="Button" />
          <asp:Button ID="Button71" runat="server" Text="Button" />
          <asp:Button ID="Button72" runat="server" Text="Button" />
          <asp:Button ID="Button73" runat="server" Text="Button" />
          <asp:Button ID="Button74" runat="server" Text="Button" />
          <asp:Button ID="Button75" runat="server" Text="Button" />
          <asp:Button ID="Button76" runat="server" Text="Button" />
          <asp:Button ID="Button77" runat="server" Text="Button" />
          <asp:Button ID="Button78" runat="server" Text="Button" />
          <asp:Button ID="Button79" runat="server" Text="Button" />
          <asp:Button ID="Button80" runat="server" Text="Button" />
          <asp:Button ID="Button81" runat="server" Text="Button" />
          <asp:Button ID="Button82" runat="server" Text="Button" />
          <asp:Button ID="Button83" runat="server" Text="Button" />
          <asp:Button ID="Button84" runat="server" Text="Button" />
          <asp:Button ID="Button85" runat="server" Text="Button" />
          <asp:Button ID="Button86" runat="server" Text="Button" />
          <asp:Button ID="Button87" runat="server" Text="Button" />
          <asp:Button ID="Button88" runat="server" Text="Button" />
          <asp:Button ID="Button89" runat="server" Text="Button" />
          <asp:Button ID="Button90" runat="server" Text="Button" />
          <asp:Button ID="Button91" runat="server" Text="Button" />
          <asp:Button ID="Button92" runat="server" Text="Button" />
          <asp:Button ID="Button93" runat="server" Text="Button" />
          <asp:Button ID="Button94" runat="server" Text="Button" />
          <asp:Button ID="Button95" runat="server" Text="Button" />
          <asp:Button ID="Button96" runat="server" Text="Button" />
          <asp:Button ID="Button97" runat="server" Text="Button" />
          <asp:Button ID="Button98" runat="server" Text="Button" />
          <asp:Button ID="Button99" runat="server" Text="Button" />
          <asp:Button ID="Button100" runat="server" Text="Button" />
          <asp:Button ID="Button101" runat="server" Text="Button" />
          <asp:Button ID="Button102" runat="server" Text="Button" />
          <asp:Button ID="Button103" runat="server" Text="Button" />
          <asp:Button ID="Button104" runat="server" Text="Button" />
          <asp:Button ID="Button105" runat="server" Text="Button" />
          <asp:Button ID="Button106" runat="server" Text="Button" />
          <asp:Button ID="Button107" runat="server" Text="Button" />
          <asp:Button ID="Button108" runat="server" Text="Button" />
          <asp:Button ID="Button109" runat="server" Text="Button" />
          <asp:Button ID="Button110" runat="server" Text="Button" />
          <asp:Button ID="Button111" runat="server" Text="Button" />
          <asp:Button ID="Button112" runat="server" Text="Button" />
          <asp:Button ID="Button113" runat="server" Text="Button" />
          <asp:Button ID="Button114" runat="server" Text="Button" />
          <asp:Button ID="Button115" runat="server" Text="Button" />
          <asp:Button ID="Button116" runat="server" Text="Button" />
          <asp:Button ID="Button117" runat="server" Text="Button" />
          <asp:Button ID="Button118" runat="server" Text="Button" />
          <asp:Button ID="Button119" runat="server" Text="Button" />
          <asp:Button ID="Button120" runat="server" Text="Button" />
          <asp:Button ID="Button121" runat="server" Text="Button" />
          <asp:Button ID="Button122" runat="server" Text="Button" />
          <asp:Button ID="Button123" runat="server" Text="Button" />
          <asp:Button ID="Button124" runat="server" Text="Button" />
          <asp:Button ID="Button125" runat="server" Text="Button" />
          <asp:Button ID="Button126" runat="server" Text="Button" />
          <asp:Button ID="Button127" runat="server" Text="Button" />
          <asp:Button ID="Button128" runat="server" Text="Button" />
          <asp:Button ID="Button129" runat="server" Text="Button" />
          <asp:Button ID="Button130" runat="server" Text="Button" />
          <asp:Button ID="Button131" runat="server" Text="Button" />
          <asp:Button ID="Button132" runat="server" Text="Button" />
          <asp:Button ID="Button133" runat="server" Text="Button" />
          <asp:Button ID="Button134" runat="server" Text="Button" />
          <asp:Button ID="Button135" runat="server" Text="Button" />
          <asp:Button ID="Button136" runat="server" Text="Button" />
          <asp:Button ID="Button137" runat="server" Text="Button" />
          <asp:Button ID="Button138" runat="server" Text="Button" />
          <asp:Button ID="Button139" runat="server" Text="Button" />
          <asp:Button ID="Button140" runat="server" Text="Button" />
          <asp:Button ID="Button141" runat="server" Text="Button" />
          <asp:Button ID="Button142" runat="server" Text="Button" />
          <asp:Button ID="Button143" runat="server" Text="Button" />
          <asp:Button ID="Button144" runat="server" Text="Button" />
          <asp:Button ID="Button145" runat="server" Text="Button" />
          <asp:Button ID="Button146" runat="server" Text="Button" />
          <asp:Button ID="Button147" runat="server" Text="Button" />
          <asp:Button ID="Button148" runat="server" Text="Button" />
          <asp:Button ID="Button149" runat="server" Text="Button" />
          <asp:Button ID="Button150" runat="server" Text="Button" />
      </p>
      </asp:Content>

• • Reply
  

  bbcompent1

  All-Star

  32994 Points

  8509 Posts

  Moderator

  Re: Seat reservation program

  Jan 23, 2013 06:18 PM|LINK

  j0zef

  <%@ Page Title="Zitjes" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Zitjes.aspx.vb" Inherits="GP_FILMCLUB_ZULTE.WebForm9" %> 

  See where it says Zitjes.aspx.vb? We need to see that file. Can you post what you find in there? There has to be something in there.

  Mark as answer posts that helped you.