This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello
We have 3 seats available each 8 hrs and we run two shifts
first shifts = 09:00 = 17:00
second shift = 17:30 = 01:30
For Example : 1 Todays Date Is 01-AUG-2021 and user enter In Textbox1 and Textbox2 like this below
Rajesh 22
Mohan 40
Priya 23
On button click i want to save like this below in MS SQL BOOKING_TABLE
Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23
For Example : 2 Now one more user coming On 01-Aug-2021 he is giving data like this
Johar 18
Rani 22
On button click i want to save like this below in MS SQL BOOKING_TABLE
Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23
01-Aug-2021 17:30 = 01:30 Johar-18 Rani-22
For Example : 3 02-AUg-2021 no is coming next one more user coming 03-AUG-2021 he is giving data like this
Arshad 25
John 19
On button click i want to save like this below in MS SQL BOOKING_TABLE
Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23
01-Aug-2021 17:30 = 01:30 Johar-18 Rani-22
03-Aug-2021 09:00 = 17:00 Arhsad-25 John-19
how to do this in old asp.net 2.0 C#
thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 51%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Hi @RAVI ,
Do you want that if today is 01-Aug-2021 and comes 7 users. The data will be saved like three in the 01-Aug-2021 09:00 = 17:00, three in the 01-Aug-2021 17:30 = 01:30 and the other one is 03-Aug-2021 09:00 = 17:00. Do you want like this? Do you need to write sql query to insert these data in the old asp.net webform?
Best regards,
Yijing Sun
Hello
Simple Way To Say Instert In MS SQL TABLE Like Movie Ticket Booking IF seat available it has to say already plan if not then have to move next available slot per day the movie run in theater in two times slot first shifts = 09:00 = 17:00
second shift = 17:30 = 01:30
Hi @RAVI ,
How do you design your codes and database? As far as I think,the best way is when you come a user and he will save his booking information in the database.If three seats have booked every time, you could do a prohibition that users can't select the time.You only need to check the number of the seat in the database.
Thank you
Please give me one small example complete code with aspx and c# code page.. Thanks
Hi @RAVI ,
aspx: date(calander) time(radiobutton)
aspx.cs : user logining-->session["username"]-->count this date and time how many count--> if count<=3, insert into the username, date,time --> if count>3, today,disable the radiobutton.