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.
I have a program in which users are entering numbers into text boxes. I'm checking for proper data entry using a TRY-CATCH block. It works great and delivers an error message if the users enter anything non-numeric.
The problem is that now I need the users to enter negative values, but the TRY-CATCH is seeing the negative sign as non-numeric.
I have written a program that generates and prints 10 random integers from -10 to 10, my problem is that I am returning both negative and positive numbers, aligned right with a pad of 2, but the negative is on the right hand side of my number instead of the left. here is my code, all work but I need to align the numbers and have the correct notation of negative.
I'm using EPPlus 2.9.0.1 with Visual Basic.I have a DataTable with 35 Rows and 4 Columns and the code below:[code]When method 'LoadFromDataTable' is called, I get an ArgumentException (Negative row and Columns numbers are not allowed). I don't have negative numbers in row or column numbers, as far I know.
I am starting to feel completely dumb when it comes to VB.Net coding. I am using Visual Studio 2010 and am trying to compare the numbers in 2 listboxes. If an item from list A matches an item from list B, I want it to add that item to List C. Once it has added the item to List C, remove those searched items from list A & B. Continue until it runs out of numbers to check.
If you are wondering what I am trying to do, I want to make a Common Factor list. I already have the Factoring list done, but got stuck here.
So far, my code looks like
Private Sub CommonFactors(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Common.Click Dim BoolAdd As Boolean, i As Double, j As Double
I need to take user input, validate to ensure there's no negative numbers and display monthly fee and check fee in a Label.....with a calculate button_Click
I defined a database using SQL Server 2008 R2 Express, and connected to it using Visual Basic 2010 Express. For some reason though, when I use the database in the program, it wants to start off using a negative primary key.Is there any way to make the primary key only a positive number?
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.
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,
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?
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())
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.
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'm writing a report scheduler that is somewhat of a clone to the backupexec scheduler and the layout can be seen in post #10 here: [URL]..It works great and saves/edits/deletes records just fine, but now i need to compare those records one at a time in a windows service that i'm writing in order to trigger automated report creation and emailing - i already have the report and i already have the code for the emailing, i'm just looking for the most efficient way to loop through the table (that i've pulled in to a dataset) and compare its records with the current date and time - if true, the event fires.
[Code]...
1stSun, 2ndSun etc are bit fields, time is a datetime, and the remainder are varchar. My service checks the database every thirty seconds.The english version of what i'm trying to do is "Connect to the database, grab the entire table (it will always only have 5-6 entries max, so i felt 30 second sweeps was okay), and If today is the 1st Sunday of the month, and it is currently 11:00:00 a.m. (could be any day or time, this is just an example) - loop through the dataset to identify if any records match the time field or greater - if they do, fire the report
I have a specific image that I want my application to look for on a specific window. I've done something similar to this along time ago with VB6, but it was slow, and it was checking for specific points in the picture rather than the whole image itself (for speed reasons). I named this image "Image1.jpg" and I want to compare it to the window with the handle "001C08F2" and class "SunAwtCanvas"
I'm again got stuck in a simple problem, i'm learning it by myself. I didn't able to do it as i've tried many times. I'm making calculator. Please tell me what I'm doing wrong?
VB.Net Dim total, num As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = Label1.Text &
"Select * from Table WHERE ItemNum=2 OR ItemNum=4 OR ItemNum=6" I use the code above to select ItemNum w/ even number.. but the problem is how about 8 and above? The same with odd number?
I just got a textfile with a couple of numbers (1 number in one row), how would I sum these numbers? I thought it would be easy, but thing is it's turning out to be not so easy.
I am trying to write a console application that adds and undetermined amount of numbers together and then averages them and does some other calculations with them, but I cannot for the life of me figure out how to add many numbers together. I am doing this in a console application and using input boxes and message boxes to Receive and display the data. So the question is, How do I add many numbers together (an undetermined amount, maybe 5 numbers maybe 25 numbers) and then add them.
every time i press the Roll Dice button the turn1roll1, turn1roll2, or turn2roll1, turn2roll2(depending on turn variable) it shows system.random in ASCII Chart i used the label names so no confusion.[code]
Only now, I'm facing this kind of problem, i have a application that until now worked with two different cultures ENG and PT, i always knew this, and i manage to solve all problems related to parsing the numbers, but now i have to change the code, and "protect" the code to handle with others cultures. So i need tips/best way to handle different cultures, and different database culture settings.I think that i shouldn't limit the user, by setting the decimal, the grouping digit, the date time format, etc. . The application should accept the numbers in the user current culture. But this path forces me to putting everywhere the parse/tryparse method.
I have code to save records to my mysql database.But first I want to read what is the last number of record and add 1000 on that? What is the proper way to query that first. I want to make the result at unique ID of my clients. Here is my chunks of codes.
Private Sub addClient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As MySqlConnection conn = New MySqlConnection With conn