Is it possible to write the procedure (Private Sub hello() for ex.) in somewhere else, like in another file, and call it like we usually do?
I just don't want my main Form.vb to be filled with lots of codes, I want it to call procedures and run them
In VB.NET I've got two forms, on first one I have button, on second - two textboxes and "OK" button. I want to run procedure (Sub) on first form, then stop in the middle of it and wait for input on the second form. After that i want to process the data received from second form.
It looks something like this:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Open form2 for input
[CODE]...
The question is how to call the Form2 so that procedure is stoped till the second form is closed?
The code below is what I have in one form. Login_prompt is the name of the other form.In this code snippet I am displaying another form that prompts the user for a username and password.I then want to open the website and auto populate the fields. The populating is not the problem.I cannot seem to call on the other form's sub procedure correctly.
View 3 RepliesThere are 2 forms open for the user in a school attendance program. The 1st. form is called FormBrowseClasses and the other form is called FormBrowseGrades. On the 2nd form is a procedure called PopulateTheDataGridWithData. That procedure loads data into a DataGrid.We would like to call PopulateTheDataGridWithData from within FormBrowseGrades so the data in the DataGrid will be refreshed.
We already tried:
' Refresh DataGrid data on FormBrowseClasses
'-------------------------------------------
objFormBrowseClasses.PopulateTheDataGridWithData()
but this only runs on a new instance of the form, not the currently open form. how to set this up correctly?
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]....
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]......
I have a stored procedure that clears student accounts to showed that they have paid their bills. I am trying to create a form in vb.net that allows them to enter a parameter and then execute the stored procedure.
View 9 RepliesI am triggering a stored procedure from code inside a form and I am wanting to return any TSQL errors back to the form. I have written code to do it but when I force an error in TSQL for testing, my vb.net code drops to debug mode with "SQL Exception was unhandled" error.
[Code]...
I try to run a custom sub procedure from the form load event. It keeps crashing. I believe it is because all of the controls are not loaded and the sub procedure makes use of some controls. How can I make sure everything is loaded before the sub procedure is run?
View 10 RepliesThe 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 Repliesmy problem is that i have an MDI Parent form. it has lots of child forms. on my MDI Form i have the toolbar buttons Add, Delete and Save.all or most of the child forms, i created a custom public procedure Sub AddNew, Sub Delete and Sub Save.what i'm trying to do is when i click the AddNew in the MDI Form, it will run the custom public Sub AddNew of the currently ActiveMDIForm. i have tried...
DirectCast(Me.ActiveMdiChild, Form2.AddNew()
but i'm getting an error "Unable to cast object of type 'Form1' to type 'Form2'" if the currently ActiveMDIChild is not Form2.
[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 ie[code]...
View 14 RepliesI am in need of being able to show a user the contents of a Oracle stored procedure. I have no idea of how to go about actually getting and then displaying the code contained in a stored procedure. Does anyone know of a way? I know how to call and execute a stored procedure but is about it. I am developing using VB.NET 2010 with Oracle 10G as my back end.
View 3 RepliesMy main form is a tabbed control with 2 tabs. The first tab is has two listview controls which display information about the current machine. The second tab contains a treeview control and two listview controls. This tab recreates the device manager in windows. I created a Machine class to gather the information about the machine that I want to display to the user. When I call the Display() Method from my form's load event everything appears to be fine the first tab's information is displayed in the listview controls.
Here's the kicker, when I click to the device manager tab there's nothing there. The LoadTree() procedure never fires. This code works, I've seen my device tree display a thousand times in the past. When I comment out the call to Machine.Display() my device tree reappears no problem. The code compiles fine no errors. I know the problem has to be in my Machine class but I have no idea what could cause this kind of response. I've never seen a program compile clean and then refuse to fire a procedure call but not produce some kind of runtime error.
I have an ArrayList that is set to Friend. Once I click my button "abc" is added to the ArrayList and then the form MsgBoxes out the Count of 1 (Correct).When I use Threadpool to count the number of objects within the ArrayList it always returns 0.
Example:
Imports System.Threading
Public Class Form1
Friend Alphabet As New ArrayList
[code]....
I am obviously getting some sort of cross-thread issue here but have no idea how to correct this. I usually just setup single threads so this is my first time playing with ThreadPool & already lost at step 1!
on a new project - windows form app i would like to bring a simple stored procedure from a server ( with credentials ) with one parameter.
the stored procedure is on the : "SERVER" "database" "sa" "sa" and it looks like this:
sql
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[Code]....
also if i could select the client name from a drop down list would be verry nice. the select for the name is : "select name from clients"
The results could be exported into excel or a screen. ( after selecting the client in the form , another button for export )
I am developing a complicated search form, and I would like to know best method of passing search criteria to stored procedures.Possible options that I know are, 1) Create sql statements in Visual Basic and send statements to SP as strings to execute2) Pass search fields to stored procedure and build command in SP (Stored procedure) in database?
View 9 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]...
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]...
I am trying have a data grid selection populate a form. I am new to this.Basically I have a connection persistance object and I would like to call that and call a stored procedure with the value of the selection. The datagrid is bound to an object.
[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 have a Visual Basic form with a public sub procedure called xecute_Public_User_Defined_Sub_Procedure.I tried to call the sub procedure from the "ParentForm" below but could not.
Dim ParentForm As Form = CurrentTextBox.Parent
If ParentForm IsNot Nothing Then
ParentForm.Execute_Public_User_Defined_Sub_Procedure()
[code].....
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.