Excel - Retaining Array Values Between Procedures
Feb 17, 2012
How do I effectively declare a Global Array which I can access the values of that array from any procedure? I have a Userform from which I will call various sub procedures depending on the actions performed on the useform. I have one procedure (Procedure1) where I have set up a multidimensional array and input values to it. I have another procedure (Prodedure2) where I want to access the values in the array - I DO NOT want to pass the array values directly from Procedure1 to Procedure2.
View 5 Replies
ADVERTISEMENT
Mar 28, 2011
I am creating a maths programs that draws graphs for the user. so far i have placed 22 values into an array and now i need to import them to excel, draw the graph and import the graph back into the program to display them.[code]...
View 4 Replies
May 20, 2009
I have a datalist control that is not retaining it values during postback when the control causing the postback is outside of the update panel that the Datalist resides in. I have verified that viewstate is on for that usercontrol as well as all its parent controls. My basic situation is that I have a Datalist that contains a user control on a page. When the user selects several rows in a grid and presses a button, a datatable is filled on the backend and assigned to the Datalist which has its item template set to the UserControl.
On ItemDataBound I set specific properties in the control which customize the messages on that control to the specific item. This is then popped up using the AJAX Control Toolkit Modal Popup[ Extender. When the user presses Save the whole page posts back. Data is collected from the user controls and saved to the DB and the popup disappears. The issue I am currently having is that the DataList has 0 items when the save button is pressed instead of the appropriate number. THis issue just started appearing after we upgraded from .NET 2.0 to .NET 3.5.
View 1 Replies
Jan 4, 2011
Throughout our program, forms are opened like this[code]...
The problem is that when forms are closed, they seem to not really be closed, only hidden - if I add some text to a textbox and close/reopen the form, the text is still there, rather than the textbox being cleared like normal. This is presumably because the form always uses the same instance.
Is there any easy way to fix this other than going through the entire program and creating a new form instance for every ShowDialog() call (there are hundreds)?
View 4 Replies
Jan 10, 2011
I have a DataGridView bound to a binding source. I have also, however, added an unbound column in which I plan on putting numbers calculated from the bound columns. The problem is, Any time I edit my unbound column (on any row), the value doesn't stay. If I programmatically edit the values, they never show up. If I type in the cell, then upon hitting enter or clicking outside of the cell, whatever I typed disappears.
View 1 Replies
Jun 10, 2011
I created this function to remove vbCrLf from the values of properties in a Custom Class:(vTransaction)
Public Function ValidateTransaction(ByRef vTransaction)
Dim property1 As String
Dim value1 As String
For Each p As System.Reflection.PropertyInfo In vTransaction.GetType().GetProperties()
If p.CanRead Then
[Code]...
Throughout testing I can verify that vbCrLf is being replaced with a space as expected. When I re-examine vTransaction the changes have not been retained and the vbCrlf's are still there. What do I need to do to retain the changes being made to values in vTransaction.
View 1 Replies
May 6, 2012
I have a structure with 6 arrays inside it that is serializable so I can save the arraylist of them to a file and load them from the file. This part works.
When loaded from the file the data from a single specific record is populated to a listview control, this works on form load. The user can then select different records and in theory display the data in them (specifically the stuff in the arrays).
Displaying the data works as I'm editing the data, and on first load of the form and displaying the "default" record from the structures. Any other time (trying to switch between records during editing or after loading) the record is pulled (as shown by stepping through the code line by line) but the data in the arrays in the structure and only the data in the arrays is missing.
I've gone through all the code that runs and there is nothing that overwrites the array data in the records between displays so I'm at a complete loss as to why this data is going missing.
Below is the structure and the code.
Defined in a Module so as to be accessible when needed in several places through the program:
Public JBonus As New JobBonuses
Public JBonuslist As New ArrayList
On load to set dimensions to the arrays:
JBonus.Str = New Integer(999) {}
JBonus.Agi = New Integer(999) {}
JBonus.Vit = New Integer(999) {}
[Code].....
View 1 Replies
Sep 7, 2010
I am working on a Tag system for a news page designed in ASP.NET. For the system I require a TagExists method to check for tags within the database. The stored procedure I have written is below.
ALTER PROCEDURE [dbo].[Tags_TagExists](
@Tag varchar(50))
AS
BEGIN
[code]....
I have tried switching the procedure to return 0 if the tag exists and 1 if it does not and it still returns 0 despite the exact same testing conditions. I have also returned the actual select query and it has complained of the Tag "news" (my test item) not being an int on execution showing the select itself is definitely properly formed.
View 3 Replies
Jul 17, 2011
On a ASP.net form, I need to add a textbox to update a date field in MS SQL server via stored procedure. I want to verify user input cant figure out the correct syntax to do so (please see below)
If d.Text <> "" Then
cmd.Parameters.Add("@date", SqlDbType.DateTime)
cmd.Parameters("@date").Value = Date.Parse(d.Text)
[Code].....
View 9 Replies
Feb 1, 2011
I do need to write a procedure that carries an array as a parameter- The array can be an array of many types (Dates, Double, Strings etc)- The number of elements in the array is unknownExample:Private Sub MyArrayRoutine(MyFirstPatameter as string, MyArray as array of Object()
View 1 Replies
Jun 10, 2011
How can i pass and access the array variable in Stored Procedures
View 3 Replies
Jun 19, 2011
I have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 Replies
Jul 14, 2009
I am using Visual Basic express edition 2008.I am trying to know if a value in a single dimensional array is repeated in the array. If yes, then multiply one of them by 100. For example:
MyArray (14) = 12, 15, 18, 15, 18, 11, 15, 18, 16, 14, 18, 8, 12, 17, 10
In the above example:
MyArray (1) = MyArray (3) = MyArray (6) = 15
MyArray (2) = MyArray (4) = MyArray (7) = MyArray (10) = 18
MyArray (0) = MyArray (12) = 12
[Code]...
View 8 Replies
Apr 4, 2010
I have an array of 10 x 10 as shown below. In addition to -1, it consists of numbers from 1 to 9.[code]...
View 6 Replies
Jan 2, 2009
cast integer values to an array of enum values?
View 2 Replies
Dec 12, 2010
Per 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 Replies
Jun 21, 2010
I have a program that reads in lottery results from the past 6 months (from the national lottery site) from a text file
31-Mar-2010,29,18,38,44,14,43,13,3,GUINEVERE
27-Mar-2010,32,38,11,15,42,6,24,2,GUINEVERE
24-Mar-2010,3,49,28,5,23,42,41,4,GUINEVERE
and stores it in an array (n-1,6) where n is the number of lottery lines, so the array looks like
0 1 2 3 4 5 6
0 29 18 38 44 14 43 13
1 32 38 11 15 42 6 24
then, in a 1D array I store the player's numbers, simply as
0 23
1 16
2 19
[code]....
I want it to take each number from the player's number array individually and compare them to each row individually in the lotto results array i.e. the first six cells in each row in the results array will be compared with each user number to find any matches, if a value matches then a count is incremented. if the count is greater than 2 but i'm getting no where with it :( i've been trying to use the For To loops but keep getting index out of range, or else nothing is happening at all!
View 5 Replies
Dec 7, 2010
I am writing a pizza order program for class and have gotten everything put together, even got my array setup and displaying but when i go to calculate it will not calculate the values coming from the array in any of the calculations.
[highlight="vb"]Option Strict On Public Class Form1 'declare structure and module-level variables Structure PizzaSale Dim SizaString As String Dim StyleString As Stri]
View 3 Replies
Jun 22, 2010
A c# class's single dimension byte array contains socket level instrument sensor data as per:
public static byte[] frameData
View 9 Replies
Feb 1, 2011
As per this illustration, I'm trying to increase the size of an existing array from 111 to 114 to be consistent with existing code. I need topreserve the existing values and add 3 new items to the end of the existing array of booleans,
View 3 Replies
Sep 8, 2010
Row1
;W910 RF3500AA ;Increase volume by 40 db ;(c) summer ;(p) horse +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row2
;W910 RF350011 ;Increase backlight by 50% ;(c) winter ;(p) vistar +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row3
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row4 (Duplicate of Row3)
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
if label1 = RF350022
label2 = Increase
label3 = spring
label4 = 100%
only if it contains all of these words it should return the first instance (row3) then end or null the rest (row4).how can i get row 3 to show in message box now it has been found?
View 5 Replies
Sep 9, 2010
I want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 Replies
Sep 13, 2011
I feel quite silly asking this, but I couldn't find a definite answer anywhere. in vb.net, how are the array elements defined (if they are defined) for, for example:
Dim myarray(5) as int
does, at this point in time, myarray(3) for example have a defined value? If so, what is it?
View 1 Replies
Jun 1, 2009
I am getting some values in arrayIDs if some particular condtion match i am assinging values to array.Here i am getting problem when this condition not match i am getting values zero in all array indexes,here how to check if array contains zero values in array indexs
Dim
selects As ListView.SelectedIndexCollection
selects =[code].....
View 2 Replies
Jul 17, 2009
i have a requirement like i need to filter out the distinct values from an array to another array.
Dim str As String
For Each str In all
If (Not all2.contains(str)) Then
all2.Add(str)
End If
Next
i tried the above logic to get the distinct list but it is telling contains and Add are not the members of system.array?
View 2 Replies
Dec 9, 2011
I'm having trouble assigning values to an array and am getting the error, "Value of type MemberFocal.Member cannot be converted to System.Array" - MemberFocal.Member is part of a custom class and I am attempting to create an array of these objects. Here is the code:
[Code]....
View 1 Replies
May 30, 2010
TheConnectionValue (this array (5x5) is given)[code]...
View 6 Replies
Sep 8, 2009
There is a check box in my webform. whenever i tick it ..and click on back button it will not retain its state ..when i comeback using the next button to the same page.Note: view state is enabled in the control There is no code in the page load event
Code below:
Protected Sub chkBx_SR_wu_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles chkBx_SR_wu.SelectedIndexChanged
[code].....
View 1 Replies
Jul 14, 2011
Why a public variable is not retaining it's value when exiting a subroutine.
I want to search through an array and if a condition is hit then the subroutine exited (thereby holding the index value of a variable named MarkerNo)[code]...
View 3 Replies
Jan 25, 2009
I can't remember very well the instances where my selected items has disappeared as if I did a "Reset ToolBox", the last time I remember was when I installed the Service Pack early this year. But last year I think it has been reset frequently and I find it bothersome to reselect all those items again and again.Is there any configuration that I could set so that my selected items are safeguarded, that is they won't be removed no matter what?
View 4 Replies