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



Tag cloud for ASP.NET
.net 2.0 3.5 ajax alltypeofvideos anathor appliances application asp asp.net beginner box browser businesslogiclayer button c# cac checkbox class control countryselector dataaccesslayer database datagrid datagridview datalist deployment development dgv dialog dropdownlist dropdownmenu dynamic dynamically edit editing embeddingactivexcontrol feedback fileuploader fill findcontrol flash folder form gridview gudi iis image javascript list listbox login maps microsoft mobile mouse mssql nameisnotdeclared news novell numerical opera panelmasterpagebuttoncontrols parent problem project radio redirect registration relationaldatabases reportemail richtextbox rows schoolproject search security select sessionvariables silverlight smoobjects software sql sql-server ssl tracking treeview validatedate validation vb.net videos vista visualstudio vs2008 web webapplications webdevelopment webprogramming webservice wizard xsl
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC