Is 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 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.
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 connected to the Informix server using RazorSQL, created a stored procedure and tested it, getting the expected answer, so the procedure exists in the database in some form.
I then run the following code:
If ConnectToInformix() Then
Dim cmd As New IfxCommand("dc_routeHasOutstandingQuantity", conn)
cmd.CommandType = CommandType.StoredProcedure
[Code]....
This error does not occur when calling the stored procedure from a live SQL connection.
I am pretty new to VB and I am not sure why this is not working, basically I am trying to run a stored procedure from my web code. The sp runs just fine in SQL, I've tried it several times so I am sure that is not the problem. I don't want to return any results, I just want to see an "ok" statement if it runs and an error message if it doesn't. The code I am using for the lables (warnings and confirmation) is reused from earlier on the same page, the same goes for the validations (valUpload).
[Code]...
I've created an add-in for outlook 2010.I have a ribbon that has a button on it. When you click that button, I want it to call a procedure in the ThisAddIn.vb.There are two files: ThisAddin.vb and Ribbon.vb.I've tried several things to no avail. I've also set all the procedures to public.
Call Testing123()
Call ThisAddIn.Testing123()
Etc
How do I properly call this procedure?
****Ribbon1.vb****
Imports Microsoft.Office.Tools.Ribbon
Public Class MyOutlookTab[code].....
Using the visual part of VB I can create 'event' procedures. eg. if I double click on a button on the form it will take me to the code window and insert a procedure as follows:
[Code]...
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 RepliesI am trying to call the form_Keydown method from a procedure, CharacterJump()
Here is my
Keydown
frmGame_KeyDown(Nothing, New KeyEventArgs(Keys.Right))
What I am trying to do is after the user moves the character with the right arrow key and presses the up button to jump while still holding the right arrow key, the character will continue on moving, but the code that I put only does one movement and does not keep going.
Edit: I think I know the reason why it is only doing it once; it is because the keydown procedure is being called and therefore only executed once. The question is, how do I make it so it goes to keydown and doesn't return?
There 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 program where I want to call a procedure. The program allows users to enter a salary in to a text box, and than displays it in a label. I have everthing going fine expect getting the main function, which would be displaying the salary. Here is the code i already have:
[Code]...
im trying to search a value with the help of stored procedure But it is not working
Imports System.Data.SqlClient
Public Class frmStoredProcedure
Dim cn As SqlConnection
[code]....
I am calling this sub and it doesn't execute. The stored procedure is fine.
View 3 RepliesModule Module1
Sub Main()
here i want to call a sub-procedure----- CALL_ME()
end sub
And i have a windows form application with
Public Class Form1
public sub CALL_ME()[code]....
what would be the syntax of calling i tried randomly syntaxes ; but not working
I would love to use the following procedure to set the Title, keywords etc. of my pages, in a module.
Public Shared Sub SetTitle(ByVal Heading As String, ByVal Keywords As String())
Dim myMaster As Masterpage = DirectCast(Me.Master, Masterpage)
If Request.QueryString("lng") = "es" Then
[Code]....
The problem is that i get two errors.
At Me.Master i get the 'Me' is valid only within an instance method. error and at
If Request... i get the error
Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
So how do i fix these? I would like to have that procedure in a common place and not in every page.
(Using MVC4 VB EF4 MSSQL Razor)
I created a Stored Procedure in the MS SQL 2008 database. Then i've added that SP into the Entity Framework model (you do not see it after opening the .edmx file, i see the SP when i open the model browser). Next i did an "Add function import..." . I did [Get Column Information] and "Create new complex type".
So now i'd like to use that SP. And using ExecuteStoreQuery seems the way to go.
The best attemp so far is this:
Function Index() As ViewResult
Dim context As New MyEntities
Dim Result
[Code]....
In my asp.net project, I have two particular aspx pages (lets say PageA.aspx and PageB.aspx)
In the codebehind PageA.aspx.vb, I want to call "Sub GetDefaultValues()" which happens to be in PageB.aspx
Update:PageB.aspx has textbox controls that contain default values (which are being read in Sub GetDefaultValues). Those default values get populated into the textboxes of PageA.aspx (based on certain conditions)
Is there a way to do that?
i have an issue with scrolling a datagridview (VB.Net 2010) using the mouse wheel i created a mousewheel event an i am catching the mouse-wheel movement up or down i created a scroll event and set the boundaries for the scroll, but i have no idea how to combine both procedures:
Mouse wheel event Public Sub grdMouseWheel(ByVal sender As Object, ByVal e As MouseEventArgs)
Dim RowIndex As Integer = grdAccountTypes.CurrentRow.Index
If e.Delta < 0 Then
[code]....
I'm trying to update a table via a stored procedure from asp.net. I get the following error message: "wrong number or types of arguments in call to 'UPDATE_DIRECT_BILL_DETL_SP'"I just can't seem to figure out what is wrong. I believe I may not be using the correct Oracle variable types in my Cmd.Parameter.Add statements.[code]
View 3 RepliesSTORED PROCEDURE
ALTER Procedure [dbo].[usp_validatecard](
@CLUBCARD1 nvarchar(50),
@STATUS nvarchar(50))[code]....
What I am trying to do is if the clubcard parameter is found and status is active I would like the label to read 'card is good' also if the clubcard parameter is found however is inactive then the label should read 'card is good but not active' last if all those fail just have the label read 'card not in system'As of right now this code does not work I thought I could just call the stored procedure and exec it and it would print the statements depending on what passes however it is erroring out. When I debug it the error I get is under the cmd.parameters.add is
Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I have a slight problem, i have a Wages file, a File that is linked to other file. (Employees)
The user can Input the EmployyeeID and click the button, this will display that record with that ID.
When i save the PayFile, i want ONLY to save the Employye ID. When i come to search the PayFile, how could i get it so that it displays the Employee's ID without clicking the Search Employee button??
I am trying to obtain a value by calling a stored procedure I am trying to use the n tier design as opposed to the wizards. I am not sure how my function should look when it is called from the persistance class. I am using MYSQL for the database.
The persistance class works and the stored procedure works in the database.
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 RepliesThis problem has driven me mad for over a day now. I can create a connection to the database, I can execute sql and return results from that but I can't seem to call a stored Procedure. Here is the code
[Code]...
it works ok but no results are returned. I've verified that the procedure returns results for the user I'm logged in as. When the query was executing I could see a refcursor in there but it was empty. I must be going mad.
I'm developing this procedure using a timer object. The thing is the procedure is not in the timer's event procedure but I want it to depend on the timer's interval when executing, it's just not calling the timer procedure. How can u declare objects and use their event procedures in code.
View 2 RepliesCreating and Calling Stored Procedure in vb.net / MySQL
View 2 RepliesPublic Class stat
Dim WithEvents connection As SqlClient.SqlConnection
Dim connectionString As String
Dim da As SqlClient.SqlDataAdapter
Dim ds As New DataSet
[Code] ....
I am trying to fill the dataset by calling the stored procedure "top5_best_selling_products" but the connection is not closed so the error is with the adapter or something.
When calling a stored procedure from vb.net is there a default SQL timeout time if no timeout is specified in the connection string?I am unsure if there is a CommandTimeout specified in the connection string but am going through all the possibilites.
Example if no results after 30 seconds (or more) throw:
`System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.`SQL Profiler says that the script runs and ends in 30 seconds when the program timesout..Tthe script runs without error in about 1 minute 45 seconds by itself in SQL server.
i created a function procedure and i need to the action to be carried out when i click a button, but a don't know how to call the function procedure under the click event of the button control.
View 1 RepliesI have a Sub procedure (say: my_sub() ) in one of my aspx.vb (say: mypage.aspx.vb) pages and I want to call this Sub inside the Session_End event in the Global.asax page.
Somthing like this:
Sub Session_End(ByVal sender
As
Object,
ByVal e
[Code]....