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
I know the title seems pretty trivial but i have an issue and i can't seem to get round it, i have the following code within one sub procedure..
Dim X, Y As Integer
X = 32
Y = 285
[code]....
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]....
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?
I have been banging my head against a brick wall for 2 days on this one. Someone please help, I am sure I am doing something stupidly wrong.I have a stored procedure that accepts 2 inputs and has 4 outputs. The SP checks the users database against a given username and password.
[Code]...
My stored procedure:
[Code]...
So my idea is to have (in my VB.net project) a string that could dynamically change the stored procedure "Future"
The instructions are as follows:
1. Write a Visual Basic Console Application.Inside the main procedure call a function procedure to input and return a value for a double variable called x, the width of a right triangle.Inside the main procedure call the same function procedure a second time to get a value for a double variable called y, the height of a right triangle.
2. From the main procedure call a function procedure which calculates and returns a value for the hypotenuse equal to the square root of (x squared + y squared).You will have to pass the values of x and y to this function procedure.The procedure should calculate and return a double type value.The value that is returned by this function procedure should be equal to the square root of (x squared + y squared).
3. Also from the main procedure call a sub procedure to display the values of x, y, and the hypotenuse.
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 RepliesWell i ran into some problems changing my getfwt to a independant sub procedure. This stuff is so confusing to me.[code]...
View 14 Repliesi able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error. [code]
View 2 RepliesIs there a way to terminate calling procedure from the callep up procedure? I tried 'Stop' from a called up procedure in an executable; it has gone stuck; I am not able to remove it(the form) from the screen!
View 18 RepliesI finished coding an application for converting Celsius to Fahrenheit, and vice versa. I used the Sub Procedure to convert them. What I need now is to modify it. I would have to use the Function Procedure instead of my Sub Procedure.
[Code]...
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
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 RepliesI define some global variables of a class as follows:
Private Class MyClass
Private var1 as Decimal
Private list1 as List(Of string)[code].....
But I found that after this form is closed, all above variables, var1, list1, list2 still exist in memory. I thought they should be collected by gc since the form is already disposed as I confirmed.
Add: I have monitored half an hour after the form is closed. But these variables are not collected by gc. I have an automatic update procedure on the form which uses above variables.Since the above variables still hold values, the automatic update procedure is always called which causes exception. (One quick fix is to check if form.isDisposed in update procedure. But I do not think this is elegeant. Besides, these variables occupy memory.)
Does the memory used in declaring variables are reclaimed by the OS when these variables go out of scope?Does the memory used be released by setting thier value to nothing? if not, then how can I force the garbage collector to run or excecute at a certain/desired time..How about in Windows Forms..How can we make sure that the memory used in initializing and showing forms be released if those forms were closed?
View 13 RepliesQuestion 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.
I'm new in .NET programming.I have a class Form1 that includes Button1_Click event.Button1_Click creates a multiple Text Boxies at run time)Here is the class:
Public Class Form1
Dim shiftDown As Integer
Dim counter As Integer
[code].....
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
The store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
I have to get a value in $.I have 2 radio buttons:
-Residential Customers
-Business Customers
I have 2 List boxes:
-Premium Channels
-Connections
I also have a total Text Box and a calculate button..My goal is to get a cost given the information from the user. the list boxes will have preassigned numbers in them..The residential Customers have to pay a $4.50 Processing fee, a Basic service fee of $30 and 5$ for ever Premium Chanel they buy. The Business Customers have to pay a processing fee of $16.50, a basic service fee of $80 for the first 10 connections (4$ for any connection after that) and 50$ per Premium Chanel (no limit)
I have a stored procedure to update a table, but needs a couple of values from another table.
the first two selects get the value from the table and then are used in the update statement.
The select statments:
Select @iStatusDropDownValueID = iDropDownValueID
From DropDownValue
Inner Join DropDownValueType On DropDownValue.iDropDownValueTypeID =
[Code].....
First, the values that are retrieved by the first two select statements are always the same. So they could be passed in by the code itself. I don't know that this will speed things up at all, just make the entire stored procedure better and easier to read.
Second, if the "Value Name" should change this store procedure will break (which is possible, but not often).
I am looking for any insight into the Best Practices for this situation.
I want use a stored procedure in my project but I have no idea about it. Please could you tell me a little bit about how to use I can use one in my vb.net application ?
View 2 RepliesOK. So I have a class-level array:
Dim terrain()() As Double and I want to add the bounds in a procedure:
Dim terrain()() As Double = New Double(divisions + 1)() {}I can't add the bound for the seconds dimension.
Then I want to assign a value to any element of the array inside the procedure.
terrain(0)(0) = 0.5 This gives the error: Object reference not set to an instance of an object You can see my problem. What solution can there be to this problem that involves one array.
I have tried ADO, now I've moved to SQLClient and I still cannot retrieve the return value from my procedure.
Here is my VB code:
cmd.CommandText = "usp_executeMerge"
cmd.CommandType = CommandType.StoredProcedure
Dim retparm As New SqlClient.SqlParameter
[code]....
My mergeResults table shows the return value of 99 but I cannot get any value back to my VB program.
I have noticed the following but unable to understand why.Whenever a procedure is called in .net it takes more time than when it is called subsequently.Even if a procedure is called after some interval it takes more time than it takes if it is called quite frequently. i am not asking about sql query or sql command. any user definded function or user defined method takes much more time to finish when it is called occasionaly. but when the same procedure is called quite often it finishes a lot faster. why?
View 1 Replieshow to create a procedure?In VB6 it was through Insert Menu > Add Procedure.Also (just out of interest) is it possible to read from a database and copy the data in to an array?I've not used Visual Express for a while and have forgotten how to do theses.
View 6 RepliesI have been creating a little utility to generate random alpha-numeric username and password combos so I don't have to input this stuff by hand. A time saver. Whenever I clickbtnGenerate it generates a new set of random numbers, adds them where directed but only generates one ne set per click. I can't seem to figure out how to get it to loop the number of times I have typed into txttotal. So, if for example I needed 1000 uniqueusernames/passwords I'd like to, in the runtime, input "1000" into
View 2 RepliesI'm working on a project where an application requires to show 50 US state names. When User enters the abriviation in the text box, I want it to convert into Upper case. I made an attempt and coded like this:
strAbriviation = strAbriviation.ToUpper(txtAbriviation.Text)
but that didn't work !! it gives me that blue swigly line How do I fix this?
Private Sub btnDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim strAbriviation As String
[code]....
This code works fine when user enters Capital letters. It's just that i want it to work if user enters small letters.
Write a Visual Basic Console Application. Inside the main procedure call a function procedure to input and return a value for a double variable called x, the width of a right triangle. Inside the main procedure call the same function procedure a second time to get a value for a double variable called y, the height of a right triangle. From the main procedure call a function procedure which calculates and returns a value for the "hypotenuse" equal to the square root of (x squared + y squared). You will have to pass the values of x and y to this function procedure. The procedure should calculate and return a double type value. The value that is returned by this function procedure should be equal to the square root of (x squared + y squared). Also from the main procedure call a sub procedure to display the values of x, y, and the hypotenuse.
This is what I have so far..
Option Strict On
Option Explicit Off
Module Module1
[code]....
