I am a bit confused when comparing StartDate and EndDate in my asp.net app.
EndDate: 10/1/2011
StartDate: 9/30/2011
The if statement below returns true, based on the date values above.
If strEndDate < strStartDate Then
I would think the If statement shoudl return false. The concept is supposed to be that if EndDate is earlier than StartDate, display an error message.
how to compare startdate and enddate? [code]Startdate cannot bigger then endstart to protect this condition.
View 5 RepliesI am working VB.NET 08.I am having error from the below code in StartDate and EndDate:
Private Sub Query2()
QStr2 = ""
If cmbEventname.Text <> "" Then QStr2 = QStr2 & "Eventname like '" & cmbEventname.Text & "%' AND "
If cmbType.Text <> "" Then QStr2 = QStr2 & "Type like '" & cmbType.Text & "%' AND "
If cmbVenue.Text <> "" Then QStr2 = QStr2 & "Venue like '" & cmbVenue.Text & "%' AND "
If dtpStartdate.Text <> "" Then QStr2 = QStr2 & "Startdate like '" & dtpStartdate.Text & "%' AND "
[Code]...
i am trying to search between two dates startdate and end date there two problems problem given below
[Code]...
I want to do 2 things with date & time calculation : First : I have a LastSave (dateTime Format). I have two controls (NumericUpDown / Format Decimal), one for Hours, the other for Minutes.I want to start another save at a specific time this day at : Today's date + Hours + Minutes.What i've done isn't work, cause i can't convert to DateTime my setting
DateDernireSauvegarde, which has a STRING FORMAT.
Private Sub TimerSauvegarde_Tick(sender As System.Object, _
e As System.EventArgs) Handles TimerSauvegarde.Tick
[code].....
I have a variable for startdate as shown below.
Dim startDate as Datetime
startDate = Convert.ToDateTime(datepicker1.text).ToString("dd-MMM-yyyy")
In the immediate window if I try Convert.toDate(datepicker1.text).toString("dd-MMM-yyyy")it is showing date as 29-Sep-2009 but the value of startDate is 09/29/2009 I really don't understand why the value is not set in startDate variable as 29-Sep-2009
Is there in the deep of the Framework 3.0 Namespaces a function to get the EndDate for weekly Appointments?
View 1 RepliesBasically what I need to do is to insert into table Reservation a vehicleID, startDate and endDate.
I can do that fine but I'd like to validate it so that it cannot be inserted for that vehicleID if the current date is <= endDate as currently I can just keep adding to the Reservation table on the same vehicleID
This is just the simple insert SQL statement.
strInsert = String.Format("Insert into Reservation (VehicleID, startDate, enddate) VALUES ('{0}','{1}','{2}')", vID, now, now5)
From part of the code below where it say`s "Dim
startDate As DateTime =
New DateTime(2010, 4, 9)"
How can I insert a DateTimePicker, So I can choose a date instead of inserting date (2010, 4, 9)I have done a lot of seaching on this problem with no result.Basicaly I want to use a dateTimePicker instead of a fixed date on my startDate (fisrt date of year).
Private
Sub Timer4_Tick(ByVal sender
As System.Object, ByVal e
As System.EventArgs) Handles Timer4.Tick[code].....
I am developing c#.net solution where i have to calculate Start Date based on provided End date and Duration (back days) without weekends.
i.e. End Date: 05/5/2011
Back days: 5
Start Date = (05/5/2011) - 5 days (Excludes weekends)
Start Date = 29/04/2011
I have the code below on a timer( "b" is a bitmap )
If
Not (Clipboard.GetImage
Is
Nothing)
[Code]....
The problem is that it raises the event even if the picture didn't change.
comparing the 2 images without actually comparing them pixel by pixel (too slow to do the job)?
In a partial class, I declare a integer. Then, depending upon if a criteria is met, I set it's value to either 1 or 0. Then, I try and compare the set value, but instead of it being equal to 1 or 0, the code behind that I've stepped thru shows it ends up equaling &H0 or &H1. What does that mean? Why does it show a value of &H0 in the code behind when I debug instead of either a 0 or a 1???
View 2 RepliesFirst my prog scan a specific path "C:music" which contain Mp3. Then it takes the MD5# of all mp3 and put it in a listbox1. Also on the formload it does open a ".txt" which also contain MD5# that goes into listbox2.Now this is what i am looking to have :When i click my button it compare each line of my listbox1 to listbox2. If , for exemple , the first line of listbox1 is already in the listbox2 then it delete the first line of listbox1 (listbox1.items.removeat(0)). And Do until listbox1.items.count = "0".
View 2 RepliesI am trying to carry out a synchronisation of two databases: one on the server and the other on a local machine. So that even when they are not connected on the network, the local database can carry on accepting data but when the network is back on, the local database can update the server and the server can also update the local machine with data it accepted during the time when the network was off. by first comparing two tables in two databases and then if they are any differences the updating begins and i've since been stuck.
Private Sub btnCompareTables_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompareTables.Click
'dont know which arguments to put when calling this function
'How do i tell the computer which databases to compare
Comparing()
[code]....
I want to track changes of a document which sits in a DB table like :
document starts
document continues 1
document continues 2
document continues ...
document ends
(Each line is a record but if needed I can combine them all to one record)I have the document before changes in one table and the document after the change in another table.My problem is that if I just compare them by ID then I'll get many more changes than actually occured. Ex: If a line (/record) was added between record 2 and record 3, instead of tracking 1 change I will see that all the records from 3 and on have changed (because they will be pushed off by one record). Can be also something which knows to compare documents and I'll take the information out to document for comparison.
Let me provide a little detail to explain what I'm trying to accomplish before I get into the nuts and bolts of the question. I've got two data sources - one is a SQL Server containing part numbers, descriptions, etc. The other is a CAD system that does not have a database in a traditional sense. What I'm trying to do is read out the bill of materials from the SQL Server and compare it to the CAD assembly drawing to ensure that the CAD system contains the same information as the SQL Server.
Getting the data from the SQL Server is fairly straight forward. I query the database and populate a datagrid. Done. Quick. Easy.Getting the data from the CAD system is a little more involved. I have to load the assembly drawing to get a listing of all the component parts and then load those individual drawings to pull the "Part Number" property from the drawing. This is a somewhat time consuming and slow process (unfortunately) since each of the files must actually be accessed. I load those properties into an array (I guess a list might be more efficient).
So now I have a datagrid and array with part numbers. I need to compare them and colorize the grid accordingly. The grid should remain transparent if the part exists in both, color the row yellow if it only exists in the grid, and add a row colored red if only in the array.
As best I can tell, this means looping through the array on each line of the grid. The thought process is this:Default the grid to yellow rows.Loop through the grid and loop through the array to compare. If a match is found, make the row transparent and delete the element from the array.After step 2 is completed, the array should only contain elements that are not found in the grid. Resize the array to remove the empty elements.Add the elements of the array to the grid and color those new rows red.The problems with this logic is that it seems expensive from a performance standpoint. Surely there is a better method? Also, if I modify the grid in some manner (like a resort) I have to go through the process again.
i have 4 listbox and i named it
1. listbox40
2. listbox20
3. listbox5
[code]....
I am wanting to be able to check to see if two images appear to be the same, within a certain threshold.These two images are the same to the eye, but one has slightly different colors. I have tried the following example:
[URL]
Unfortunately, it only seems to detect when the images are identical. How can I determine if the images are the same within a certain threshold, with VB.NET?
I'm working on a Website in Web Developer 2010 where the content of a text box is checked against a list of values to find a match. There must be an exact match for the user to be allowed to proceed to the next step of the wizard.
Is there a shorter method to do this using the VB 'If' statement, other than specifying each condition individually?
I've tried something similar to the following, but for the amount of values it would be more practical if there was a shorter method.
If TextBox1.Text = "User1" Then
Label1.Text = "Ok, That username is valid. Click NEXT to continue"
LinkButton1.Enabled = True
[Code]....
I am a c#/asp.net developer and I am having to work on a VB/asp.net. I have two variables
Dim originalDate as DateTime?
Dim newDate as DateTime?
Both nullable datetimes, originalDate is a nullable date I am getting from the database and newDate time is set in code, I need to compare them, they can either both have dates, neither have dates or one have and one not.
I have a bit of code as follows:
if origEndDate = origEndDate then
When both origEndDate and origEndDate are "nothing" this statement is false (well when I run it in the watch window it comes back as nothing)!I don't understand why this is the case because I was under the impression doing an "=" compares the two values and as they are the same surely it should be true? What syntax should I be using as in C# I can do the above as so:
if (origEndDate == origEndDate) { }
and it will come back as true.
I'm creating <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-
[code].....
Here's my test code:
Dim testSingle As Single = 7.2
Dim testSingleF As Single = 7.2F
Dim testDouble As Double = 7.2
[code].....
how can i compare both datagridview by using ID?
example 1 : ID 4016.. the data from client looks edited on filename "New Divide(beta)".. so, that ID will put into listbox..
example 2: ID 4039.. the data from client different from server on Notecharter "Y..JZ".. so, that ID will put into listbox..
so, how can i compare all data in row for each column from server datagridview? If the data in row are same with server, it will be ignore..
I'm building a tool to display xml within a DataGridView and then to compare the rows of data.
I have read the xml correctly and displayed it within the DGV and have sorted the DGV by 3 of the columns.
I'm stuck with comparing the rows as i need to check several things:
[Code]...
I want to write an alarm clock application that should display a certain message at a time set by the user.How to compare system date and time with the time set by users in a text box?
View 4 RepliesI am fetching DataTime value of a SQL Database, LockDate. Dim diffDate As TimeSpan diffDate = DateTime.Now - LockDate minutes = Convert.ToInt32(diffDate.Minutes) hours = Convert.ToInt32(diffDate.Hours) Minutes value is showing incorrect values.
View 1 RepliesI have a method that I want to check to make sure that both integers entered are both positive:
Public Function BothPositive(ByVal num1 As Integer, ByVal num2 As Integer) As Boolean
If (num1 And num2) > 0 Then
Return True
Else
Return False
End If
End Function
Now if I were to enter some numbers in
BothPositive(1,1) = True
BothPositive(1,2) = False
BothPositive(-10, 10) = True
Why is this? What is going on with the order of operations in the comparison statement or what is the "And" trying to compare? I don't see why this wouldn't work.
I'm trying to compare a item i have to enter in a combo box with an item already in the box (duplicating items). I've use the contains function but i need something that is case sensitive. Here is what i have so far
[Code]...
I have five listboxes that are populated from five different datasources basically I have connected to an MS Access database and I am running SQL queries effectively so the five listboxes are populated via datatables for example dtInterests, dtHobbies, dtMovies, DtTV and dtMusic my question is how would I compare the values that are being stored in each listbox I want the application to check each of the five listboxes and if the value is the same (in my case the valuemember is the customer id) then store the result somewhere (in a textbox)
View 5 Repliesi am trying to compare user input number to with strings. i want the users to only input numeric values in a text box. but if they input a string i want an error message to go inform then to input numbers. this is the code i have:[code]
View 8 Replies