For the past day or so, I have been trying to compare values in my SQL server against an actual calendar. I have had mixed luck with this and I have exhausted my limited knowledge. I am looking for a shove in the right direction.
Background:Right now, I have a program that writes a record to a database when the program completes successfully. This time stamp has both the date and time on the SQL box. I want to grab that information and compare it against the basic calendar. I have attached a picture that should help explain things. This is just my test app,
I have a program that backs-up remote locations to a centralized FTP server. Upon successful completion, a record is written to a SQL database with the following information:
I am currently managing the program by running a report on who has written a record to the database. If the record is not written, I manually go in and backup the necessary files.The problem with this, is that it can take up to 30 minutes/day to do this task. While that's not a long time, it's getting somebody to be dedicated when I'm off and that has proven to be difficult.
I want the program to automatically search for missing records, but I'm not sure how to do this. I was thinking about bringing in the last 30 days with a SELECT statement and then comparing the information that I have in the SQL database versus a calendar control (or something). I need to make this process completely automated and not very intensive on the SQL server. I only have the following
2010 Sub FindMissingBackups(ByVal DaysToCheck As Integer, ByVal StoreNumber As String) Dim TodaysDate As SqlDateTime = Now() Dim PastDate As SqlDateTime = DateAdd(DateInterval.Day, -DaysToCheck, Now())
how to disable the datetimepicker dates in the future and also all the weekend dates but i am unable to find any! Only thing i can find is ASP.net code.
I have one more problem with MonthControl.And when I bold some dates the program doesn't show bold dates on month calendar.When I move on next or previous month and get back to currently month the program normal displays bold dates. What's the problem?
How to compare Two Dates if it is Less Than or Greater Than?? I want to know the code that shows an msgbox "Date Past" if the date in a datepicker is already past.
iwant to create an dll file for comparing two text box dates,, since in my project comparing dates is very necessry for every form,,so iwant to create an dll file,, here iam created an dll file but it was not working, here iam working with asp.net with vb.net..... here my code os given below,
Imports System Imports Microsoft.VisualBasic Namespace datecompare
I'm trying to make this program which compares the difference between any date in the past and the system date, showing how many days have elapsed since that date. This is the layout I've created so far, the two date boxes currently show the system date so even if I change the system date, both those boxes will adjust to show it as well. I want to try and make the system date a box without a drop down arrow and so you cannot edit the box at all. The box below is fine how it is as the user can enter any date they desire. And the text box at the bottom needs to show the difference between the system date and the inputted date.
I am using VS 2010 and am hoping this had been fixed. But I wanted to bold holdiday's in my calendar.... problem is.. it is not taking...
If My.Settings.OtherHolidays = True Then GetOtherHolidays(Me.MonthCalendar1.SelectionStart.Date) For index As Integer = 0 To arrOHDays.Count - 1 'UBound(arrOHDays)
I have a dataset that returns the following data:[code]The first character is the shift code, the next date is the beginning of the shift the next day is the ending day of the shift and the last field is if it is a day shift (0) or night shift(1).I need to display the dates for the DBX dates in a light blue and the ACY in white.These shifts are always on the same days, just A,B,C,D rotate from night I am new to web development and just trying to create a shift calendar on the fly,What the result should be is a calendar with 4 days shaded blue, and 4 days shaded white.
how to load multiple dates onto a month calendar so I could see them all on it. I will need to load the dates from a database on it but if for know somebody could give me an example on how to load at least 5 dates on it that would be good start.
been a long time since i came to the forum. i use to program a lot in vb6 but its been a long time since i did it so im really rusty. now that im trying to get back to programming, im finding it a bit of a challenge in vb2008... i have this question, im using a datetimepicker control to select dates in a calendar. what im trying to do is disable the textbox in the datetimepicker so that the user can only use the drop down calendar to select the date and not enter the date manually! does any one knows how to disable the textbox in the datetimepicker but still be able to select a date from the calendar???
I am currently using VB. I want to do a Calendar Control which have dates highlighted/selected. All these dates are retrieved from a database.
how to put all the dates into an array Second thing I need to know is how to highlight all the dates in the array.
I have done some research on the internet and they said something about selectedDates and selectedDates collection and dayrender. But frankly speaking, I can't really find any VB codes regarding this. Dates format will be in dd/MM/yyyy
Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page
1.When the user clicks the button the info from the controls on the left appears in the label on the right. 2.How to retrieve the selected dates from the calendar control when the user clicks the button?
I am trying to make a reminder, but i can't figure out one thing. Anybody out there knows how? I would like my reminder to have a function when you select one date it automaticaly adds 2 reminders up to the day of the event. For example if you select the event at date 24 it would automatically add two events at the calendar at the dates 17 and 10.
I've been trying to search out the answer to this question, but i couldnt find any. How do set the calendar component to display only certain dates, say 6 weeks from current date?
I have a few questions. I am not understanding on how to do it.The first question is:
1.When the user clicks the button the info from the controls on the left appears in the label on the right. 2.How to retrieve the selected dates from the calendar control when the user clicks the button?
i have imported some data from excel and into datagridview but does anybody know the code to compare data in 2 columns to see if they are equal and if they are not equal a messagebox would show "there are errors" else it would show "there is no error, you may continue".
the attached file is an example of the excel data i imported to datagridview.
All that is happening above is two players are being compared by scores and a winner is then decided. The calculation works fine and places the winner in the correct spot (txtWinner1.Text) as long as the numbers are positive. So if txtU1D.Text has 13 and txtU2D.Text has 14...txtU2 is the winner. Works with no problems. However, if txtU1 has -1 and txtU2 has -2...it says txtU2 is the winner. The negative scores are common in the game being played so the situation often happens, but may be one player only. It seems to work if one is positive and one is negative, but if both are negative it thinks the higher negative number is the winner for some reason. So it will give the win to someone who has -9 over someone who is -4.
We publish official documentation into pdf's, tiffs, and cals depending on the document type. Recently, we have discovered that somewhere in our publishing process, the system can hiccup and cause a character or two to become missing. It's intermittent and not consistent. We have a fix for it, but unfortunately have hundreds of thousands already published in the repository. It was brought up that we may want to consider developing a batch comparison tool that would compare a newly published version to the original published version to identify the problem documents. There was multiple thoughts on how to do this:
1.) Compare file sizes... unfortunately, any variation will cause the sizes to vary and small variations may not accurately reflect in it.
2.) Binary comparison... not sure how this would work at a file level like this
3.) Hash MD5 Compare... not sure how this would work either.
So I thought I'd ask those out there with some similar experience, what is the best way using the .Net Framework to compare one tiff to another, one pdf to another, and one cal to another?
using the calendar from the webfor tools, NOT CALENDAR EXTENDER, and my question is, is there a way to add text to a specific day of the calendar, for example, that i want to click on the number where its shows 29 of the month december, then it shows me a texbox or anything that takes data from my, and i type anything in there, like an event or something, then i click on a button to save my entry, and next time i visit my page i see that day that i clicked on changed its color and shows my text when i hoover the mouse on top of it,
I have this piece of code which goal is to compare ALL records from recordset rs1 to ALL records of recordset rs2. Im doing something wrong because, when the code finishes I find that some records that fulfill the matching condition are not being considered as matched.
I have just got onto the programming band wagon and would like my first program to be a calendar.r point me into the right direction as i got no clue where to start.
how to compare two list boxes and remove identical values or add them to a 3rd list box, but for some reason it's not working when I retrieve the data from a mySQL database using ADODB, here's my work cut down by a fair bit for it to be easy to understand.
For k As Integer = lstFriends.Items.Count - 1 To 0 Step -1 If lstDBFriends.Items.Contains(lstFriends.Items(k)) Then lstFriends.Items.RemoveAt(k) End If Next
I've tried everything from changing the data type on the mySQL database to storing the retrieved data from the database to String declaration and it simply wont compare the two listboxes
I am using a monthcalendar control and I want to use a mouse over event. Basically when the user hovers over a date I want to be able to display that date in a label or something is that possible?
I am using VB.NET and Visual Studio 2010 to write my program. The source of the control that I am using can be found here. First, I imported the Calendar.DayView.dll file into my toolbox to use as a control. Then I added the following code to my existing code:
Private Sub DayView1_NewAppointment(ByVal sender As System.Object, ByVal args As Calendar.NewAppointmentEventArgs) Dim appointment As New Calendar.Appointment() appointment.StartDate = args.StartDate appointment.EndDate = args.EndDate appointment.Title = args.Title appointments.Add(appointment) End Sub
I get this error 'Title' is not a member of 'Calendar.Appointment'. I have no access to the Calendar namespace or the Appointment class. I am able to view the properties of both in the Object Browser but I can't edit any of them.
