I m trying to manipulate some excel sheet data in visual basic but for tht i hv converted the excel file into text tab delimited file. now i m able access each column n row value as i want but the prob is the text file has to b input n the no of columns in it could be varied so i need a method to count the number of elements in th tab delimited array wen first time the text file line is read.
View 8 RepliesI'm trying to find the sum of all the digits that make up the number 2^1000, which you may have guessed is from Project Eula. I think it's good so far except I'm just learning about arrays and dynamic arrays, so how will I know what the size of the index will be so I can specify when the Do loop should stop so I don't get an indexoutofrange exception?
vb.net
Dim BigNumber As Double = 2 ^ 1000
Dim DigitArray() As Char = BigNumber.ToString.ToCharArray
Dim Index As Integer = 0
Dim SumOfDigits As Integer = 0
[Code] .....
i have a problem with the size of array i want to make a 2-Dimensional array with large size such as
[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 long variable in vb.net which contains the following information,
Dim g As String = "$C:Program FilesCavaj Java Decompilercavaj.exe$C:UsersYoosufAppDataLocalGoogleChromeApplicationchrome.exe$C:Program FilesDVD Makerdvdmaker.exe$C:Program FilesAdobeAdobe Photoshop CS2ImageReady.exe$C:Program FilesJavajre6injavaws.exe$"
The $ symbol is used as a delimiter to separate each item from the other. I need to add the exe file name at the end of each path to a listbox. However the initial process of retrieving the variable to individual array elements is not working properly.
Dim strArr() As String = g.Split("$") 'This variable is empty
For count = 0 To strArr.Length - 1
Dim arr As String = strArr(count).Split("")
[code]....
I have a text file with for example this data in it :
"19 Mar 2010","6:00","16:00","10","1","9","6.61","59.49"
"20 Mar 2010","9:45","19:15","10","1","9","6.61","69.89"
"21 Mar 2010","9:00","17:00","8","1","8","6.61","99.32"
I used " , " to delimit individual pieces of data and " " to denote end of line.I'd like to be able to split the files into lines and assign each line to an array then split each of those array strings into the comma " , " delimited data and feed each piece of data into another array ready for writing to a datagridview.
I've spent a while trying to get Split() to work but I get errors regarding converting strings to one-dimensional arrays Also the Split() method asks for a "ParamArray" but I haven't been able to find examples of other people providing them on the net any idea what those are about?
in parsing a string which is delimited by space in to a Double Array
View 1 RepliesI have a delimited text file, let's call it models.txt and it's delimited by a comma with carriage returns.
example:
21,Z920081
22,Z920082
59,Z930023
120,Z930027
I'm trying to input this into an array and then a combo box using:
dim item as integer
dim array() as string
dim ifile as integer
[CODE]............
What I want to do is to display the right part of the delimited text (Z920081, Z920082, etc) in the combo box. But when you select the item in the combo box, I want it to use the left part of the delimited text (21, 22, 59, 120, etc) as a variable for other use.
Are inputboxes nolonger dynamic in size?in VB6 I could list say 12 months of the year along with month numbers and ask the user to select a month number. So the code would go:strmsg = "1" & chr(9) & "January & chr(13) & "2" & chr(9) & "February" & chr(13) e.t.c. {for each month} & "Leave Blank To Cancel". This would list Month 1 to 12 plus the last line.
There appear to be 2 problems using vb.net:
1The input box does not grow virtically to accommodate a dynamic number of lines
2The chr(9) function to produce a "tab" does not appear to work, whilst the chr(13) (Return) does work
I have a text file, with several lines of comma delimited data. The easy part is that each item fits into the same field, so I can use a 2 dimensional array. I would like to use .net classes to do this, not the old file handling functions I was used to.How can I take the text file and load the data in the text file into a 2 dimensional array.Here is example data in test.txt
1,1,1,2,2,2,1,1,1,3,3,3,4,4
2,3,4,5,1,1,1,2,3,4,5,1,1,1
2,3,4,5,6,1,1,1,1,2,2,3,3,4
So this would go into a (14,3) array.I would like to make sure, that the array is automatically sized to the size of the data also.
i am in the process of learning myself VB.net (2010 dotnet 4 )And am a litte confused in whats the best way to program what can be called an array.i want to have an array that looks like this,
{{"aap", 1}, {"noot", 2}, {"mies", 3, "boom"}, {"vuur", 4, 7}}
now i tried to declare
[code].....
So i'm new to working with vba in access and i'm having trouble getting this code to work. What it is suppose to do is take a selected text file and read the original file into a list box. Then there is a second button that when pressed will convert the text file from a pipe delimited file into a tab delimited file and then show the changed file into a new listbox.
Option Compare Database
Option Explicit
Function GetFilenameFromPath(ByVal strPath As String) As String
[code].....
I am having trouble conceptualizing how to create and load my 3d Array. The Project does the following:
View 6 RepliesI have BIG trouble trying to understand the decleration and creation of an instance with respect to arrays of objects. Basically I struggle with with this error:
Object reference not set to an instance of an object.
complete the test code I made below, so that I can try to understand it..? Been figthing with this for hours..
Code:
Public Class Point
Public x
Public y
[Code].....
I want to build an array with info from an XML file.
The number of columns is static, but the rows will be increased once in awhile and I want one column to populate in a combobox while corrosponding selectedindex appears in a textbox. I think I can figure that part out, but currently stuck at the array building.[code...
I'm working on a program that has to get a set of images and then scan them to find pixels that match colors in an color array. Anyway I think I got everything working but how to load the images in as bitmaps. See the images are dynamic, they change there filenames so I can't call them with a static call like Dim bmp2 As New Bitmap("c:button.gif").
So I am using a loop to feed the images into an array for bitmap but thats not working, anyway that I can do this as, right now the program gets all the filenames for the images from a text file that is sent in to us. All I need to do is have the program check each image for pixels that match our color list. But I cant get the images into the bitmap array.
[URL]..And put into a dynamic array where each month represents a record in the array with 3 given with C/P, Strike and Settle
The criterion is for every month grab all C/P that have matching strikes thus returning the following for every month. See data below and what I would like to return below. Want to use excel VBA to return the values from array into a sheet in excel. See data below
[Code]...
I created a code that will prompt someone to enter a name and if the name is in the array it should print out the correct integer, but it keeps printing out not valid.
Private Sub btnDisplay_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim strSub() As String = {"Jasmine", "Sean", "Devon", "Jontae", "Whitney"}
Dim intNumb() As Integer = {15, 10, 11, 12, 5}
Dim strSearchFor As String
[Code] .....
A project requires to allocate a varying number of byte arrays (buffers).
It would be ideal if the following definition would be possible:
Dim ArrayOfBuffers() as buffer(10000) as Byte
The byte arrays must be ordered sequentially because they have to be written to a file by efficient procedures destinationFile.Write(ArrayOfBuffer(3),1000,1000)
The number of buffers will change during program execution sometimes. Therefore it would be nice to be able to do a ReDim on the data structure when needed.
I've been programming in VB.net for a while off and on, but never really had a need to use custom classes till now.I built a function in a module to populate a class, The class how ever is supposed to refer to one instance.I need to create an array of this class but the amount of instances needed is not always known.Works fine till the class goes to populate the class array.[code]It's probably something simple, I've just starred at it to long. Keep gettitng "Object reference not set to an instance of an object."
View 1 RepliesDoes this create a dynamic byte array?
Code:
Private m_renderedReport As Byte()()
Or this actually creates a structure?
Basically im having problems programming an array as double. I have it as ' public arrytotal() as double ', however I keep getting the error messages
1. Error 5 Operator '+' is not defined for types '2-dimensional array of Double' and '2-dimensional array of Double'. C:UsersAlexDocumentsCafe AssignmentCafe AssignmentconverthomeBackupWindowsApplication2Form2.vb 115 22 WindowsApplication2
and
2. Error 1 Value of type 'Double' cannot be converted to '2-dimensional array of Double'. C:UsersAlexDocumentsCafe AssignmentCafe AssignmentconverthomeBackupWindowsApplication2Form2.vb 84 19 WindowsApplication2
Is it possible to program an dynamic array as a double? i have seen examples of this online, but cannot seem to do it.
Private Sub LoadButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoadButton.Click
Dim lin(8) As String, filRead As StreamReader, i, x, t, d As Integer
[Code].....
I am getting a run time error it is not saving to textfile
I am attempting to figure out the best way to place values into an array using dynamic data that is continuously streaming in from a ComPort. I want the array to hold 5 values at a time, with the newest incoming data point taking the place of the oldest data point. Each set of values in the array will be used in finding a trendline, which is then used in a later portion of the code.
View 1 RepliesI need a way to delete the last element in an array when I don't know how big the array is.Basically I need the VB version of php array_pop, but nothing relevant seems to be appearing in search results.
View 2 RepliesI'm trying to create an array of checkboxes dynamically and also want to put event to those checkboxes. For example: I have a array of checkboxes - Chk1, Chk2. I want it to work this way: When I check Chk1, I want to disable Chk2, and when Chk1 is unchecked, Chk2 is enable, and vice versa.
[Code]....
I have a SQL database which I'm running a query against to return a list of names - eg using "select names from table"I would like to add all of these names to an array so I can use them later. To do this I would need to use a dynamic array as the number of names returned could be anything.Apart from first running "select count(names) from table", getting a value and then Redim'ing the array on the count is there another method I can use.I've seen there's a dataset row.count? Can I somehow use this?
connection.Open()
reader = command.ExecuteReader()
While reader.Read()
[code]....
I need to dynamically create some sort of 'table' on my form. It should look like:
PIC1 INTEGER1 TIME1
PIC2 INTEGER2 TIME2
PIC3 INTEGER3 TIME3
On top of that it should look like a table and have gridlines between the 'cells' containing the picture/data, which makes it even more difficult for me. Before, control arrays were quite simple in VB6, but I've been searching for 1,5 hours now and I can't figure out how to do this in VB.NET 2010. Any idea how to tackle this the most efficiently?
i'm using VB.net 2003 application program. i'm trying to convert a VB6 program to VB.NET. The VB6 code i'm trying to convert is shown below. declared g_Share() array in module and trying to add values to it inside form.
[Code]...
i'm using VB.net 2003 application program. i'm trying to convert a VB6 program to VB.NET. The VB6 code i'm trying to convert is shown below.declared g_Share() array in module and trying to add values to it inside form. VB6 (Code inside Module)'Global type array to hold printer info.
Public Type OShare
PrinterName As String
BackupName As String
CurrId as Integer
End Type
'Declare dynamic array for printer info as user-defined type declared above.
Public g_Share() As OShare
VB6 (Code inside Form)
Public Sub LoadPrinters()
[code]....
when pgm runs and when it reach ".PrinterName = myReader(0)" line, it crashes. Object reference not set to an instance of an object. using immediate window i can see the myReader(0) value. how can i create dynamic array for user-defined type in vb.net?