Passing Arrays And Variables To A Sub Procedure?
Oct 20, 2010
I am trying to complete a homework and seem to get stuck at the last point of passing arrays and avriables to a sub to do the calculations to produce the desired result of sales tax but can;t seem to accomplish that so far.
Public
Class
frmSalestax
Dim
[code]....
View 9 Replies
ADVERTISEMENT
Feb 23, 2010
In a tic tac toe game I am making there are two blocks of code that are identical except that they access different arrays:[code]Arrays plyrTaken and plyrPairs are used in the first block and cmptrTaken and cmptrPairs are used in the second. Is it possible to wrap these blocks into one Sub Procedure passing the different arrays when the procedure is called?
View 5 Replies
Nov 9, 2011
my issue could be found simple but I'm founding it difficults in regard of dealing with array concept in oracle and vb.netI will start by showing to you a code done in oracle side1-this script should be executed in hr schema2-create a table and call it job_testas
create table job_test as
select * from jobs
where 1=2
[code].....
View 2 Replies
Jan 12, 2011
I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them i.e.:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between '10/3/2010' and '10/10/2010'
Here is my code for the form that will be passing the variables payPeriodStartDate and payPeriodEndDate to the stored procedure:
Code:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click
Dim ssql As String = "select MAX(payrolldate) AS [payrolldate], " & _
"dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') AS [Sunday]" & _
"from dbo.payroll" & _
[Code] .....
And lastly since I'm calling those variables payPeriodStartDate and payPeriodEndDate, I assume that my sql query will have to change as follows:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between payPeriodStartDate and payPeriodEndDate
Is that correct?
View 2 Replies
Feb 2, 2010
I have a VB.net console app and I am opening a function in a dll written in fortran. I am passing 3 arrays through the function by reference. When they come back out the otherside they ahve all tunred to arrays of only one element And that element is 0.I read on the internet somewhere that when doing this kind of thing it is a good idea to only pass the first element of the array into the function.I tried changing my function declaration to accepting single elements rather than single dimensional arrays, and now the arrays are the same length before and after the function call, but they don't seem to be changing at all, so i'm not sure that this is working
View 1 Replies
Sep 27, 2010
I have code, shown below, that works all except for 1 thing: The variables being passed byRef get passed, but once modified in the else section of the "if me.invokerequired" code of RecordData, the variables are never updated in the calling function. To reiterate, the calling function does not receive the updated data that is in the variables custid and amt.When debugging, I see the data change in the else section of "if me.invokerequired", but once it returns from the callback the data is missing.[code]
View 15 Replies
Mar 8, 2011
Question 1: What is the difference between "Background Worker" and "Worker Pool" as indicated within the MSDN samples provided.
Question 2: I noticed while using, AddressOf _Function_, variables cannot be passed; what would be an efficient solution to this?
Question 3: While using multithreading is it required to invoke before setting variables, or only form properties?
Question 4: While using System.Net.Sockets is it safe/efficient to use Application.DoEvents while waiting for new data; or would be using a Do While loop be fine without DoEvents since the action would be multithreaded? Note: there can be up to 2000-3000 sockets in use at a time.
View 10 Replies
Nov 19, 2010
i created a list of picturebox arrays in my program :
Dim MyPicArray As New List(Of PictureBox)
and i used this code to add them:
MyPicArray.Add(New PictureBox())
[Code].....
the above code works the pictures are created in the form but now i want to write events for them, for example in the 'Click' event a messagebox shows. i don't know how to write the procedure i have tried this but it didn't worked :
Private Sub MyPicArray_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyPicArray.Click
MessageBox.Show("It Works!")
End Sub
View 3 Replies
Apr 18, 2010
I'm trying to pass an array from a 2D Array to a function that takes a 1D array, but each time I do I get the error Number of indices is less than the number of dimensions of the indexed array.. I know using a structure would solve the problem, but unfortunately the assignment is to use a 2D Array instead of a structure. I've declared the 2D array as such:
Const MAX_ARR_SIZE = 63
Public HouseholdCollection(MAX_ARR_SIZE, 2) As UInteger
Const IDENTIFICATION_CODE = 0
Const MEMBER_COUNT = 1
View 3 Replies
Nov 27, 2009
I ran into an error when trying to do this:
Code: ChartBuffer = GetCurrentChart(ChartBuffer) The error says Conversion from type 'Integer()' to type 'Integer' is not valid.
Apparently I have some type casting issues, the problem is I'm not trying to cast any types at all. I'm trying to set one array chartbuffer equal to the array returned from GetCurrentChart.
[Code]...
In the constructor of this class I am trying to set the buffer equal to the loaded chart because if I try to write information to a buffer that isn't already initialized, and then save it, it will overwrite stuff that might already be saved in the file as 0's or something, and I don't want it to do that. To prevent this from happening I'm simply going to initialize the buffer in the constructor by setting it equal to the loaded chart. Finally after that is all done I can write new information to the buffer and save it to the file without writing a mostly empty buffer (full of zero's) to the chart that is saved with information in it already.
View 4 Replies
Feb 10, 2010
I have a form which contain Two textbox control. When I passing the Form to Procedure the textbox controls of the form not getting say I am giving Exaple.
Code:
Public Class Myform
'This Form Contains Two Controls TextBox1 And TextBox2
'Calling the Procedure
[code]....
View 6 Replies
Feb 11, 2010
I am in great trouble. I have a form which contain Two textbox control. When I passing the Form to Procedure the textbox controls of the form not getting say I am giving Exaple
Public Class Myform
'This Form Contains Two Controls TextBox1 And TextBox2
'Calling the Procedure
[code]......
View 1 Replies
Apr 8, 2010
project, but have decided to take another direction on it, after much and continued struggling.I started out trying to use data binding, but was advised to use straight SQL statements in the code. So what I'm trying to do now: I have 2 forms, frm1 and frm2. frm1 has a combobox, which is showing all the data fine from a table, and an OK button. Upon clicking on this button, I need frm2 to load, correctly populating its textboxes and comboboxes with the corresponding data, based on the selection made on frm1. This is what I have so far:
View 14 Replies
Dec 14, 2011
Public Sub drawChart()
Dim panel As Graphics = picBox.CreateGraphics
Dim myTextBrush As SolidBrush = New SolidBrush(Color.Black)
[code].....
View 1 Replies
May 18, 2011
I loading an array with data from my data base and then putting into a session Variable. I do not get any errors on that code. When I try to put the session Variable back into an array in my .aspx page I receive the following error message: [code]
View 5 Replies
Aug 24, 2011
I am wondering if I need to set my variables to Nothing at the end of a procedure or just garbage collection take care of it automatically.For example, is the code below necessary? Why or why not? [code]
View 15 Replies
Oct 20, 2009
passing a variable to a sub procedure by reference. Not sure I understand how it works. Here is the code.
Private Sub bntcompute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bntcompute.Click
Dim x, y As Double
getnumbers(x, y)
displaysum(x, y)
[code]....
Is the newly modified variable actually being Passed back? and If so where in the statement is it passed back. is it being passed back to the call getnumbers or is it passed back to the statement displaysum?
View 6 Replies
Jan 19, 2011
I need to write a procedure which will allow me to set readonly attributes for certain objects, for example:My form contains two text boxes box1, box2.My sub procecdure will contain code which sets box1.readonly() = true, but i dont want to name the "box1" in the sub procedure but pass it as a parameter....I thought this could be achieved using :
private sub disableobject(byval inobject as system.object)
inobject.readonly() = true
end sub
View 7 Replies
Aug 12, 2010
Can't seem to figure out why this is not working.
Dim Myspcmd As New SqlCommand("spDataImport", myConnection)
Myspcmd.CommandType = CommandType.StoredProcedure
Myspcmd.Parameters.Add(New SqlParameter("@FileName", Data.SqlDbType.NVarChar, 100)).Direction = ParameterDirection.Input
Myspcmd.Parameters("@FileName").Value = "Import_File.dtsx"
myConnection.Open()
[Code]...
View 11 Replies
Oct 12, 2009
I am confused about how to pass parameters to a stored procedure. The stored procedure is written in sql server 2005 and the code is in vb.net.
I have included the sub that I am working on. I know that my use of parameters is wrong.
Public Sub AddRecipe()
Using myDBconnection As New SqlConnection(setConnstring)
Using SQLcmd As New SqlCommand()
[Code]....
View 4 Replies
Jan 6, 2011
This may not be the place to ask this, if not, you can move this post to the SQL forum but I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
where dateadd (n, Timestamp, '12/31/1899') - ([LoggedIn]/1000)/60/1440+1 Between '10/3/2010' and '10/10/2010'
and I'd like those values to be
Between payPeriodStartDate and payPeriodEndDate.
View 5 Replies
Jan 6, 2011
I have an application that I'm building which pulls dates from a database. The start value is stored as payPeriodStart date and I add 7 days to get the end date. What I need to know is, is it possible to store those values and pass them to a Stored Procedure? Currently my stored procedures have "static" dates in them ie:
[Code]...
View 2 Replies
Feb 28, 2009
I am struggling with trying to pass values to a stored procedure, I am creating new records on my table by the values are not passing to the table.Here is my persistance class.
Public Function createDMRIssue(ByVal ItemNumber As String, ByVal IssueStatus As String, _
ByVal ProblemDescription As String, ByVal p_AuditResults As String, _
ByVal DMRDate As String, ByVal p_IssueCategory As String, _
ByVal p_DMRInitiator As String, ByVal p_QtyUnacceptable As Integer, _
ByVal p_ProductType As String, ByVal p_OrderNumberm_dmrissue As String)
Me.Connection()
[Code]...
View 7 Replies
Mar 30, 2010
I have my own little tutorial about passing variables, and if you'll look at the code below, you'll see how I am passing the variable from one sub to the secondsub. Here's my question, how can I pass a value back from the 2nd sub to the 1st? So if I want to sum intA plus intB, and want to return that value to the first sub, how do I do that? [code]
View 18 Replies
Nov 11, 2011
I have a pipe delimited file with 3 values on each line, something like this:
0001|234587|Bracket, 3 x 3 x 0.125, Steel
0001|254378|Bracket, 4 x 4 x 0.125, Steel
0003|234587|Hinge, 4 x 4 x 0.125, Brass
The first Value can be duplicated in the file, the second value also can be duplicated. There are no instances of BOTH values duplicated on 2 or more lines. I need to read another file and get the first 2 values, then look up those two on one line to get the proper 3rd value. The "other" file looks a bit like this:
0E0522070001EF54ED7823458700FF00FFA5A5A5A5
-----------XXXX-----------XXXXXX--------------------- (X's are the data, the rest is filler to comply with some code unknown to me)
Right now I have code to read all into an array (split on vbcrlf), then split each line on "|" and populate three arrays, I then go thru every element of the first column that matches the value I am looking for and test that the second column also matches the second value and if so, return the third array contents at the same index. This seems crude and inefficient. Cannot use a hashtable (I don't think) as it only supports 2 values. A List(Of) doesn't seem to work either and I don't want to use a database.
View 6 Replies
May 5, 2009
I can't get my variables in the program below into thier arrays.
Dim lblnumbers(6) As Label, txtweight(6) As TextBox
Dim txtnumbers(6) As TextBox, sngnumbers(6) As Single
Dim grade() As String, g As Integer = 1, weight() As String
[CODE]...
View 17 Replies
Oct 26, 2010
I would like to create a stored procedure that will call any webservice by passing to the stored procedure the webservice name/url and its parameters. I would like this instead of adding web refference each webservice one by one.
View 7 Replies
Jan 15, 2009
I have three items in my checkbox list, what I want to do is for the user to select either one of them in any combination and pass these values to my sql server stored procedure which then returns data according to the values passed to it in the where clause and binds this data to a gridview. However, at the moment in my sp I have three I parameters, in the case of the user selecting one item from the list not enough arguments will have been passed to the procedure. I'm not sure how to go about doing this
View 2 Replies
Jan 14, 2011
I am trying to pass some declared variables to a stored procedure. Here is my
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click
Dim ssql As String = "select MAX(payrolldate) AS [payrolldate], " & _
[Code].....
View 10 Replies
Apr 21, 2011
I have a program that I am writing that asks the user for information.The program takes that info and passes the strings to a module that has a set of case statements for comparison.The program was working just fine yesterday, and now it acts like there is no information being passed to the module for comparison.[code]
View 2 Replies