VS 2010 : Comparing SQL Records Versus Calendar?

May 2, 2011

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:

GUID (uniqueidentifier)
StoreID (varchar(5))
DateStamp (sqldatetime)
ProgramAndVersion(varchar(50))

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())

[code]....

View 1 Replies


ADVERTISEMENT

VS 2010 Comparing Dates (SQL / Calendar)?

Jun 14, 2011

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,

[Code]...

View 16 Replies

VS 2010 Records Missing While Comparing Two Recordsets?

Mar 16, 2012

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.

[code]...

View 7 Replies

ArrayList Versus Structures - 'array Of Records'

Jun 23, 2009

Is an ArrayList the same thing as a Structure (i.e. 'array of records')? If they're not the same think, what't the difference?

View 3 Replies

[2005] Today.date Versus Now Versus DateTime.Now?

Jan 16, 2009

just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.

DateTime.Now is from System.DateTime.Now
Now is from Microsoft.VisualBasic.DateAndTime
Today.date is also from System.DateTime

View 4 Replies

Comparing Text File Records Line By Line?

May 14, 2009

I have to create a new program that reads to Text files. These text files are in the form of a report (with column headings). The purpose is to compare each record line by line to see if their have been any changes made. The record is based on an Account#. Over time these files will be considerably large. What is the best way to do compare records from each file. I'm thinking loading each file into an array and processing them that way.

View 7 Replies

CHM File In VS 2008 Versus VS 2010?

Jul 16, 2009

I had a .chm file I used in VB2008 and I'm having trouble getting it to work for VB2010. I use the code below to reference the file.

vb
Module HTMPHelpAPI Public Const HH_DISPLAY_TOPIC As Short = &H0 Public Const HH_DISPLAY_TOC As Short = &H1 Public Const HH_DISPLAY_INDEX As Short = &H2 Public Const HH_DISPLAY_SEARCH As Short = &H3 Public Const HH_HELP_CONTEXT As Short = &HF Declare Function HTMLHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" (ByVal hwnd As IntPtr, ByVal lpHelpFile As String, ByVal uCommand As Int32, ByVal dwData As Int32) As Int32End Module

I then call it from my menu using this:

vb
Private Sub HelpToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles HelpToolStripMenuItem1.Click HTMLHelp(IntPtr.Zero, "PE Files Help.chm", HH_DISPLAY_TOC, 0) 'Dim sHelpFile As String 'Dim sStartupPath As String 'sStartupPath = Application.StartupPath.ToString 'sHelpFile = Replace(sStartupPath, "in", "hlp") & "PE Files Help.chm" 'Me.hlpHtmlLocal.HelpNamespace = sHelpFile End Sub

I had found the commented out portion online and tried to get it to work, but nothing will bring up the file. Do I need to have it loaded into VB.Net somehow or point to it or does it need to be in a certain location?

View 1 Replies

VS 2010 Event Handler In VB Versus C#?

May 21, 2012

I've been fiddling with this for ages and can't get it right. If you have this in C#:

videoSource1.NewFrame +=new NewFrameEventHandler(videoSource1_NewFrame);
void videoSource1_NewFrame(object sender, NewFrameEventArgs eventArgs)
{
// stuff to do in here
}

How would write it in VB? My head is spinning with AddHandler and AddressOf and I can't seem to get it right.

View 10 Replies

VB 2010 - Array Versus Data Table?

Mar 22, 2011

I am interested in the pros and cons of data tables and arrays in VB 2010. I programmed decades ago in FORTRAN and used arrays extensively.However, I frequently see data tables in code snippets and don't know when they should be used in lieu of an array.

View 4 Replies

VS 2010 - Speed: WebClient Versus Socket

Apr 25, 2012

I make a lot of programs that require an internet connection to download things from the web.At the very beginning, I used WebClient, as I didn't know Socket & how it worked.But now, I use Socket all the time, altough it's more lines of code. It seems to work faster then WebClient.I am interested if this is really true & why WebClient is slower (so is HttpWebRequest) then just a Socket.I've setup 2 threads which starts on the click of a button (WebClient thread starts first), the Socket beats the WebClient by just some milliseconds, but still.Each way has it's advantages & disadvantages, e.g.: if you use Socket, you need to write the header yourself & parse the response header.My question is, which one do you prefer & why ?Do you know why WebClient & HttpWebRequest are slower then Socket, as I assume, WebClient & HttpWebRequest both use tcp to download the things.

View 2 Replies

VS 2010 Data Sources Versus SQL Commands

Apr 19, 2011

I prefer having total control for data access, populating recordsets (now datasets) precisely via a connection string and SQL select (or stored procedure call), etc.Now I wonder whether I really should be using the Data Sources option which just popped up on my radar? From the little I've seen so far, it seems to bind an entire table to a control, whereas most of the time I only need a small number of records from large tables.Before I spend a lot of time investigating, I hope a quick word from you might help me feel happier continuing as I am, or whether I need a kick up the backside towards a Better Way.

View 12 Replies

VS 2010 - Modules VERSUS Forms For Global Variables

Dec 19, 2010

I was a VB6 programmer. And back in the day global variables, functions and subroutines were put in a module. The program started in the module using a sub named Main(). Now in vb2010 it looks like using sub Main() is possible only for console apps, which is not what I want, I'm still trying to write a windows app but it looks like everything has to go at the top of the starting form?? How is this good coding practice? Shouldn't public vars and functions be in their own module?What is considered best practice?Are there any links that would walk me through the differences between vb6 and vb2010?

View 2 Replies

VS 2010 Application Showing Different Behavoir When Installed Versus Running?

Jul 4, 2011

