I 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.
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.
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
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
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 am a total beginner to Visual Basic and have a project to conduct a survey for my company. The Answers of the users need to be populated to the database. So far, all I've managed to do is to define a string which will have the answer to be updated into the access table. How am I supposed to pass the value?
i am working in windows appl vb.net 08. And i am working in Access DataBase.I have one Table Called "Person" . In this "Person" Table one Column Name Called "OtherName". In this Column binded in one of the Combobox in a Form.But the Problem is "OtherName" Column having the Null Values.Before i bind this Column to Combobox i want to convert this NULL Values to String. Why i need the values in STRING means , In my code i using this Combobox as a filter in SQL Query.If i didn`t change the Null Value to STRING , The Combobox SelectedText or SelectedValue is Showing Nothing. So i am not able to get the Record.
Whn i write a Sql Query to Combobox and apply filter in WHERE statement like Combobox.Selectedtext or Combobox.SelectedValue In "Selected Change Committed Event" then i should get the record in the Output right but unfortunatly i am not getting the Record. The Record Count in DebugPrint showing 0.
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'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)
I 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.
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?
How to insert and retrive multiple asp.net checkboxes values to MSSQl database as comma seperaed string 1,2,3,4,5 using vb.net ? and retrieve the inserted checkbox chekched in disabled form ..using vb.net url...I want this type of whole layout in vb.net means if user registered selected seats then then next the same page load for todays date the selected seats will be disabled
I 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.
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.
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
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 ?
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
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.
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]
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.
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
