How i can make an array with unlimited range in VB.NET and also get the number of variables containing?
I tryed:
Dim _items(,) As String
_items(0, 0) = "hy"
_items(0, 1) = "hello"
[Code].....
How i can convert this array to an UNLIMITED range array?
[Code]...
I Declare a 2D Unlimited array.My code:
Dim array As String(,) = New String(,) {}
array(0, 0) = "top left"
MsgBox(array(0, 0))
The problem is the msgbox shows nothing.
I want to define an unlimited array of integer and add values to it but I have some problems.
I'm using this code (for example):
Dim I() As Integer
I(1) = 1
I want to make a treeview where users can add information and folders in it.I managed to do code for an xml document so that the users can have up to 1 folder, but I want to have moreIs it possible to have an "unlimited" xml/treeview? Like in IE, Safari, Google Chrome, you can make unlimited folders and it will still save; how can I do that?
View 7 RepliesI want to make a treeview where users can add information and folders in it. I managed to do code for an xml document so that the users can have up to 1 folder, but I want to have more Is it possible to have an "unlimited" xml/treeview? Like in IE, Safari, Google Chrome, you can make unlimited folders and it will still save
View 3 RepliesPer this UserControl that can be added to a blank form, I would like to use the HorizUnits array below to map custom grid x coordinate from a mouse x position.For a given input value 13, what syntax would I use to obtain a value of 2 where 13 lies between Value 10 and 16 for which 2 (Name) would be the custom grid's displayed coordinate position?
View 1 RepliesI have a string array, and I need to get a range out of that, say 10 items counting from index 20.
I see there is an extension method called Take that can take a number of items from the beginning of the array, but I also need to specify the starting index.
OK I have been gooding for over 8 hours trying to figure this out. Bare with me I do not work with arrays much.I have brought an array in from a range in excel. This works fine. Through debugging i can see the values are brought in correctly.
Issue is I want to see if a string exists within that array (or cells).I have tried lots of things and pretty much mutilated my code but here it is:
[Code]...
I tried the following : (VB.Net code)
[Code]...
I have formulas in certain cells and happens to be part of the Excel range that I pull into a vb.net array and when I write the array back out to the Excel Range, I loose all the formulas in it.Is there an option to retain formulas in a .net array?
View 3 RepliesI am creating an app to use as a data logger, that receives serial data from a micro-controller and displays the various values and to plot some line graphs of the data, as well as eventually sending commands to the micro-controller, right now though I'm just trying to get the data being received to display in a rich text box like :
[Code]...
In VB6 I could assign an Excel range directly to a variant array dim vArr as variant vArr = xlSheet.range("A2:A10").value and then work with vArr to pull out the values I needed. This doesn't work in VB 2010. Is there a replacement procedure to allow me to read in a range (perhaps large) all at once and then process the data without needing Excel?
[Code]...
I am trying to open an exisiting excel sheet and then I want to copy a range of cells in to an array in one shot instead of looping thru cell by cell.And then I want to do some calculations and then move them to database tables.[code]...
View 3 RepliesIn VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top..The code is part of a routine to programmatically check whether an image overlaps cells that are used in a workbook. My current method of iterating over the cells in the UsedRange is slow since it requires repeatedly polling for the top / left / width / height of the cells.I'm going to go ahead an accept Doug's answer as it does indeed work faster than naive iteration. In the end, I found that a non-naive iteration works faster for my purposes of detecting controls that overlap content-filled cells. The steps are basically:
(1) Find the interesting set of rows in the used range by looking at the tops and heights of the first cell in each row (my understanding is that all the cells in the row must have the same top and height, but not left and width)
(2) Iterate over the cells in the interesting rows and perform overlap detection using only the left and right positions of the cells.[code]
I need to read a named range into an array. Then if the value in the 1st position matches a static value, read the value in the second position. I've been looking into array's and this is what I think will work, however I get a compile error on the columns.count "constant expression required". Is it because in the DIM statement I'm attempting 2 things? This is a macro in Excel. The range name is Data1 and the string comparison is "AnyString". The second value will be an integer.
Sub macro1()
Dim rng As Range
Dim x As Integer
Dim y As Integer
rng = Range(Data1)
[Code] .....
I am importing data from an Excel spreadsheet into an array. I want to search the array to find the location of each "cell" with text that contains a certain string (e.g. "MyTestString"). So far the best I can do is loop through each element and test it using CStr, but the code takes too long to execute (please assume all variables are properly declared):
[Code]...
(1) Is there a better way than looping through each element, such as a built-in function or a lambda that will return an array containing *the location of* all string matches?
(2) Would it be faster to convert the Object array to a String array rather than using CStr on each element? If so, what is the fastest way to convert a 2-dimensional Object array to a String array?
I've considered using Excel's Find function instead, but would prefer to limit the number of Interop calls to Excel.
Trying to replace Cells(RowIndex,ColumnIndex).Value() calls by row-wise references for performance, I permanently fail at referencing the result. Starting with Excel Interop - Efficiency and performance, which contains the tip to use get_range, i.e.
//get values
object[,] objectArray = shtName.get_Range("A1:Z100").Value2;
iFace = Convert.ToInt32(objectArray[1,1]);
//set values
object[,] objectArray = new object[3,1] {{"A"}{"B"}{"C"}};
rngName.Value2 = objectArray;
[Code]...
However, referencing Values with two dimension indices always returns an "index was outside the bounds of the array" exception. Inspecting the array with the debugger shows a nice 2-dimensional array which should has 17 elements on the second dimension, so Value (0,0) should indeed be a valid reference -- but it isn't:
The debugger lets me inspect Value, I can also drill down to Value(0,0) and see the correct value, but re-evaluating just that element, i.e. inspecting "Value (0,0)" returns above message.
I am trying to rebuilt the BOM system from an existing BOM application. The table i used was the existing table and cannot be modified as it is contain around 20000 of part no there.What i am going to achieve is the structure view of the BOM using the treeview control. I want it to have as many nodes as the BOM required which different from one to other part no.Here is the structure of the table.
id
model_no
parent_no
[code].....
I have unusual format of XML as below example
<mainmenu>
<menu caption="File">
<menuitem caption="New" tooltip="Create New File" shortcut="Ctrl-N" Action="New">
[code].....
How would you let the user of a program enter an unlimted amount of numbers ranging from 0-100, and then have the program tell the user the highest and lowest values from the data they entered?The user would enter the data in when they clicked a button, and the program would sort the data out when another button was clicked.
View 8 RepliesI have one user that is having a problem with my application, the error report shows an event type of clr203r and an index out of range exception. From what I've read this seems to have "something" to do with arrays or lists. (What that something is, so far, is beyond me or anything I've researched). I do have one array in my program -- myarray(13) as byte and I do have the syntax right as far as noting 20 elements in it. in my other bits of code.
I'm reading those bytes in the serial port, deciphering them and performing some actions. (to be vague). But just with what I've said, can anyone point me to a possible problem? Is the index out of range exception ALWAYS concerned with just arrays or lists? Or could it be something else?
I am dynamically creating an unlimited number of background workers and would like to handle errors from them.
In a try statement I am using the following:
Catch ex As Exception
'Me.BeginInvoke(New UpdateTextCallback(AddressOf Error_Text), New Object() {Message, Account})
Exit Sub
End Try
I have commented out the BeginInvoke command because I can not get it to work. I get an error the the handle has not been created. This subroutine is in a module and I can not figure out how to get the invoke to work.
How can i store unlimited multi-row strings without the need of extra files?Example: the user enter a multi-row string into a textbox and clicks save. Then the program should save that somewhere. And then the user enters another string and clicks save. And then there is a combobox where it can choose between those 2 strings to load.Can i save them in some sort of collection like My.Settings.Collection? Where each text also has a header.
View 5 RepliesCreate a program which promps the user to enter an unlimited number of test scores. The program should show the high score and the low score. You should use a loop of your choice within this program. The program should look similar to the one below:
View 3 RepliesTrying to input a high setpoint, low setpoint, a % load, and number of compressors, then calculate the temp that all compressors are off. Then build a datagridview with the staging of compressors from all off to all on for each compressor up to 10 compressors.I am trying to insert headers from 1 to 10 compressors (Variable) with the text "Comp1", "Comp2", etc....Two rows with header. I am trying to use an array with index number to insert the text, but that is where my problem happens."Index was out of range".Here is my code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim i As Integer, num1, num2, num3, num4, alloff As Single, stg As Single
TextBox1.Focus()[code].....
I am trying to copy the values to another sheet but not in any sequence eg.A1,B2,C4,D7 ........and so on. I am trying this slick way of doing it by the code below ( found on the web) without success so far but I got a feeling I am close to the solution. I am new to any kind of Programming. This is my first attempt. (so a chuckle or two is ok after seeing my "difficult" problem)
(This is an excel VBA Prblem)
Sub justdoit()
Dim s As Variant
[code].....
I am using the following code in the Load method of a VB form to generate random numbers in the range 1 to 8. Without fail after enough loops the range is exceeded and 9 is the random number returned every time. The line using the Rnd function is from: Rnd Function (Visual Basic)
[Code]...
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
Public Class Form1
Dim str As String
Dim strA() As String
Dim strB() As String
Dim f As Integer = -1
Private Sub btngo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btngo.Click
If txtmain.TextLength > 0 Then
str = txtmain.Text
[Code]...