Basically i have 12-16 text boxes, with certain values in them.
i think i need a nested loop one to take first box and go through the rest to compare them and then a second loop withint that to do the actual comparison.
I have two text files which contains are like this[code]..
When the original files find the same values in drill file than it must overwrite the original file the line from drill file. Let say original file contain T230 than it must serch for same value in drill file if it find than it must overwrite the original file line with drill file line. The content of drill file is not fix. It will allways be update according to need.
is that posible to connect two text file?
Is there a way to compare values in text boxes?
For example, if I have two text boxes, I want to compare the numbers in each to see which is higher and then commit actions if one if higher.
Again a little (for me) tricky thing:Supose you have a ComboBox control with predefined values - to keep it simple, let's add some colors:
- Blue
- Green
- Red
- Yellow
Now you have a TextBox control as well. If you type into the TextBox BLUE (non-key sensitive) I would like to make it recognize that this value already exists. It does not have to do anything else except for notifying me about a match.I do think that the TextBox1.KeyPress or TextBox1.TextChanged event is what I need but I have no idea how to compare to the ComboBox1 items. I've tried to create an Array of my ComboBox1.Items but didn't get much more than errors. Can anybody help? I am sure it is quite simple however, I can't get my mind set to go in the right direction
I have a two different tables, Table 1 and table 2.
Table 1
-----------
Resource
Start Date
End date
[Code]....
Here I have to match the total hours of each table according to the resource,
then have to find the mismatched data and find difference with that values of mismatched data.
I have two textbox in my application.
Textbox1.Text="19-Jan-2010"
Textbox2.Text="Jan 2010"
May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?
Comparing value from the same table for my final project.[code]...
View 1 RepliesI'm trying to figure out a way to compare two "salted-hash" strings. How can I do this? I know that the salt is a random generated value that's appended to the plain text, then we just compute the hash of that new string.So how can I compare these two values? O_O (The new hash that the user hash written in a textbox and the hash stored in a database)
View 9 Replieshow to compare values of two different strings.
View 2 RepliesI wanted to ask how should i read the text file find a value and place it in textbox then find for the same value from other part but at the same text file.
I give the example of my text file:This is one part.
[Code]...
How can i compare two string values in vb.net? i've tried compare, equals functions but it's not giving me the correct result. what i'm trying to compare is as follows. also let me know if the code is correct. i'm new to vb.net
[code]...
I need comparing value from the same table for my final project.
Example :
Table 1 :
SubjectCodeClasses
Sub Aclass 1
Sub Aclass 2
Sub Aclass 3
Sub Bclass 2
Sub Bclass 3
Sub Bclass 4
Sub Bclass 5
Sub Cclass 6
Sub Cclass 7
Sub Cclass 8
...
My task is, I need to compare the classes in the subject. Sub A with class 1, class 2, class 3 have to compare with Sub B and Sub C. if classes from Sub A exist in Sub B then the output is 0, if not the output is 1. then Sub A again will compare with Sub C and the rest. After Sub A compare its value with other subject. Sub B will start comparing with all the subject and so on.
Below is the concept.
Sub ASub BSub C
Sub A001
Sub B000
Sub C100
I really don't know to do the loop..
I have an array with 35 "cells" each with a value. ( CheckValue(34) ) Now i want to compare all values with eachother to find out wich 7 of they are the biggest. Is there any easy way to to that?
View 1 RepliesI have a checkedlistbox full of values, and then a list of values that's a subset of of those in the checkedlistbox. I need to check all the items that are on the list--preferably without repeating through both of them.
View 1 RepliesI have a tblVersion that contains the versions of my application:
VersionID Version
VersionID is a bigint primary key, version is a ntext column that holds the current version... I want to be able to pick the row that has the highest version number, but version could be in this format:
MyApplication 1.0.1
If I try to convert that to a int32 it will throw an exception obviously. I would like to know if some of you have a idea how to solve this issue. I could of course make sure the column will only contain numeric values but this gives a little more flexibility.
This is a 2 part question about list comparisons. I see lots of threads on comparing two separate lists, but I need to know how to compare values in a single list.
Part 1:I have a bunch of string values that I am first splitting and then adding to two separate lists. The strings look something like this... 3-ABC, 6-DEC, 11-RFG, 6-ABC, 12-ABC, etc... So, with the code below(vb) I am splitting the numerical portion of the string and putting it into myLeadQtys(saved for later). I then take the rest of the string and put it in another list (myLeadVals):
Dim myLeadVals As New List(Of String)
Dim myLeadQtys As New List(Of String)
Dim strMtextValue As String
[code]....
I am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
I'm just trying to implement a 'no duplicates' catch on my insert customer form, but it just slips through my if statement to the else everytime. This is the source. Also I tried a .Equals with the same results :(
Protected Sub srcAllClients_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles srcAllClients.Inserting
[Code].....
I have a program that has to store a pre-made array that contains strings (moviename, moviegenre).
I setup all the items in the array already, example:
moviearray(0,0) = "Green Lantern"
moviearray(0,1) = "Action"
For this example, if the user selected "Green Lantern" from my listbox, then the label needs to display "Action". So yeah, it's a 2-column array: first column = movie name, 2nd column = movie genre. Now, I have a listbox containing all of the movie names (not entered by the array, but entered through the Item property of the listbox). When a selection is made in the listbox and a button is clicked, I need to have the genre of the movie output to a label. That is where I am stuck, I just can't figure out to compare what's in the list box with the first column of the array to output the 2nd column to the label.
I have a question about comparing values inside of a List. I have a single list of strings. Inside the list are multiple values. The values are arranged so they can be dumped into a spreadsheet.
Example:
Private ListOfStrings As New List(Of String)
ValueA(0), ValueB(1), ValueC(2) 'These three values are the same as the three values in the 4th "row" below
ValueD(3), ValueE(4), ValueF(5)
ValueG(6), ValueH(7), ValueI(8)
ValueA(9), ValueB(10), ValueC(11) 'These three values are the same as the three values in the 1st "row" above. Since this is a duplicate, I need to add a "count" of value 2 and then delete the values of this row from the List. Etc...
Each line above represents a "row" in a spreadsheet. All three values in each "row" have the potential to be the same. So, I need a way to A) Compare and count all of the common "rows" (using only the first value from each row) and B) If common "rows" occur, I need to delete all but one row from the List. ListOfStrings.Remove ?
My application is in VS2008 coded in vb.net.I have a table with three columns FromDate,Todate and Schedule.FromDate and ToDate will have date values whereas Schedule will have a any of these values(weekly,Monthly,Yearly) In my Form i have given some provision to the user to check the records.
My requirement is The currentdate that is Today's date should be compared with the values of Fromdate and ToDate.First it should be check whether Schedule value is Weekly or Monthly or Yearly.If it is weekly than it should check the record in between fromDate to ToDate with a increment of one week.That means it should first check the first value of fromDate than add 7 days to the value and then again check from fromDate and this should continue till it reaches Todate.
[Code]...
I have the following example datatable:[code]And now the user should be able to compare multiple periods. In this example the user chose two periods: 1.1.2010 - 31.12.2010 and 1.1.2011 - 31.12.2011. The result of the example should be:[code]
View 2 RepliesMy application is in VS2008 coded in vb.net.I have a table with three columns.FromDate,Todate and Schedule.FromDate and ToDate will have date values whereas Schedule will have a any of these values(weekly,Monthly,Yearly)
In my Form i have given some provision to the user to check the records.My requirement is The currentdate that is Today's date should be compared with the values of Fromdate and ToDate.First it should be check whether Schedule value is Weekly or Monthly or Yearly.If it is weekly than it should check the record in between fromDate to ToDate with a increment of one week.That means it should first check the first value of fromDate than add 7 days to the value and then again check from fromDate and this should continue till it reaches Todate.
[Code]...
I have a query I'm using to identify a group of contracts that have expired. The query has a ContractID, Status, Start Date and End Date. For each contract, I need to go to a directory and search for a file to import. That part works just fine, but how can I put a qualifier in to check for contracts that have the same start and end date? Do I need to create a multi-dimensional array for this or can I use the query I have? The part in bold text is where I need to identify identical start/end dates. Comments identify pieces to be developed and message boxes to help me confirm what's happening as I run the code:
Private Sub cmdRefreshList_Click()
DoCmd.SetWarnings False
'Create an array based on the true-up contract IDs.
Dim db As Database, TUrst, PYMTrst As Recordset
Dim TUContracts() As Variant
Dim TUContractID As Variant
[code]....
I have list of about 100 names in first columns. and i have list of same people's names in second columns, but both are not same.
[Code]...
If you notice carefully, all five people in column A have their names in column B as well.I need somehow both column showing same names for same people ignoring extra names like Jones,
I have to compare an item value in two tables. these two tables are on different database(same server).
I have succesfully generated sql query to return both table values.
the query runs in sql server without any problem and gives the results.
The same query i used in vb.net doesnt gives any result ...
It is resulting with no rows.
Does the connection to multiple databases wont work from vb.net.
The following classes are used to get the result ...
SqlConnection
SqlCommand
SqlDataAdapter
SqlDataAdapter is showing with no records returned. The same query returns the results in sql server query window...
I have many txt files, and i have to select any txt file to search and compare match fields with file: CompareText.txt. My text file format:
20090227#2#B010110100#3787.562904#
20090227#2#B010110200#430556.987989#
20090227#2#B010110213#2146515.91#
[code].....
It's been a long time and I'm very rusty on my VB.
I did something like this years ago and now I'm stumped.
My application flows like this-
-From my form, I have a text box.
-I scan a serial number into the text box
-The application compares the scanned serial number against a base-line serial number
-Depending on if the serial number is greater, less or equal, a windows messege box is displayed.
I can get the messeage box to work just fine, it's just the line of code that does all the comparision I'm struggling with.
- Serial number to baseline is something like SY1420000134 (all the same charater length and always starts with a SY)
I've been searching for about two hours now and can't find any thread to jog my memory.
Im trying to get a text box the compare its self to more than 1 other ive tried to do it like this :
If TextBox7.Text = TextBox1.Text Or TextBox2.Text Or TextBox3.Text Or TextBox4 Or TextBox5.Text Or TextBox6.Text Then
Well i want to compare 2 strings (version one and version two) and get the differences in a format that i can convert to html on my own, like you can view how a post was edited here on stack*overflow* or like svn tracks differences between revisions....
It must be full managed code library.
Like this JavaScript but i need to do it on the server-side..