I have a situation with an application of mine where I noticed I get a different result when the application is installed in comparison to it running in Visual Studio. If the application is installed a certain aberration pops up in this computer graphics application at a certain point in one of the screens but if I run the same group of settings or you could say the same "screen" running the application from Visual Studio I don't see the aberration ever happen. I tried deleting the bin and obj folders and then rebuilding before creating an installation and it doesn't change anything and whether I use InstallShield or create an installation using ClickOnce I still see the same issue. I have Enable application framework unchecked but found it makes no difference checked or unchecked

View 9 Replies

VS 2010 DLL - Debug Versus Release (hide Descriptive Names)?

Mar 5, 2012

Will setting the DLL to release hide descriptive names & class info?

View 4 Replies

VS 2010 HTTPListener Of Large Memory Stream Versus File I/o?

Sep 28, 2010

I have a user interface app that allows you to drag/drop in files - and it turns them into HttpListener request POST's to another EXECUTABLE that I have running - let's call it BACKEND1.BACKEND1 will be running on a SERVER when this gets ready for production use.Lots and lots of users running the UI - all dragging in files - all getting POST'ed to BACKEND1 - with the file included as a memory stream in the POST. BACKEND1 responds to the UI with a "sequential" file number assigned to the file centrally on the server.

On the SERVER is also running another EXECUTABLE - let's call it BACKEND2. It's job is to work with the DRAG'd in files.Both BACKEND1 and BACKEND2 sit on the same SERVER. At the moment I am writing the memory stream to DISK in BACKEND1 - and POSTing the FILENAME to BACKEND2 for it to work on.Would it be better to not write the file in BACKEND1 but instead include it in the POST to BACKEND2 - where it can be written to DISK?

Is having LARGE HTTP REQUEST's a burden when sent between two EXECUTABLES on the same machine?My primary goal is to have a really available BACKEND1 talking the the UI instances running out in the world. I'm concerned that doing the file i/o in BACKEND1 is "expensive" - and I don't care about the performance of BACKEND2 as much.

View 2 Replies

VS 2010 Comparing 2 Images - [BOOL]?

Jul 27, 2010

I have been searching many ways to compare 2 images and still I havent got anything usefull.

I was wondering how can I compare 2 images and either return TRUE or FALSE

is there like a DLL and I send 2 images and either return TRUE or FALSE?

View 18 Replies

VS 2010 Comparing Cells In Two Datatables?

May 2, 2011

I am wondering if there is a easy way of comparing data in two datatables available in following format:

datatable1

Quote:
ID Length Width Height Qty Rate
ID1 1.50 3.50 1.15 10 55
ID2 2.50 3.50 1.25 20 65
ID3 3.50 3.50 1.35 30 75

[Code]....

ID column of both the tables are unique ID's and can be used for comparing both the databtables.

I am wondering based on these ID's, both the datatables can be compared.

For example, if datatable 1 is used as reference table, data in ID2 and ID5 of datatable2 are different when compared in datatable 1

View 6 Replies

VS 2010 Comparing Data In 2 Columns?

Jun 29, 2011

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.

View 10 Replies

VS 2010 Comparing Negative Numbers

Jan 22, 2012

I have this

[Code]...

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.

View 4 Replies

VS 2010 Comparing Published Files?

Sep 15, 2011

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?

View 1 Replies

Calendar Control - Add Text To A Specific Day Of The Calendar?

Dec 30, 2011

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,

View 7 Replies

VS 2010 Make Month Calendar?

Jan 27, 2011

I have a simple code with a month calendar.

vb
Dim CurrentStart As Date
Dim CurrentEnd As Date

[code].....

View 12 Replies

VS 2010 Start A Calendar Program?

Sep 4, 2011

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.

View 1 Replies

VS 2010 Comparing Two Listboxes And Removing Identical Values?

Jun 19, 2011

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

View 4 Replies

VS 2010 - Month Calendar And MouseOver Event

Jun 15, 2011

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?

View 7 Replies

VS 2010 - Title Is Not Member Of Calendar.Appointment

Jun 9, 2010

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.

View 2 Replies

2010 - Disable Weekends And Future Calendar Dates?

Mar 14, 2011

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.

View 1 Replies

VS 2010 Form On Different Thread After Opening Outlook Calendar?

May 31, 2011

I have a simple form in VB.NET with one button which when clicked opens an Outlook Explorer to display an Outlook Calendar. When the user closes the Explorer, the form picks up the close event, garbage collects the Outlook objects and attempts to close itself.

However the Me.Close() does not work - if I pause the code on the Me.Close line and set a watch on the Me form object, lots of the form properties say "{"Cross-thread operation not valid: Control 'Form1' accessed from a thread other than the thread it was created on."}System.InvalidOperationException" If someone could help me out with this one I would be a very happy bunny...

[Code]....

View 3 Replies

VS 2010 Calendar Or Date Picker, Auto Select Next Pre-selected Day?

Apr 29, 2011

Writing a little program for my wife and thought it would be cool to have the calendar auto select the next day of her choice when she opens it. Example it's Monday and she opens the program to make notes about things for her girly get together every Thursday. Right now she opens it and has to select the next Thursday first to get the date.

What i thought would be cool is if the program picks the next Thursday for her, in the future the night may change to Tuesday so i don't mind hard coding the selection for now as it wont change all the time.Is there an easy calendar or date picker routine available for this or is it a roll up the sleeves, i searched and not finding anything.

View 2 Replies

VS 2010 Control To Make A Calendar Grid Like (Photo Inside)?

Jun 28, 2010

i'm working on a calendar and i'm stuck on how to make the grid (where the user put the events )i want to make my calendar look like this!

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved