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]...
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 RepliesI 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?
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.
This 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]....
this is the first time i am calling a stored procedure via vb.net and i would like to make sure i have everything correct before i execute it. This is my code:
[Code]...
The stored procedure returns 6 colums worth of data and i would like to add that data to a listview. I'm not sure i have the correct sytax for doing that but this is what i used in my previous sql code (running a query with, not a stored procedure). Also, i'm not sure how to go about getting data for the @xxx names above from a textbox? How do i pass the values into the @xxx names from the users textbox? The MS SQL mangement studio code is this for the the stored procedure:
[Code]...
I've got a conversion utility that basically copies values from one table to another. It's worked great for a while, but I've run into a strange issue with one customer. They got through 1.5 million records with the utility but now it is completely halted.When calling a stored procedure from VB.Net, it just hangs until the SqlCommand times out.Calling the same sproc from Management Studio executes instantly. My VB.Net code for the SqlCommand is below (insertConn is defined and opened earlier, dr is a SqlDataReader that has been populated in a previous step from completely different SqlConnection and SqlCommand instances):
Dim conn As New SqlConnection("connection string here")
Dim insertConn As New SqlConnection("connection string here")
Dim dr As SqlDataReader = Nothing
[code]......
I have been creating some asp.net sites that connect to an AS400 for data and I use a SQLDataSource for this with the following connection string (changed for security reasons). Now I need to create a winform application in VB.NET and am wondering how I would do this? I have only used MSSQL in winforms and use the sqldatareader for Select statements and execute non-query for others. I need to call some stored procedures on the AS400 passing parameters. I was hoping to do this by code like I do with MSSQL rather than drop in controls to bind to.
Provider=IBMDASQL.DataSource.1;Data Source=192.168.100.2;Password=xxxxx;User ID=xxxxx;Initial Catalog=S12345;Default Collection=AABBCC
I have a stored Procedure
CREATE PROCEDURE sp_DescriptionLookup
-- Add the parameters for the stored procedure here
@manfactureid as int
[Code].....