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 appliances asp asp.net bc30451 beginner bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn cac checkbox child class click compatible confirmationcodegeneration content contenttype control countryselector courier css database datagrid datagridview datagridviewcheckbox datalist deadlock deployment development dgv dialog dropdownmenu dynamic edit embeddingactivexcontrol feedback findcontrol flash flv form forms gridview homeedition hosting iframe iis javascript jquery list menu mono mssql multistepregistration nameisnotdeclared novell objects order problem ratings relationaldatabases rotatepage save search security serializesmo.table sessionvariables silverlight smartcard sql ssl suse textbox tracking treeview typeof unauthorized validatedate validation vb.net video virtualdirectory vista visual-studio visualstudio vs2008 web webarchitecture webdevelopemnt webdevelopment wizard xml
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC