I have to display the available times in a dropdownlist called "DDL_avalTime" based on the date selected in a ASP calendar.
How the program works is that when a User clicks a date form the caldendar, it checks the SQL database. In this case the table that I'm retrieving it from is "trainerbookings" from the column "trainingDateTime". The data type for this column is datetime.[code]...
I am creating a booking system, I have got it all working so that a user can select a date and a time and book, there are no restrictions so 100 people could book the same date and time.
My lecturer suggested to me that to make it so that just one person can book one time on one day the user will select a date and then the page will re-load with the times selector only showing the times which are available on this date.
I have done some tutorial work similar to this, however a little more basic showing the available slots using an except operation for example allavailableslots except bookedslots, but there was no restriction on dates, so it would just show all the times which havent been booked yet full stop. I think I will use an if statement but I am not too sure, dont really know where to start...
my tables and fields are as follows
App
Bookingid
Petid
[Code].....
clicking on a date several times and have the display show always
View 4 RepliesI have a group of three radio buttons. Depending on which radio button is selected, I want to disaply one of three controls - a textbox, a dropdown list, or a button. How do I display controls based on the result of a selected radio button?
View 1 RepliesI wanted to get your feedback on a design/coding issue. I have a treeview which represents the device tree in device manager. I also have two listviews which display information about the currently selected device on the treeview. I'm only concerned with the first listview at this point. The information displayed in the listview varies depending on the selected device. I'm using the node index to track which device class and device is selected and I pass this into the device class Display method. I hate the idea of a big Select Case statement. Then there is also the dynamic nature of the device tree to consider.
View 2 RepliesI am trying to display a record in my datagridview based on the value selected from a combobox. I tried the code below using SQL Management studio and it works perfectly.
[Code]....
i want to display a certain section of my form based on the number selected by radio button.( scale 1 to 5) by default 1 is clicked . if they click 5 then the same portion will be repeated 5 times .i have the database table structure to support this . but how to code the radio button to do the same .
View 8 RepliesI am trying to make a simple program to display a shipping charge based upon a selected zip code. Where can I find sample code that I can use as a guide? I can create the GUI but can't figure our the code.
View 2 RepliesI created 2 forms. 1 is the main form and another is monthcalendar form. When I clicked on a button in Main form it will like to another form which is MonthCalendar form. When I click on the date in MonthCalendar. How can I display the selected adte in textbox which is in the Main form?
View 14 RepliesI am traying to use the DateTimePicker to extract days diff from a date selected on DateTimePicker1 to a date selected on DateTimePicker2. I have no problem substracting the daydiff in numbers of days. The problem I have is that I need the DateTimePicker to tell me how many of those days are weekends (friday, saturday) and how many are weekdays.
View 2 RepliesI have a form based application and I need to add the ability for it to read command line arguments and not display any forms if the app was started from the command line. How can I go about this?
View 5 RepliesWould it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 RepliesI am using VB.NET. Is there a date function that calculates the date based on the number of months I have given?
for example, if i say July 2009 and looking for 10 months back, it should return Sept 2008.
I have a form that collects user parameters to print a report. There are two DateTimePickers to let the user select a date range for the report. The selection of a date range is optional so I set the From picker to a date before any data could be present. If the user wants to select a date range, the from field is set to a very old date so it takes a long time to get to any current dates. Whe I'd like to do is when the user drops down the picker, reset the date to today and let the user scroll from there.I tried the dropdown even in the picker, but the new date doesn't get set until the user has already selected a date. Any suggestions on how to get this type of UI behavior? Also any better suggestions to streamline the process?The main objective it to collect from and to dates from the user is they want to select them and collect wide ranging dates if the user doesn't enter any.
View 2 Repliesi'm trying to set a discount to a product between two dates / times.Is it possible to achieve it?Are there any examples
View 3 Repliesim struggling a bit and was wondering if anyone can help. Im looking to compair 2 sets of datess and times, for examp2 textbox1 27/02/1980 23:00 and text box 2 having the real time date and time. But instead off having years days hours mins and seconds i want to display how many seconds has passed between the two date and times. Can anyone show me how this is done as i have no clue where to start.
View 3 RepliesThe List Box has three candidates and a record Button. Every time the record button is hit I need it to add those button clicks for each candidate that is selected in the List Box. My code keeps counting all the clicks no matter which candidate I am selecting in the List Box. How can I differentiate between each selected item in the List Box. Here is an image of how the application should look: [URL] Public Class Form1
[Code]...
I've got a method which takes some parameters and generates some XML to be sent to an [archaic] web service.
[Code]...
I created a background thread that constantly scans a specified folder for any .xls files that are created or modified. These files come from a vba macro in outlook that will automatically save the attachments of the mails in the this folder. This will update the modified date/time, or at least it seems to.
For Each fi In aryFi
fidate = System.IO.File.GetLastWriteTime(path & fi.ToString)
fidate1 = System.IO.File.GetCreationTime(path & fi.ToString)
[code]....
Everytime I check to the code, the fidate and fidate1 variables are indeed the correct dates/times of the file it's currently checking. It almost never gets inside the elseif block at runtime though.
how to get the time difference between 2 date & times Where
from_time falls >= 22:00 of the From_date & the to_time falls <= 06 of the To_Date
for example:
From_Date = 01/01/2011 20:00 ' Where Work Started
To_Date = 02/01/2011 08:00 'Where Work Ended
Time_Covered_Between_22TO06_As_Night = 22:00 to 06:00 is 08:00 hrs How to equate it?
Having problems with a datatable which consists of multiple datalogger information. Within the datetime field there are as the name suggests listed date and times entry i.e. 12/01/11 22:56:56 ect ect.
Problem is i am graphing this and when ms chart reads the duplicate entries as a series. It doesnt like it and comes up with a slightly odd interpretation. I need to get the duplicate entries out to establish a single time series.
I was proposing to clone the original datatable and run a loop to remove the duplicates. I have been trying to do this for days and have played with a whole load of examples, without success. Can anyone point me in the right direction on this.
Lets say i had a label with 9/6/2010 11:59:99 that was selected from the month calendar control, is there anyway to determine how many days are from the present days date to the selected end date?
so 9/4 to 9/6 = 2 days
The "2" days is the value im seeking
Is it just me or is it so that a DateTimePicker can only be used for entering dates or times but not both?
View 9 Repliesi have the code below to ping an ip address, it works fine but Is there anyway i can include the reply times in the display or return the ping reply times in any shape or form for that matter ? preferable the average round trip time in ms is what i would like returned along with the ping result. anyone have any ideas or is it even possible to do within vb ?
[code]...
How can i display (show) the same form multiple times? Lets say Form2. This code only shows the form once: Form2.Show()
View 10 Repliesi am using date time picker and i am selecting 1 date from calender.after selection of that date i want to refresh date time picker i.e. it should display todays date.
View 2 RepliesI want to display a bitmap on my form, and then remove it at times, and put it back again.
I have the Bitmap in my resources folder.in my form properties, it is selected as background image.
somewhere in my code I set the background image to = nothing (that makes it disappear) but every time I try to bring it back, I get file not found.I got it to display when I hard-coded the entire path and filename.[code..]
Obviously, when I publish and distribute to clients, the file won't be there.[code...]
For example, today is 05/11/2009, I have two text box.
Actually it means that whatever what date i choose within the current month, the two textbox will display the last three months date.
For Example, Current Month is November 2009 , Textbox 1 will show 01/08/2009, Textbox 2 will show 31/10/2009.
Another example is Current Month is January 2009, Textbox 1 will show 01/10/2009, Textbox 2 will show 31/12/2008.
May I know how the vb.net code should look like?
Im trying to create a program that can search files and display the amount of times that it has been encountered, for example it will show the number 4 because it will run into four instances of the word. Im kinda stuck on how to do this,
View 3 RepliesI have set up text boxes for user to pick a number 1-20 and to enter a word as well. Then, press submit button. What's supposed to display in result textbox is the word that many number of times. For example if the number is 5 and the word is hello, then "hellohellohellohellohello" should appear. I don't know how to complete my For...Next function to append the word to the result.
Public Class Ch6ex1
Private Sub btnsubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsubmit.Click
[CODE].....................