Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    35

    Unanswered: please help on this scenario...MSSQL problem

    hi..

    I'm currently doing a assignment name online cinema ticket booking system..This is a web based system using ASP.NET.I got this problem when try to insert booking from user into database...

    I'm using MSSQL2000 and have 3 table...table seat, table movie, table screen hall

    first admin must insert a cinemaID and save it into screen hall. table movie is reference to table screen hall what the admin insert into. when user choose a movie the system will check the availability seat in table seat and check where the movie will show in table movie then display the seat available to the user.

    the problem is how to check the cinemaID from other table which in table screen hall and match it in the other table which is table movie...how to code this.... please help...
    Last edited by akuccputsedut; 10-29-08 at 22:55.
    **akuccputsedut**
    Intelligent is Me!!But a little confusing
    sometimes needs HELP!!

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Do you have FOREIGN KEY constraints?
    http://msdn.microsoft.com/en-us/library/ms175464.aspx

  3. #3
    Join Date
    Jun 2007
    Posts
    35
    hi alforin27 thank's for your advice I've learn about the contraint and I already have a foreign key contraint in my table but I'm not really know how to code in C#....how to match one to another table.... :8|
    **akuccputsedut**
    Intelligent is Me!!But a little confusing
    sometimes needs HELP!!

Posting Permissions

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