my app reads 40000 lines of data fom a csv file into a two dimentional array of 30 items and i need to sort it by one of the items that is a date. is there a way to do this in Vb.
something like this
array1(40000,1) = name
array1(40000,2) = city
.
.
array1(40000,30) =date
I was looking for a function I need in internet but I didn't find it... I need to sort a multidimensional array(matrix).. for example
Original matrix
1,b,3
2,c,5
3,a,1
I need a function, lets call it magic() xD with 2 arguments, the matrix and which col to sort first...so..the result of magic(originalmatrix,1) could be..
3,a,1
1,b,3
2,c,5
How can I make it ?
is it possible to sort Multi-dimensional Arrays? If the answer is yes could someone help me giving some hints on how to start?
View 6 RepliesIve got a jagged multi dimensional array, how to work out the length of a single row of the array so;
My array is ;
CODE:
And i wish how to find the length of this;
CODE:
My array is declared by
Dim vArray As Object
vArray = oXLSheet.Range("B2:C201").Value
It looks like[code].....
Both dimensions are strings. Obviously the values of 1,1 and 1,2 must stay together.
How do I create a multi dimensional array in visual basic. For example I have a soccer team with players. Each player has an id, first name, last name, address, phone number. How would I represent this using a multi dimensional array?
View 1 RepliesI need some advice to accomplish this, i have a datagridview with this data:
Column1 Column2
item1 3
item2 1
item1 2
item1 5
item2 3
item3 1
item1 3
I need an array with distinct values of column1 and the sum of the values in the second dimension of the array: ar(item1,13), ar(item2,4),ar(item3,1).
I don't know how many items i will have, so i don't know the correct dimension of the array...
Is it possable to remove a row from a multi-dimensional array?
View 5 RepliesI'm writing an application in VB.NET and face the following issue. I'm trying to create an interface that will allow the user to select their availability given a range of times and the days of the week. I want to create checkbox controls in a tabular form with two indices that I can use to refer to a certain time range and a day of the week.[code]I followed the article found here which creates and exposes a control array,however it is not multi-dimensional. Does anyone know of a similar way to dynamically generate controls and store them in a multi-dimensional array in VB.NET?
View 2 RepliesIn my football sim I am trying to save all the info from a game. There are two defined dimensions to this array. The first is the number of weeks(17 always) and then the number of games per week (Number of teams /2). The plays themselves are unknown in quantity so I decided to use List of to store them. With this type of multi-dimensional array that is also a List of I am having trouble with the Get and Set properties. I have a member variable declared as:
[Code]...
I'm trying to implement a bubble sort on an 2 dimensional array. However the results after the bubble sort have not infact been sorted at all! I am trying to sort by the 7th item in the 2nd dimension. The other items are not important as they just contain other data but I would like to have the data kept together instead of creating another array for the bubble sort.
Public Function bubblesort()
Dim array(999, 7) As String
array = Home.userinfo 'Load the array from the Original form
[code]....
What would be the best way to load and save a multi-dimensional array (of bytes). I've looked through streamreader tutorials but it always seems to instructions on how to save strings. I also know there's a very easy way to save a one-dimensional array, but it doesn't work on multi-dimensional ones. What should I be reading up on?
View 5 RepliesI am attempting something along the line of below mentioned code. Though it works in single dimension array. How to make it work with 2-d array?
Dim arrayord(,) As String = {ds.Tables(0).Rows(3).ItemArray, ds.Tables(0).Rows(23).ItemArray}
But it throws the following error.Error 8 Value of type '1-dimensional array of 1-dimensional array of Object' cannot be converted to '2-dimensional array of String' because '1-dimensional array of Object' is not derived from 'String'.
I am having issues assinging values to a multi-dimensional array.
I am trying to build a 2 col, unlimited row array and populate with data from a data reader.
Dim tblArry(,) As String = {}
If reader.HasRows Then
While reader.Read()
[Code].....
When I use a Jagged Array I can get this to work. The Reader portion is workig just fine, but the coding is just not clean for this problem.
I think I need a two dimensional byte array I currently have something like this:
Dim MbyteData(196608) As Byte
' Open the file that is to be loaded into a byte array
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(sFilePath)
[code]....
I now need to load several files at once (say four) so I need four arrays of 196608 bytes and I want to reference them by a number - 0 to 3, assuming the array is zero based. If I use Dim MbyteData(196608, 3) as byte or Dim MbyteData(3, 196608) as byte the syntax seems to be correct but I hit an error ("Number of indices is less than the number of dimensions of the indexed array") when I try to add the extra dimension to the stream read with something like oFileStream.Read(MbyteData(index), 0, MiByteCount).
I have a multi-dimensional array storeHand(20,6) which stores 6 ints. The int at point 0 in each array represents a rank. So the array ends up looking like this:
(7, 0, 0, 3, 5, 7)
(6, 2, 3, 0, 6, 5)
(5, 0, 0, 0, 13, 4)
(8, 0, 0, 0, 0, 3)
(2, 0, 0, 0, 0, 1)
I want to re-order the array so that the higher the integer value at position 0 is, the higher it's position will be in the sortedHand(20,6) array. So as above, I'd want sortedHand(20, 6) to look like this at the end:
[Code]...
I am trying to turn data in a text file seperated by spaces into a 2D array.
It is for a math game. The data is statistics based on the performance of the user. One line looks like this "John Doe 0 0 1 3 0 6 0 22"
I need to put the line into an array and then be able to search by name to display the results. I keep getting extra spaces in the input of the array so the data isnt where it should be. It seems that the first entry works correctly, but appended lines do not enter correctly.
Sub ResultsToFile()
Dim FILE_NAME As String = "C:\Student_Results.txt"
Dim RecordString As String = NameForm.PlayerFirstName & " " &
[Code].....
I'm currently trying to make a vocabulary/flash-card program so I want an array that can store multiple values per item. That way I can shuffle the "cards" (array items) while keeping the word, definition, and part of speech on the same "card". So if I where to access the array I would want to be able to do something like this:
Dim vocabList as VocabArray
vocabList(0).Word = "blah"
vocabList(0).Definition = "blah"
vocabList(1).Definition = "blah"
And then if I where to re-arrange them the properties would remain together but just in a different spot of the array.I can get really close to this using an Item Structure and declaring the variable name with () but the problem is I have to include a number with () and I need to be able to add infinite values to the array, I can't have a set number.Also I would prefer to make it like an ArrayList as it has .Add, .RemoveAt, .Insert etc. In normal Arrays there's no easy way to add, you have to resize and stuff.
Anyways here's close to what I want, but I can't have a set amount and I'd prefer the ArrayList structure so I can just have like Array.Add and then have a Item added onto the end with 3 variables on it. The only thing is that with .Add you usually put something in paranthesis after it to denote the value to add, but if I have 3 possible values then I would have to have parameters for it or something, like .Add(Word, Definition).
Structure SpecialArrayList
Public Property1 as String
Public Property2 as String
[code]....
I was planning on using very similar code to the following to export to excel quickly[url]...
However, the data that I'm exporting is rather large and I find it unnecessary to grab a dataset from the sproc, convert it to a multidimensional array of objects and then export to Excel. There are two main reasons this is unnecessary. 1) It takes time to transfer that data from the dataset to the array. 2) There are then two instances of the data, one in the dataset and one in the array. Therefore, I would rather directly insert the sproc results into the array of objects and bypass the dataset altogether. I can't do this unless I know how many rows I'm getting back from the sproc in order to declare the array's size beforehand. [code]...
I need help in defining an Multi-dimensional array which will update based on the value passed by the user [code] I nesd to pass the value to an array of where I want to add Project, for example If i want to add (Project) under Customer2 table the array gets updated and adds an entry in Customer 2 table which will look like [code]
View 3 RepliesI have this code to set array values and store them in a variable,
Dim productName As String()
Dim productPrice As String()
Dim productCategory As String()
[CODE]...
How do you get the variable values to output like this?
<input type="text" value="Chang Beverages $19.00" id="Chang" /><br />
<input type="text" value="Ipoh Coffee Beverages $46.00" id="Ipoh Coffee" /><br />
<input type="text" value="Gula Malacca Condiments $19.45" id="Gula Malacca" /><br />
I have one dimensional array that is being returned by an NVP function, the problem is that I want to count the number of ID's returned by the array to set the limit. For instance the array comes in this format ID0, ID1, ID3.... IDn, Name0, Name1, ...., Namen, Surname0, surname1, ...., surnamen etc... I want to know the n+1 number of ID's so that I can set it as the upper limit of my array to be able to loop through without setting an arbitrary number.
View 2 RepliesI have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
I have a string containing many lines. Each line has many values separated by commas. Basically it's in CSV format. The number of lines is variable but the number of columns is always 7.
I can get each line into a one dimensional array using Split(Var, Chr(10)).
I'd like to make it a two dimensional array where the second dimension contains each comma separated value.
I've got
Dim VarArray1() As String = Split(VarText, Chr(10))
Dim VaryArray2(0 To VarArray1.Length - 1, 0 To 6) As String
Is there a quick way to get the contents of VarArray1 into VarArray2. I know I can do the following.
For Counter = 0 to VarArray1.Length - 1
Dim line as string = VarArray1(Counter)
Dim Values() as string = Split(line, ",")
For Counter2 = 0 to 6
VarArray2(Counter,Counter2) = Values(Counter2)
Next Counter2
Next Counter
But is there a quicker way to do it that doesn't require passing through each element of VarArray1 and then passing through each element of Values.
The eventual goal in all of this will be to find the highest value in the 3rd column (the arrays are strings at this point because not all columns are numeric). To do that once I get the values into VarArray2 I suspect I have to pass through each element VarArray2, i.e. VarArray2(Counter,2). Unless I can copy the whole third column into a SortedList?
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
I have 9 1-dimensional arrays of bytes and 1 of them is empty, I want to make the empty one equal to the others put together like you would a string:
Dim bla As String = "bla" & "bla" & "bla"
'now bla = "blablabla"
but instead:
[Code]......
How can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I have a string, which can easily be splitted by seperators into an array.The output has to be splitted again an move into a multi-dimensional array (2nd index)[code]
View 2 Repliesok so im having issues with this
Select Case a(b, 3)
Case "d"
c = 0
[Code]....
OK so a(b, 3) has either the letter d,e or f in it but when I try and read the multi dimensional array I don't think it picks anything up
I have a very simple 2D array, it holds a list of song titles, their genre, and their runtime. frmMain loads the array from a text file and allows me to manipulate it and boil it down to a desired (implicitly sized) playlist. i want to THEN pass that playlist array to a second form, frmPlaylist The problem i'm running into....When frmPLaylist calls the Property from frmMain I receive an error that VB cannot convert the string value to a two dimensional array. Simplified...frmPlaylist is all locked and ready to receive a 2D array, but frmMain seems to only be sending a single string variable. on frmMain
Public ReadOnly Property PlaylistOut() As String
Get
Return mstrTimedPlaylist(,)
[code].....
