My application has a variable VAR_1 that is boolean, this name is also stored in database.
Now I need to set VAR_1 value in my app by reading database and asign x value,
How do I call VAL_1 from a string?, this is:
Dim VAL_1 as boolean
Dim str as string = myTable.Rows(0).item("x") <--- Here's the name "VAL_1"
But I just can't find how to call VAL_1 by converting "VAL_1" to variable
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 RepliesWhat I need to do, is to call a SQL stored procedure from VB.NET, and then store the returned query value in a string.
View 13 RepliesI want to display a string (stored in a variable) in notepad(or any other default text editor depending upon the system). Saving to a text file is not necessary. I just want to open Notepad with an unsaved file containing the text. Please help
View 4 RepliesFor example, I have string variable (MyString) as below.MyString = "First word || second order || third example || fourth item || fifth stuff"
There are separator "||" at MyString variable. I want MyString variable is spited based on separator "||"and stored it into new array variable.
Could you advise me the most efficient code to do this job in VB?
This is probably a dumb question but I have to call one of 30 or so global variables by constructing the variable name to be called from another information. However when i do that it treats it as a string. Any ideas on how to make this work?eg something like this:
Public gsNewYork As String
public sub Getinfo
dim lslocation as string
[code].....
i need to call mdi form toolstripmenuitem name using the string variable. for ex, mdi form is Form1. toolstripmenuitem is customer master if i do like that "Form1.customer master.Enabled=True" its working
but my issue is i stored customer master in a string variable like mystring="customer master" i need to enabled using the string variable like Form1.mystring.enabled=True
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.
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'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 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]...........
I 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 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 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 need to refactor the method GetVendorBalanceDue to call stored procedure spVendorBalance in my database. I have created the stored procedure and am not sure how to get the method to call the stored procedure. Here is my code:
Private Function GetVendorBalanceDue(ByVal vendorID As Integer) As Decimal Implements InvoiceService.GetVendorBalanceDue
Dim selectCommand As New SqlCommand
[Code].....
I know that it's possible to Call a stored procedure from a Windows Application made in VS 2008. But, is it also possible to Create one? If so, isn't it possible for someone to create a SP that will delete all the data in a DB,when executed? Is there a real danger that someone could use an application that communicates with a DB to create such a procedure?
View 7 RepliesI need to call a stored proc from a .NET web page which takes around 15 min to process. We do not want user not to be able to browse the website in the meanwhile. Is calling it asynchronously the way to go or are there any other recommended ways?
make an asynchronous stored proc call?
I used the same lines of codes to call a SQL server store procedure to export sql data to an XML file:
1. If I call the stored procedure from a window form application, it works and generates the file at the designated location.
2. If I call the stored procedure from a window service application with a setup project, and the install process run well, and I started the service, and checked the event log, it showed the service start successfully, BUT it FAILED to generate the file at the destination folder. I also run everything as administrator, but it still failed to generate the file. It made me wonder if a window service can call a stored procedure. Because, again, mine ran fine with the window form appl, but window service, I would like to have your sample codes. I have googled around for 3 days now, but could not find the answer. I use vs 2008, sql server 2008, and Windows 7
I am trying to use the value of one variable to call another variable of the same name.I have 2 variable one called VAR1 and VAR2.
The variable VAR1 has a value of "VAR2"
The variable VAR2 has a value of "HELP"
I want to be able to get the value VAR2 from the variable VAR1 I have defined the value of VAR2 early in the code and now I want to call that value by using the value of VAR1.The reason I am doing it this way as I have a list of 50 variables that are pulled from one system. Each of these variables have the same name as the columns of a spreadsheet. The total number of Variable stay the same but the total column headers may vary each time. I need to loop through each of the column headers match them with the variable names and add the data to the spreadsheet.
VAR1 = "VAR2"
VAR2 = "HELP"
i =1
[code]....
This is the tricky bit...if the value of the cell(1,i) = "VAR2" How do I get it to display the value of the variable of the same name In this case how will I get it to display "HELP" when I only have from the VAR1 value "VAR2" I know my code will bring back the value as a string but I want it to bring back that string as a variable and display the value of that variable?
I have a combobox named cbEmpState, I need to call a stored procedure named 'spStateList' and have it fill the combobox. I'm having a hard time finding examples of this online. The stored procedure is in my dbml file.
Here's the stored procedure
ALTER PROC spStateList
AS
SELECT * FROM states ORDER BY StateName ASC
I am selecting a distinct user from IT_Cases_List and stored it in an arraystaff(). From this array, I will then call a Stored Procedure to count the no of cases attended by this user,(arraystaff(i)) and loop it until arraystaff.length-1
but the problem is that the count does not tally.
Sub getStaff(ByVal month As String)
If Not con.State = ConnectionState.Closed Then
con.Open()
[Code]....
ok, i've called only once getcases but i'm still having the same problem.
this is what i get when i run the program:
if i get Count(*) from the database, the total no of cases i should be getting is 132, whereas the total of cases i get from the program is 157 (7+7+20+20+49+49+5)
if i run the query from sql, this is what i should be getting
i notice that the Count number gets duplicated (7,7,20,20,49,49,5) instead of (7,20,49,5,10,27,13)
I'm new to LINQ and am having a problem getting proper results from a simple (working) stored procedure that takes no parameters and returns a single Integer. When calling this sproc with LINQ its returnvalue is always 0. When run using tableadapter or directly on the sql server it works, returning 6 digit values like 120123.
Here is my LINQ code:
Dim MeetingManager As New MeetingManagerDataContext
Dim MeetingID As Integer = MeetingManager.NewMeetingID().ReturnValue Here is the NewMeetingID procedure:
ALTER PROCEDURE [dbo].[NewMeetingID]
AS
SET NOCOUNT ON
BEGIN
[Code]...