i would like to read a csv file and import this to another array that i am using for further calculations in other modules. i foresee something like below but am not sure how to make it work.
[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 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?
I am using visual studio 8. vb.net.I have an array, array1(100,8) and I want to save it as a csv file so that I can open it in excel and examine the contents more closely. The feature, of saving as a csv file, is not going to form an integral part of the finished vb app, I just need something quick and dirty because the data in the array just requires looking at in excel so that I can fully understand its significance and thus continue coding my app.
View 2 RepliesSituation: I have a .csv file containing numerical values. I'd like to read the file and write the values to a 2-D array of the same form. Problem: I get all the rows of the .csv file written to a 1-D array. Looking at the code, I thinking I have the indexing for column and row positions incrementing properly but (besides experience in C#) I don't know what I'm missing. Below is the code accomplishing this.
[Code]...
How to save a 2-dimensional array to Excel file. The result would be two columns in one Excel sheet.
View 39 RepliesI 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]......
VS 2010 Converting Text file of any size into a 2 dimensional array
View 15 RepliesI am trying to input a text file of figures into a 2-dimensional array. I want to do this so I will then perform percent changes on the respective columns. The text file contains columns and then numerous rows for each columns each number is separated with a tab. The text file looks something like this.
2.2 5.5
3.7 6.3
9.2 9.1
So I need to be able to input the text file, turn it into an array and then find the total percent change. From 2.2-3.7-9.2
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 trying to read lines from a file and split them into two words contained in a two dimensional array. The file looks something like this:
dog cat
red blue
orange green
night day
[code]....
'When I run it, it highlights the following line and says Object reference not set to an instance of an object
pos(i, 0) = value(0)
pos(i, 1) = value(1)
i = i + 1
Loop
[code]....
why I'm getting this error?
I have used this method in php and now I want the same in vb.net, but I don't know how to do this.
In php it looks like that[code]...
im currently importing an text file from .net into excel using the following code :
Dim oExcel As Excel.Application
Dim oWorkBook As Excel.Workbook
[code].....
I want to import a text file into an array.I have used this method in php and now I want the same in vb.net, but I don't know how to do this.[code]
View 2 RepliesI am having a problem understanding the following error message:
Value of type 1-dimensional array of string cannont be converted to 2-dimensional array of string because the array types have different numbers of dimensions This line seems to be causing the error:
New String((13) - 1) {}
I did a Google search on this but didnt come up with anything useful. I didnt even change the code.I just found this example online and copied/pasted it into a project that Im working on.
All code is listed below!
Calendar.aspx.vb
Imports System
Imports System.Data
[Code].....
I need to append STRINg to Array and cast it 1-dimensionalArray
Dim remoteFileNames(0)
As
String
[Code]....
Here "FtpRemoteDirectory" is a string and ftpFileNames() is the Array String which list the FileNames.
and remoteFileNames is 1-dimension array
I developing a roster application (asp.net with VB + sql server) to let user input shift duty record, proposed screen as follows:for the database design, each staff will have one record per day.[code]I want to create a multi dimensional array to bind the gridview.Is that correct that I create a arraylist (for 7 days) and then a subarray for each day? How can I create a 7 dimensional array & sub array under this 7-D array in asp.net + VB ?
View 1 RepliesHow to redim a two dimenational array in VB.NET, when it reached it's upper limit,.Also want to preserve the data.
View 2 RepliesI've been working on a VB project where I use a 1st drop down list to select a movie category and then in the 2nd drop menu, movies from that category will be displayed. The movies are stored in a 2-dimensional array by category. I've been able to edit my array but I'm having problems with my .AddRange() function. What would I have to put in those parentheses for the list (for each category) to appear in my 2nd combobox when the category is selected?
[code]...
Ive 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:
I declare 2-dimensional array at class level
Dim delItems(9, 9) As String
The array elements are then each set to "EMPTY". I create a new form in memory
Dim frm As New Form
I create a new DataGridView add columns to it and add it to the new form
Dim d As New DataGridView
frm.Controls.Add(d)
Now the problem.....this code give error when try to load contents of 2-D array into DGV:
For i As Integer = 0 To 9
d.Rows.Add()
For j As Integer = 0 To 9
d.Item(i, j).Value = delItems(i, j).ToString
Next
Next
Error is ArgumentOutOfRangeException (Index was out of range...)
When I check value of loop control variables, i = 0 and j = 1
For my programm I am supposed to store the minimum points in a five-element, one dimensional integer array name points. And I need to store the grades in a five-element, one dimensional string array named grades. These arrays should be parallel arrays. I am supposed to code the display grades button click event procedure so that it declares both arrays. It also should search the points array for the number of points entered by the user, and then display the corresponding grade from the grades array.
Here is my code:
Option Explicit On
Option Strict On
Option Infer Off
Public Class Grades
Private Sub exitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles exitButton.Click
[Code] .....
I want to convert a stringbuilder to a matrix.[code]...
View 3 RepliesI have an application in VBA that gives to my VB.Net dll one bi-dimensional variant. It is a an array, in which every component is a another array containing two positions.
I want to get this two-position array. When I am using VBA I can access directly the data from each position by doing:dataArray(index, 0) or dataArray(index, 1)And when I want to get the two-position array I can use:
Dim posArray as variant
posArray = dataArray(index)
[Code]...
I have a VC++ DLL, which returns the sum of two long double values, passed as one dimensional array?l the right syntax to pass array to this dll from vb.net
currently, my code snippet is as follows: DllClass.vb
Imports System
Imports System.Collections.Generic
[code].....
Here are the facts: Consider the following program. Sub Main()
[Code]....
Compiling the program in Visual Basic Express produces no errors. However, if the program is imported into the Excel Developer environment; I get the following error: Expected: end of statement with the equal sign highlighted. A side comment: About eight years ago, I wrote a Visual Basic simulation program to study financial trends. I found that version of Visual Basic user frendly! I find the 2010 version very difficult for doing simular projects.
i want to make a vb.net program that reads from a text file a movie, with the help of a Open Dialog (called openFD in my program) (we don't know how many movie we've got), the actors, the release date, the country, and the rating.
The text file look like this:
Movie1;Actor,Actor,Actor1;Date1;Country1;Rating1
Movie1;Actor,Actor,Actor1;Date2;Country2;Rating2
...
First question: How can I make a 2-dimensional array? line(0,0) - Movie1, ... , line (1,5) - Rating2. Here Is my try, but it's not good:
Dim line As ArrayList = New ArrayList()
Dim itm As ArrayList = New ArrayList()
Dim i As Integer = 0
[code]....
And here is the code for the Delete Button. It deletes a movie from the listbox, but the details of the deleted movie remains for the next one, I must delete the details for the deleted movie, too.
ListBox1.Items.Remove(ListBox1.SelectedItem.ToString)
i'm extremely confused. my professor gave us this as the FIRST problem to do in this intro to VB class...on page 380 of our text. it is due today and i have been up all night trying to figure out where to even start. i'm so frustrated. could someone please help me and steer me in the right direction? use a one dimensional array to solve the following problem: a company pays its salespeople on a commission basis. the sales people receive $200/week, plus 9% of their gross sales for that week. for example, a salesperson who grosses $5,000 in sales in a week receives $200 plus 9% of $5,000, a total of $650. write an application (using an array of counters) that determines how many of the salespeople earned salaries in each of the following ranges (assuming that each salesperson's salary is truncated to an integer amount): $200-299, $300-399, $400-499, $500-599, $600-699, $700-799, $800-899, $900-999 and over $999.
Allow the user to eanter the sales for each employee in a TextBox. The user clicks the Calculate Button to calculate the person's salary. when the user is done entering this information, clicking the Show Totals Button displays how many of the salespeople earned salaries in each of the above ranges.
I'm having trouble with this specific code and on arrays in general. This is what I am asked to do: "In this exercise, code an application that displays the number of students earning a specific score. Declare a 20-element, one-dimensional integer array named intScores with the following 20 numbers assigned to the array: (88, 72, 99, 20, 66, 95, 99, 100, 72, 88, 78, 45, 57, 89, 85, 78, 75, 88, 72, and 88). Code the procedure so that the user can enter a score from 0 to 100. Then the procedure should display using a message box the number of students who've earned that score."
First off, I do not know what I'm doing wrong with my array.. it says there's an error in line 31 saying "variable intSubscript hides a variable in an enclosing block" but I don't know what that means. And lastly, once that is sorted out, I don't know how to code a message box to appear saying how many students have received that score.
[Code]...
I want to put a two dimensional array into a stack and then check the stack to see if it contains the first dimension of the array. Is there any way to override the contains function to do this.
Example:
Dim MyStack as stack
Dim sItems(0,2) as string
sItems(0,0)="Error 1"[codee].....