i am having problems getting my calendar to work, passing a start and end date for a rental car and displaying on the form the number of days chosen and the amount for the total. This is the first form problem I have done. I cannot see what I am doing wrong. It does not figure number of days and the amount just stays zero.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
[code].....
I am trying to get the date parts selected by a user on the MonthCalendar control. I know how to set the date, thanks to some help from this forum. Now I have run into another problem. I need to be able to take the MONTH, YEAR and DAY selected by the user. I have tried this example I saw, but it does not work, mmDay = CalendarMonth.Tex.ToString("d").
View 1 RepliesI would like to be able to either: (1) Pick a date from the Monthcalendar box and have it insert that day into a textbox showing in a format of Day of week, Month/Day/Year or Day of week, mm dd yyyy. or in option #2 be able to enter in the date by mmddyyyy and get Day of week, mm dd yyyy showing in the textbox.
View 1 RepliesI have a question: How do you set the color of a date in a MonthCalendar? I used this code, but i get errors
ViewStayingPattern.MonthCalendar1.ForeColor.Red(NewDate)
*NewDate is the date I want to be colored.
How does one set the date in MonthCalendar control. I am using VB2005.NET. I am new to this - from VB6.
View 1 RepliesI am using MonthCalender control in vb.net to select a date. I am able to save the selected date to DB and also retrieve and bold the previous selected date. But even though date is bolded it is not displayed when the form loads. It still highlights today's date. What Do i do to highlight the previous chosen dates. Also i want to disable choosing date range.
[Code]...
I've hardcoded my date into my app, but now I want to read it from the database. I knowhow to read the columns, but unfortunately I don't now how to make the date appear into the monthcalendar.[code]...
View 16 RepliesI created a monthcalendar usercontrol and calling it from a parent form (in this case, click on button to populate the textbox beside it). Two questions.
1. How do I return the selected date back to the parent textbox?
2. How do I bring the monthcalendar usercontrol to the front and back of other objects?
Can I change a bolded date's color of a MonthCalendar control without creating a new custom control? Should I override OnPaint event, or something for this? If so, how?
View 5 RepliesI've seemed to found some interesting behavior with the stock MonthCalendar control. I've set the MinDate property to 1/1/1990 but when I try to actually select a date anywhere previous to 1/1/2000 it jumps to 12/31/2999 why is that?
I've tries manually setting it to 4/8/1998 and it jumps to 4/8/2998 which isn't what I would expect a calendar control to do. Is there a reason it keeps it within the 21st century?
I want to enter Year, Month & Date in a separate TextBoxes to get a Function work as these 3 have to be given as parameters for that Function. I've been using 3 different TextBoxes to enter the Year, Month & Date. Now, I thought of using either a DateTimePicker / MonthCalendar for this. how to get it done. By clicking a Date in the DateTimePicker how can I get the Year, Month & Date separately fed into the Function? [Code]
Is there any way of getting the year, month & date separate from the DateTimePicker / MonthCalendar?
I have a month calendar on a form. It is showing 2 months, when I select the start date for a range of dates, the month calendar blinks for about 1 second. Here is the code that gets the start date, sets the end date (28 days later), then assigns a date to the text of 28 checkboxes by looping through the control collection.[code]
View 4 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 have several records in a database that have Start and End Dates
09/15/2011 - 09/30/2011
10/15/2011 - 10/22/2011
11/01/2011 - 11/15/2011
When user stores a record, I need to make sure dates don't overlap.My simple code checks date ranges within a specific record (e.g. user enters 9/16/2011 or 10/21/2011, I throw an exception.)But, on the slim chance a user gets creative (e.g. 10/14/2011 - 10/23/2011 or even 10/14/2011 to 11/16/2011), now they have circumvented my check.BTW, the user could enter 10/14/2011 to 10/23/2011 if they were editing the record that contained values 10/15/2011 - 10/22/2011.So, I'm trying to solve this riddle with a linq query. However, what I have isn't working exactly right.
UPDATE Nevermind about code not working. While trying to provide an example to expand on Miika's repsonse, I found my answer. So, giving credit to Miika for pointing me in the right direction and posting my working code below:
Here's my code:
Private Sub CheckForOverlap(myMonth As Messages.MyMonth)
Dim am As New MyMonth()
Dim amCollection As Messages.MyMonthCollection
[code]....
I am trying to get a list of dates from a provided StartDate and EndDate in my database, and use these dates to link to dates in a database (to display another variable on the y-axis of the chart) and to populate the x-axis of a chart (with the list of dates). Is it possible to get a list of dates in VB and pass them into a chart this way?
View 2 RepliesWhen I select a beginning date on my MonthCalendar control it blinks real quick and then reloads,I am pretty sure this is not a normal behavior?code to select bolded dates and set beginning date and set controls with date range:
Me.txtStartDate.Text = Me.MonthCalendar1.SelectionStart.ToShortDateString
Me.txtEndDate.Text = CStr(Me.MonthCalendar1.SelectionStart.AddDays(27))
' create an Array of dates to hold the Range of dates from the MOnthCalendar[code].....
i just want to ask how can i populate a listview n vb.net that has a is limited by a date from and date to.i have a datetimepicker for start date and datetimepicker for end date and i want do list all the entry of my database in listview that is within the range of the start date and end date.
View 5 RepliesI have following code and I can filter data on grid but when I pick same date in 2 datepicker it shows nothing.
[Code]...
How to get if the date entered is in the range?
Ex. the month of April, the number of days is only 1 to 30. What if the user will enter the date range of 4/1/2011 to 4/31/2011 in the mask textbox? I am using Mask textbox because datetimepicker will not accept empty value and it cannot be empty either.
I'm asking this because I encountered an error when querying in MS SQL SERVER 2005. It says "The conversion of char data type to smalldatetime data type resulted to in an out-of-range smalldatetime value." I thought it was the casting or conversion problem. I've observed the SQL when transacting and I found no difference with my code.
So then, I just figured it out that my date exceeded the number of days of the April month.
Can somebody show me how to loop through days between two DateTimes in VB?
View 3 RepliesI have following code and I can filter data on grid but when I pick same date in 2 datepicker it shows nothing. How can I fix the problem.
[Code]...
I have two DateTimePickers controls.I am wanting to loop from one date to the other, displaying the date in a msgbox.[code]
View 4 RepliesI have a datagrid view with some data in it. The first column (0) is called 'Date' and contains the dates I want to work with.What I would like is to be able to filter (only display) the data between a date range selected by the user using 'Datetimepicker1' and 'Datetimepicker2'
This is the code I have. its not right of course, but it may help explain what I'm trying to achieve, I wonder if someone could give me a pointer?
[Code]...
i dun know wats wrong wit my code.....i would like to search the date which located between 2 date time picker and make it goes into print preview.
Dim CustomerFound As Boolean = False
Dim daterange As String
daterange = "[Date of Booking] >=#" & Datetimepicker1.Text & "# AND [Date of Booking] <=#" &
[code]......
I would like to select transaction id based from its creation date. All transactions are displayed on form load event on a datagrid. The select function should be executed on 2 datetimepicker (the first should be the start date, the last should be the end date).So there are three controls on a form, 2 datetimepicker and a datagrid. I managed to load all transactions into a datagrid, and managed to select/filter those transaction based on id, but not date.the table is called 'transaction_details', it contains 'transaction_id', 'transaction_date', and few other columns. transaction_id is the primary key.
View 2 RepliesI am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
cmd = "SELECT SAMPLE,VALUES,MAX,MIN FROM TABLE1 WHERE [CHECK_DATE] BETWEEN 01/01/2009 AND 01/01/2011"
code CrystalReport by two DateTimePicker but get error "Mismatched data types in criteria expression"
This is the code
Private Sub btfechascrystal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btfechascrystal.Click
[code].....
I'm wanting to loop through a range of dates set by date time picker. This is my code and as the SD.Value.Date is 23/05/2010 it shows Sunday for me. However on the Loop it keeps showing Sunday and Never stops.
Dim SD As Date = StartSearchDate.Value.Date
Dim ED As Date = EndSearchDate.Value.Date
Do While SD.Date <= ED.Date
MsgBox(SD.DayOfWeek.ToString)
SD.Date.AddDays(1)
Loop
Have a column of dates which i need to compare to a specific time of the year, which establishes what calculation needs to be applyed then depending on the outcome apply conditional formating to highlight an adjcent cell, but need to remove the YY element as the contents spans multiple years.
if the date in A1 is between 1st Jan & 14th Mar use -8
if the date in A1 is between 15th Mar & 15th Oct use -17
if the date in A1 is between 16th Oct & 31st Dec use -8
Then deduct the above value from B1 to give a target for each row (from 3 onwards)if the target is < the value in n then change background orange in f
I have a calender which highlights the selected date from the database. It currently highlights the start date only...I would like it to highlight the range of dates (start date - send date)[code]I think the query and where statement used is not pulling through the correct information but not entirely sure where or how to correct it ...
View 1 Replies