I have a sub procedure called ServiceCharge in the CheckingAccount Class now I am trying to call it from the CheckingAccountForm Class but its not cooperating Here is my code I put a bunch of and comments where I want to call the Sub Procedure
[Code]...
I am trying to call the below from another procedure in another class. The problem is that I am not passing the right parameters on (apparently). What value (and how) do I need to pass on as e?
Public Shared
Sub
DrawFarmFields(ByVal
sender As
[code]....
In my project I am using a LINQ to SQL class that contains a stored procedure which includes a string value as an output parameter.So to capture that, I created a string variable as follows in the procedure:Dim spOutput As String? However, when I do this I get the following message "Type 'String' must be a value type or a type argument constrained to 'Structure' in order to be used with 'Nullable' or nullable modifier '?'"
View 2 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.
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.
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 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?
If I have a class that inherits another class in which there are objects that are disposed in the dispose() procedure, do I use mybase.dispose? ex Class A inherits Class B. [code]
View 2 RepliesI want to call the "CheckedChanged" event for a Radio Button from within another sub procedure elsewhere in the program. The posts that seem to relate have me confused.
View 2 RepliesI am a newbie to vb.net and sql server. My responsibility is to build a vb.net function that when a scanner scans an object, it would take the scanned string and call a stored procedure to get a row of data that match that scanned string and pass the data row to an application that would print out a label.below is my vb.net and sql server stored procedure script
1. Do I have to come up with a public class in order to store my row of data to pass it on to a different vb.net application that would take that data row and print out a label?
2. In my stored procedure, how would I return the founded data row to the vb.net function?
Module makeLabel
Public Class AMGCdata
Public fileName As String[code]...........
Is it possible to call VB procedure in XML file? For the example
<destination id="destf" value="fill_destinations()" type="listmenu"></ destination>
So when my application read the XML file and reached to the id destf it should call call fill_destinations() which can bring the all destination list in listmenu?
I have a form which obtains data from text boxes and stores them in a file. If fields are missing, an error message is displayed. When information is stored, a message box asks if the user wants to enter another customer. However, that message appears whether or not information has been stored - I've used the following code. [code] Is there a way to not call the procedure if the error appears?
View 2 Repliesm getting an error while using Text1.SetFocus the error is invalid procedure call or argument
View 2 RepliesI am trying to call a stored procedure from a SQLExpress2005 data base on a Windows 2003 Domain Controller. I keep having errors when I run my code in debug mode.
Stored procedure name = InsertUsersFromAD
Server name where SQL resides = MIS631
Database Name = AdminGUI
[Code]...
I've tried making the Data Source = \MIS631SQLEXPRESS also, which didn't seem to work. I am trying to finish up a school project and this is the only thing not working.
way to create and initialize SqlParameters in VB.NET? Using 3 lines per variable seems quite excessive. Unfortunately the constructors for this class are rather ridiculous, so I'm thinking of just writing my own sub for initializing each parameter. This is how I've been doing it.
Dim ID As New SqlParameter("@ID", SqlDbType.Int)
ID.Value = val
query.Parameters.Add(ID)
[Code]....
I decided to get my head back into VB. My question is ; how to I correctly implement a Call procedure? I cannot seem to find a simple example through google.
for instance :
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim selectString As String = Nothing
[Code].....
I am extremly fresher in the above things. I want to create a store procedure in my programme and use it or call the store procedure. give me a standard sample code so that I can understandand.
View 4 RepliesI have an Excel workbook which I created a sub-routine to insert data from the selected worksheets to a Sql database with the Sql stored procedure. I tested the sp using the Sql Management Studio and it works fine. However when I tried to call that store procedure and it failed. [Code]
View 1 RepliesExcel call to Sql Stored Procedure
View 2 RepliesHow to call a stored procedure from sqlplus?
I have a procedure like ::
Create or replace procedure testproc(parameter1 in varachar2,parameter2 out varchar2)
begin
[Code]....
I need to create unit testing project for my current website. The currentw ebsite si written in VB. All unit testing examples are using interface to create mock object. My current VB class does not implment any interface. Can I add interface and implement it to my current class and functions without affecting or changing codes to any pages in my website that call the functions? For examples my current class is like:
[Code]...
Base class has one field to hold numeric balance value. With 2 methods that accept arguments for adding and subtracting the new input calculating new balance. Sub class has four fields dates, transaction, memo and amount.I have a deposit form, and withdraw form. Each time one transaction is entered it creates an object with sub class fields, then adds to the account collection. My problem is not understanding how to call the deposit/withdraw method and pass the current transaction amount back to the base class to alculate the new balance. Does anyone have any links to information/tutorials on how to perform something like this? As you can see with my code I have tried various different approaches without any success.
[Code]...
I want to be able to call a certain stored procedure based upon different criteria. May I do something like on lines 6 through 12 ? If so, am I properly creating my command object on line 3?
1 Dim connString As String = ConfigurationManager.ConnectionStrings("EMRConnectionString").ConnectionString
2 Dim conn As New SqlConnection(connString)
3 Dim sprocComm As New SqlCommand
[Code].....
in my SQL 2005 database I have defined this stored procedure:
CREATE PROCEDURE [dbo].[CheckOrders] (
@PK_Customer uniqueidentifier,
@Amount bigint OUTPUT)
[code]....
When I check the value of nAmount it stil contains the original value -1 the output value didn't return from the stored procedure although the number of records updated is 0 or more. The procedure was checked, it works and there are records updated and the value of @Amount is SET to a value 0 or more. I just don't get the values back. eventough the parameter @Amount is defined as OUTPUT. I also tried with outParam.Direction = Data.ParameterDirection.InputOutput instead of outParam.Direction = Data.ParameterDirection.Output . Same result. How do I get the value back from the stored procedure?
I've been trying to figure out how to call an Oracle 10g stored function and insert the return value into my VB.NET application. Stored procedures I've been already able to figure out, but I have no idea about functions.I have the parameter set to send to the function, the oracle function works perfect, but what VB coding to I need to get that return value. The return value is a CHAR.
Again the Oracle DB is in their 10g release.
My version of VB.NET Is Visual Studio 2010.
Also I've beent trying to use the Imports System.Data.OracleClient namespace but it comes up with an error saying its not available. Right now I use System.Data.OleDb. How can I import the oracleclient?
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 Replieshow can i call stored procedure named Insert in vb.net i just call a stored procedure named View the code is:
vb.net
dim Sqlcmd as sqlcommand
Sqlcmd.connection=Mydatabasename
Sqlcmd.commantext="MyStoredProcedurename"
Sqlcmd.commandtype=commandtype.StoredProcedure
[code]....
I am creating a front-end application for my company to track job details, customer appointments, upcoming appointments, and more. I had a developer create a back-end SQL database, which includes all of the corresponding stored procedures, such as insert, delete, update, detail, list.We are running SBS 2008, which includes Sharepoint for our internal website. So, I would like the final application to be hosted on our internal website.
I've talked to three different developers and all three had conflicting opinions regarding development. Where do I begin in the development of the application? Which template should be used? How are the stored procedures utilized? How can I create a button to call the stored procedure?
I am a beginner in Visual Basic programming. I am attempting to place a procedure in a module which I intend to Call from somewhere else in my application. The procedure below is almost exactlyhow it was on a form called PersonalInformationMy problem is that I get the error: "txtFirstName is not Declared. It may be inaccessible due to its protection level." I thought that maybe I was getting that errorbecause this procedure was not on the form that it was first written for.
Below is the code I am referring to-
dule
md_PersonalInformation
[code].....
This is a very basic newbie question, but I still haven't worked it out yet. I have a fair amount of code that I want carried out inside my Form1_Mousemove event, but I also want the exact same code inside the Form1_MoveClick event. I assume the best solution is to take all of the code and put it inside a seperate procedure and call it from both events? Or is it possible to call one of the events manually so inside my Mouseclick event, could I force a call to the Mousemove event?
View 20 Replies