VS 2010 Read CSV File To Multidimensional Array
Feb 1, 2012
I'm working on a new application for one of my Managing Editors at my company. We are wanting to build an application that only has 4 combo boxes for user options and then according to the options that the user selects, the application will spit out 3 random lines of text that can be copy and pasted into another application that we use.We are in the process of creating a rather large (1000's of lines) CSV file that we are going to use as a repository for the text. Let's call the data file SRG9000Data.csv..I'm almost 100% certain that I'm going to need to read in the entire datafile as an multidimensional array because we are setting up the CSV file as follows:[code]For each of THOSE categories, I'm looking at having 8 possible items for <Sports>, and 3 items for <PlayType>, <GameImpact>, and <Scoring>. <Text> is being use as a possible Text Phrase that the system can select from randomly provided that the other area's of the array are met.The CSV file will have 1000's of lines. Of those, the system will "filter" though all of them so that ONLY the ones that meet the selected criteria can be used, then choose 3 of them randomly and use that as output.
Extra information: I am currently establishing that the CSV file being used is setup as 0-7 for <Sports> (0 = Baseball, 1 = Basketball, etc..), 0-2 for <PlayType> (0 = Defensive, 1 = Offensive, 2 = Other), 0-2 for <GameImpact> (Negative, Neutral, Positive), and 0-2 for <Scoring> (0 = Non-Scoring, 1 = Other, 2 = Scoring); <Text> is a String.I am clueless when it comes to setting up an array like this; It's been many many MANY a year since I worked with array's in QB and I feel I may need more than a refresher course.Now, if I'm understanding correctly from some of the forum lurking i've been doing, multidimensional arrays CANNOT be of mixed type, correct? If this is the case, the how can I read the entire CSV file into an "array" (if you will) so that it contains Integers AND a String? [code]
View 6 Replies
ADVERTISEMENT
May 15, 2012
First time I've had occasion to do this, but how would you represent the data in a SQL database table in a multidimensional array? I've heard tell of multidimensional arraylists but have no idea how to use them.
Here's what I have -
The table is 15 columns across and a varied amount of rows depending on the query.
rawData is an arraylist. finalData is an array.
Dim myReader As SqlDataReader = sqlcom.ExecuteReader
While myReader.Read()
[Code].....
Obviously, this gives me a long list of all the data from the query. I want to break it in rows.
View 8 Replies
Dec 20, 2011
I can't seem to get the code structure I'm looking for when importing a csv file into an array. The CSV format in question is 69 columns, and unknown rows since it depends on the time length of the data capture. Over the past 3 days I have tried many methods and can output it all to a listbox, as shown below (column headers appear in order), however when I try to put it into an array it only reads the first column. Am I missing something in the declaration of the array, or do I need to use an arraylist? Every permutation doesn't seem to get the results I seek, or I just plain crash the program.
[Code]...
View 6 Replies
Oct 7, 2011
I am using a datareader to pull data from my database. I store the data in a multidimensional array in a seperate class file. I access the values in the array from a form through properties.The problem I am having is when I run the project as I step through the code I can see the values being added to the array but when access it from a string property it shows up as string System.String[,]. I would like to have my array transposed accross the listview under the corresponding column. below is the code I am using.
[Code]...
View 3 Replies
Jun 9, 2009
I'm working on a project with a large multidimensional array
resrv(200,12,31,33) it keeps track of information on specific dates within a 200 year range.
What I'm looking to do is save the array to a file so that I can load it again when the program is started.
In VB 6 I used to be able to use a simple for next loop into an open file and load it the same way. It doesn't seem to work the same way with Fthe filestream class in VB.net
View 6 Replies
Jun 10, 2011
I have been searching and searching and cannot find out how to do what I'm looking to do, that is the only reason I would post a new thread.[code]...
After reading the file, I want to load the NameId, the ColourId and the Text into a multidimensional array. Anything I have found about loading into an array shows text being separated by small delimiters like commas, but this I cannot do because I need to use this format. What I am wanting to do is load all of the NameId's into a listbox and when a certain NameId is selected, it will bring up the Text in a TextBox and the Colour value in a ComboBox.
View 1 Replies
Apr 2, 2011
I have an image that has dimension of (100,100). I am using FileStream class. When I run the code I get EndOfStreamException error at line 44. I have pasted the for loop section of the code below.
For x = 0 To 99
For y = 0 To 99
byteRead1(x, y) = br1.ReadByte ' line 44 (exception thrown here)
[code].....
View 37 Replies
Nov 27, 2009
Can I save an array into my .bin file then read the array again just like a string or Integer??
View 2 Replies
Mar 28, 2012
im trying to make an example program for a teacher friend of mine
Springfield
Toledo
Youngstown
[Code]....
thats just what i have so far but im really having trouble getting the other part into a 2d array. i want the second half to look like this when done: the oppsite of what it looks like in the file.
001
359
203948
View 3 Replies
Jun 22, 2012
I have a multidimensional array which will hold 3 bits of value and value will be added through a loop by reading from db. When it come this line of code:
*MenuAccess(.Fields("GROUPNO").Value, .Fields("ITEMNO").Value, .Fields("SUBITEMNO").Value) = OKNO*
It's hitting error, 'Object reference not set to an instance of an object.'
Public MenuAccess(100, 30, 50) As Boolean
Private Sub RtGetMenu_Access()
Try
[Code]....
View 1 Replies
Jun 7, 2009
Hi can someone show me an example of a multidimensional associative array in vb.net. Need array to hold peoples name, there age and a few other settings. Want to be able to use a Dictionary to use People.Add.
View 1 Replies
Apr 16, 2009
I've got a 3-dimensional array that I'd like to clear.
View 1 Replies
Mar 17, 2010
I'm writing a game in visual basic 2008 and things are going fairly well with it for the most part.. well until today.. I can declare a 1 dimensional array of a class just fine but cannot for the life of me get the syntax right for a multidimensional array. I usually don't have many issues in writing in VB but this is the first large scale program I have ever written in VB2008 and the 1st large scale uses of classes in VB as well
Here is my code to better illustrate my problem here is the class..minus most of the properties Public Class Objectives private zone as Integer private TZone as integer Public Property TargetZone As Integer Get Return TZone End Get Set(ByVal value As Integer)
[Code]...
View 2 Replies
Oct 23, 2009
I'm very new to VB.NET and I suppose this is a little big for a first project.I've done the same thing in other languages so I figured it wouldn't give me much trouble.I'm working on a map editor program for a 2D platformer game.The map will be an array of a structure which contains the width, height, and tile elements of each layer. the tile elements are stored in a 2D array within the structure.[code]That didn't give an exception but I'm not sure that it actually redimmed considering the second assignment command still crashed.
View 1 Replies
Nov 8, 2011
I am writting a vb.net program that I want to read in data from Excel and then populate a multidim array with it.I have been able to import the Excel data into a DataGridView (haven't been able to go directly to an array). Now I am trying to loop through the DataGridView to populate the array.This is were I am having troubles.[code]
View 2 Replies
Sep 23, 2011
vb.net 2005.
I have profitMarginArray(29,3) <29 is actually a variable, but figured I'd put in a number for the example> and what I need is to retreive elements 0 and 3 sorted on 3 in some way shape or form. The biggest problem is element 3 isn't unique so there could be 5 that have the same value (56.34 for instance) so a sorted list is out.
The current array could look something like
Item1, .34, .75, 54.67
Item2, .32, .75, 57.33
Item3, .29, .5, 42
[Code]....
View 5 Replies
Apr 15, 2012
Is there at all a way to sort (numerically) a multidimensional array?
I have an array that is as follows `dim points(23,1) as String`
The first dimension of the array has the players names in, the second dimension of it has their cumulative points, so I want to sort the array by points and maintaing the correlation of players name to points
View 5 Replies
Dec 12, 2010
* I posted this in VB forum at first by accident instead of .Net* I am trying to create a console application that computes the row and column sum and prints the elements with the resulting sums for each row and column.
[Code]....
My column sum code is currently showing the row sums. I need the column sums to display in descending order. So i know it would require a sorted array, but i'm not sure how to go about doing that given i can't get the correct values to show up. So I would need it to display as "Column sums are 12, 20, 13, 24, 51. " and then the next line would be "Column indexes are 1, 3, 2, 4, 5."
View 4 Replies
Nov 23, 2010
I'm trying to build up a multidimensional array which will hold two bits of info for each record in a database e.g. id, description.[code]...
View 2 Replies
Mar 23, 2010
I need to count number of repeating and position where they repeat of all number in multidimensional array like this:
1 2 1
1 1 2
2 3 1
And result need to be:
Number 1- two times on position 1, one time on position 2, two times on position 3
Number 2- one time on position 1, two times on position 2, one times on position 3
Number 3- 0 on position 1, one time on position 2, 0 on position 3
View 2 Replies
Mar 16, 2011
if i have a multidimensional array:
dim test(,,) as string
how can i loop through the array to find if another variable is contained in the second dimension of the array
dim x as integer = test.indexof(OtherVariable)
obviously above won't work
View 4 Replies
Mar 4, 2011
If I have the following array:
Dim Array(4, 10) As String
Array(0, 0) = "100"
Array(0, 1) = "200"
[code]....
How do I get the following count:
0 = 2
1 = 4
View 3 Replies
Jul 12, 2011
I have a 2 dimensional array and also a 2 column listview box. I am able to insert array (0,i) into column A, but i do not know how to insert Array(1,i) into column B.
[Code]...
View 4 Replies
Mar 26, 2012
I am trying to make a jagged array that has,
3 columns
with 5,4,4 rows respectively
that each have 2 rows
that have a varying number of rows, for example 6,9,5,6,4 I have the first part setup but I don't know how to get to another level of the jagged array.
Dim potentialStructure()() As Short = {New Short() {0, 1, 2, 3, 4}, New Short() {0, 1, 2, 3}, New Short() {0, 1, 2, 3}}
And how would I access an element at say, the lowest level?
View 1 Replies
Oct 29, 2010
I have a multidimensional array (not jagged array) that saves data from rows and columns of an excel spreadsheet. After it completes recording the data from Excel, I need to pass the array to another function.I understand how to pass a jagged array, but not a true multidimensional array.
Can someone point me in the right direction? I've done some searching on this site, and others, but most of the info only includes single dimension arrays or jagged arrays.
View 1 Replies
Apr 30, 2009
I am trying to use a simple quicksort routine for a multidimensional array but cannot figure out the syntax. I am stumped because it works fine in VB6 but no luck in .Net
Array Declaration:
Dim sArrIn(25000, 3) As String 'sort key (pkg, kitting, zip), kitting, data
Function Call:
[Code]....
View 4 Replies
Oct 3, 2009
Dim array1(9,2) as String
So basically, 10 rows and 3 columns and say I want to sort them by the values in the 3rd column.
Each row is essentially a record of data and must be kept together.
Now I know that you can't use the array.sort method but would I have to use a bubble sort or something for this?
What's a good way to manipulate the records while still keeping each row linked together somehow.
View 5 Replies
Dec 12, 2010
I am trying to create a console application that computes the row and column sum and prints the elements with the resulting sums for each row and column.[code]My column sum code is currently showing the row sums.and the rowsum code is showing a continuous sum, rather than a sum for just that row.
View 4 Replies
Jul 12, 2011
I am trying to initialize a multidimensional array. Here is my syntax; this does not create errors but it does not store all values either. Although it correctly prints out all records in this snippet,
dFirstWeek = CDate(FirstWeek)
dFirstWeek = DateAdd(DateInterval.WeekOfYear, -1, dFirstWeek)
Dim dFirstDay As Date
Dim arrWeekYear(5000, 1) As Date
Dim i As Integer = 0
Dim j As Integer = 0
[Code] .....
But this time, only one "j" record appears per "i" record. Why is this? And then after these few records, many dates resembling null dates appear: "1/1/0001". So why do all records appear in upper section, but not from lower? Did I insert values wrongly into this array? And it does not have to have fixed number of rows, just a fixed number of columns.
View 3 Replies
Jan 1, 2011
Is there any way to create a multidinensional array that contains arrays of different lengths (similar to nesting arrays of different lengths in python).
Because if I were to declare a variable Dim accounts(2,2) As Integer all 1D arrays at each dimension have the same length. Is there any way to create an array so that this is not the case?
e.g The above code would create an array like this:
[[0,0],[0,0]]
but would it be possible to create this:
[[0,0],[0,0,0]]
View 3 Replies
