ASP.NET RSS ASP.NET RSS

Reservation on ASP.NET

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved

•
•
Join Date: Apr 2009
Posts: 4
Reputation: cakamaya is an unknown quantity at this point 
Solved Threads: 0
cakamaya cakamaya is offline Offline
Newbie Poster

Reservation on ASP.NET

 
0
  #1
Apr 22nd, 2009
could anyone help me how to use a date function for reservation on ASP.NET....

thanx
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 115
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Reservation on ASP.NET

 
0
  #2
Apr 22nd, 2009
what are you trying to acheive? Are you trying to store dates into a table? Search on dates?

Do you have any code that you need help on?
Please mark this post as 'Solved' if it has helped and fixed your issue.
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2009
Posts: 4
Reputation: cakamaya is an unknown quantity at this point 
Solved Threads: 0
cakamaya cakamaya is offline Offline
Newbie Poster

Re: Reservation on ASP.NET

 
0
  #3
Apr 22nd, 2009
i'm just making a small project, and all i have is only the check in date and the check out date. i dont know how to block the date between it.

here are the syntax..
ASP.NET Syntax (Toggle Plain Text) 
  1.                     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
  2.                         ConnectionString="<%$ ConnectionStrings:tesDB3 %>" DeleteCommand="DELETE FROM [tesDB3] WHERE [IdTamu] = @original_IdTamu AND [Nama] = @original_Nama AND [Tgl_masuk] = @original_Tgl_masuk AND [Tgl_keluar] = @original_Tgl_keluar"
  3.                         InsertCommand="INSERT INTO [tesDB3] ([Nama], [Tgl_masuk], [Tgl_keluar]) VALUES (@Nama, @Tgl_masuk, @Tgl_keluar)"
  4.                         OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tesDB3]"
  5.                         UpdateCommand="UPDATE [tesDB3] SET [Nama] = @Nama, [Tgl_masuk] = @Tgl_masuk, [Tgl_keluar] = @Tgl_keluar WHERE [IdTamu] = @original_IdTamu AND [Nama] = @original_Nama AND [Tgl_masuk] = @original_Tgl_masuk AND [Tgl_keluar] = @original_Tgl_keluar">
  6.                         <DeleteParameters>
  7.                             <asp:Parameter Name="original_IdTamu" Type="Int32" />
  8.                             <asp:Parameter Name="original_Nama" Type="String" />
  9.                             <asp:Parameter DbType="DateTime" Name="original_Tgl_masuk" />
  10.                             <asp:Parameter DbType="DateTime" Name="original_Tgl_keluar" />
  11.                         </DeleteParameters>
  12.                         <UpdateParameters>
  13.                             <asp:Parameter Name="Nama" Type="String" />
  14.                             <asp:Parameter DbType="DateTime" Name="Tgl_masuk" />
  15.                             <asp:Parameter DbType="DateTime" Name="Tgl_keluar" />
  16.                             <asp:Parameter Name="original_IdTamu" Type="Int32" />
  17.                             <asp:Parameter Name="original_Nama" Type="String" />
  18.                             <asp:Parameter DbType="DateTime" Name="original_Tgl_masuk" />
  19.                             <asp:Parameter DbType="DateTime" Name="original_Tgl_keluar" />
  20.                         </UpdateParameters>
  21.                         <InsertParameters>
  22.                             <asp:Parameter Name="Nama" Type="String" />
  23.                             <asp:Parameter DbType="DateTime" Name="Tgl_masuk" />
  24.                             <asp:Parameter DbType="DateTime" Name="Tgl_keluar" />
  25.                         </InsertParameters>
  26.                     </asp:SqlDataSource>
could you add some code to block the date between the booked date....?

sorry if its to much trouble >.<
Last edited by Ezzaral; Apr 22nd, 2009 at 4:04 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 115
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Reservation on ASP.NET

 
0
  #4
Apr 22nd, 2009
what do you mean block the date between?
Please mark this post as 'Solved' if it has helped and fixed your issue.
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2009
Posts: 4
Reputation: cakamaya is an unknown quantity at this point 
Solved Threads: 0
cakamaya cakamaya is offline Offline
Newbie Poster

Re: Reservation on ASP.NET

 
0
  #5
Apr 22nd, 2009
block the date between the reservation date so that no one else can book between that date.

@Ezzaral
sorry.
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 115
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Reservation on ASP.NET

 
0
  #6
Apr 23rd, 2009
have a look here:

http://odetocode.com/Articles/223.aspx

not exactly what your trying to do but could give you some ideas on how to display a calendar control which will only display available dates.
Please mark this post as 'Solved' if it has helped and fixed your issue.
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2009
Posts: 4
Reputation: cakamaya is an unknown quantity at this point 
Solved Threads: 0
cakamaya cakamaya is offline Offline
Newbie Poster

Re: Reservation on ASP.NET

 
0
  #7
Apr 23rd, 2009
@ninjaimp
thank you so much....
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox child click commonfunctions compatible confirmationcodegeneration content contenttype countryselector courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dropdownmenu edit expose feedback flash flv form formatdecimal forms formview gridview homeedition hosting iframe iis javascript jquery list listbox login menu microsoft mono mouse mssql multistepregistration nameisnotdeclared news numerical objects order panelmasterpagebuttoncontrols radio ratings rotatepage save schoolproject search security serializesmo.table silverlight smartcard sql-server sqlserver2005 suse textbox tracking typeof unauthorized validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webarchitecture webdevelopemnt webservice xml youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC