Sql - Passing Parameters To A Stored Proc Accepting In Parameter Of Type XML Type?
Jun 7, 2011I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
[code].....
ADVERTISEMENT
Sql - Passing Parameters To A StoredProc Accepting In Parameter Of XML Type?
Apr 8, 2010I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
i have to pass 4 parameters to this proc how to do this?
i am passing param as db.Parameters("p1", Oracle.DataAccess.Client.OracleDbType.Varchar2, _
' LN.Length, CObj(LN), Data.ParameterDirection.Input)
[code]....
Create A Function Which Have Either 1 Parameter With A String As Data Type Or 2 Parameters With Double As Data Type?
Jun 11, 2012I need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesParameters Data Type - Add Parameter With Same Data Type As Column Data Type
Feb 26, 2012For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
Exec Stored Proc With Parameter
Jun 17, 2011I'm having troble getting my code to recognize the parameter for my Stored Procedure.This code below show how I select my files (commented out all other files to make sure one works first)It selects my files through the OpenFileDialog box, it loads the name & location of the csv file into memory and then I want to run a SP to import the csv into my database. I have set the SP up ok as it works through SSMS. [code]
View 8 RepliesC# - Reading A Stored Proc Not Working When Passing Values
Oct 7, 2009Why is this not working for me? What is wrong with my code below? I am trying to read a stored proc and applying values to labels. Getting error that say "Incorrect syntax near CareerInner".........
Private Sub LoadData()
' Define data objects
Dim conn As SqlConnection
[Code]......
Passing Parameter (Value Or Referenced Type) Into Method?
Nov 11, 2009What happened when parameter passing. Here is a test project I write.
Public Class Form1
'1.test string
Private Sub btnString_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnString.Click
Dim str1 As String = "x"
[Code] .....
From the project you can see, when pass integer type parameter (value type) into a method , if use ByVal keyword, the value won't change. If use ByRef keyword, the value will change (I can understand it, to my understanding, when using ByVal, It pass the value of the argument to the method; when using BvRef, it pass the address of the argument to the method, so the value can be rewrite)
Well, for the following two scenarios , I can't understand why.
String type is reference type, but it acts like integer type.
Val type is also reference type, but no matter what you use(ByVal or ByRef), the result will be the same.
So my question is what actually passed into method? What's the underlying mechanism about pass parameter? What's the effect of ByRef and ByVal to value type and reference type?
Erroring When Passing Oracle Parameter Type PLSQLAssociativeArray
Jan 3, 2012I have a oracle stored procedure that looks like:
[Code]...
String - 'Public Function' Has No Type Parameters And So Cannot Have Type Arguments
Mar 12, 2012I am having some issue here, and I am not too sure how to handle it. If you could lead me in the right direction
[Code]....
VB Allows The Type Parameters To Be Used As The Base Class For The Generic Type?
Mar 30, 20101) VB Allows non-type template parameters2) VB supports explicit specialization 3) VB allows the type parameters to be used as the base class for the generic type4) VB allows a generic type parameter itself to to be a generic 5) VB enforces that all codes are valid for all types of parametrs
View 1 RepliesConvert String Value To Type And Pass As Type Parameter.
Nov 19, 2010i am getting all filenames from a directory.parsing out the directory names & the .vb extension then converting those filesnames to classes.Every file in the LPCriteria direcotry is its own class with a "Evaluate" function.[code]
View 1 RepliesC# - Object With A Value Type And Reference Type Be Stored In .NET?
Oct 5, 2010In .NET, integer data type is a value type(stack) and String is a reference type(heap). So If a class A has an integer, and a string type object in it, and a class B creates an object of class A, then how will this object of class A be stored in memory? In stack, or in a heap? This was asked in my Microsoft interview. Need to understand how I fared.
View 3 RepliesPassing Parameters To A Stored Procedure?
Oct 12, 2009I am confused about how to pass parameters to a stored procedure. The stored procedure is written in sql server 2005 and the code is in vb.net.
I have included the sub that I am working on. I know that my use of parameters is wrong.
Public Sub AddRecipe()
Using myDBconnection As New SqlConnection(setConnstring)
Using SQLcmd As New SqlCommand()
[Code]....
Passing Parameter From To Stored Procedure?
Aug 12, 2010Can't seem to figure out why this is not working.
Dim Myspcmd As New SqlCommand("spDataImport", myConnection)
Myspcmd.CommandType = CommandType.StoredProcedure
Myspcmd.Parameters.Add(New SqlParameter("@FileName", Data.SqlDbType.NVarChar, 100)).Direction = ParameterDirection.Input
Myspcmd.Parameters("@FileName").Value = "Import_File.dtsx"
myConnection.Open()
[Code]...
VS 2008 Pointer - Error32'System.Reflection.Pointer' Has No Type Parameters And So Cannot Have Type Arguments
Jul 15, 2010I have an open source project I converted to vb.net. I solved all the errors, except for one. This is the C# line
[Code]....
VS 2010 Passing Parameter To Stored Procedure With SqlCommand?
May 2, 2012VB Imports System.Data.SqlClient Public Class frmMain
[Code]...
I have three ways of adding parameters to my query commented out above. The all seem to return 1781 records (which is all of the records) and will not filter out to what the UserName variable equals which should reduce it to 32 rows.
I use a Console.WriteLine to show that the UserName is indeed my username. But it seems to not be getting passed to the query properly. I tested the Stored Procedure before even starting in on the program, so I know it functions properly. I just don't know what I'm missing from a VB.NET perspective to get the same results into my DataTable.
VS 2008 Template Function That Can Receive Different Parameter And A Type Parameter
Mar 9, 2011I want to have a "template" function that can receive different parameter and a type parameter, like:[code]But Vb told me that tupeList is not defined... is there a way I can do that?
View 2 RepliesVB Allows Non-type Template Parameters
Mar 30, 20101) VB Allows non-type template parameters
2) VB supports explicit specialization
3) VB allows the type parameters to be used as the base class for the generic type
4) VB allows a generic type parameter itself to to be a generic
5) VB enforces that all codes are valid for all types of parametrs what would be the Best Choice ?
Asp.net - Why Does Ms Sql Stored Proc Only Return An Integer
Nov 4, 2010I am using vs2008 making an asp.net.vb app. The following stored procedure resolutely insists on returning an integer. I on the other hand was hoping for, and expecting, a single name to be returned. Can anyone help amend the sp or describe what I need to do to get the result I desire.
ALTER PROCEDURE [dbo].[getusername]
(
@email varchar ,
@retvalue nvarchar (10)output
[code]...
Updating A Stored Proc Programatically?
Oct 6, 2008Has anyone updated a proc in code, outside of SSMS? It's easy enough to change the stuff after the ALTER statement, but what I can't figure out how to change the comments before it.
View 17 RepliesUsing Stored Proc For Insert Command?
Mar 12, 2009first of, here's what i'm using.
Visual Basic 2005 Express Edition
Oracle Database 10g Express Edition
i created a procedure stored in the oracle database create_user and accepts a few parameters...
procedure create_user
( p_user_num out tbl_users.user_num%type
,p_username in tbl_users.username%type
[Code].....
so i run the form, click the AddNew button in the BindingNavigator, enter the data in the textboxes and then click Save. i receive no error but the values of the textboxes are not being passed to my stored procedure. it is creating records but all columns are null.
i checked this by using an SQL Editor to query the table back-end.
Passing A Type As An Argument?
Aug 12, 2010I'm using VB.NET 2003 with .NET Framework v1.1. I know it's getting a bit old now but I'm stuck with an existing program and don't have the time/knowhow to convert it to anything newer.
My question would probably be solved very easily with Generics in .NET 2.0 but as I can't use that right now, I'd like to know if the following is possible:
I have a load of manager classes which inherit from DictionaryBase and hold collections of my custom classes. For example, I have a Employee class, a Batch class, a Supplier class, etc... and each of these has a Manager classwhich holds a collection of them - eg: my PlantTrayMgr class holds collections of PlantTrays, etc..
I have one particular form where I have to populate loads of comboboxes with the contents of various Manager objects. What I currently do in my form load event to populate comboboxes is this:
Code:
Option Strict On
Option Explicit On
Private _plantTrayMgr As PlantTrayMgr
[Code].....
Can Qualify Type Of A Parameter
Apr 8, 2009This is kind of two questions (one more specific than the other).If I have a method like this:[code]Can I qualify Foo against another type (for instance can I require that Foo be a String that also implements IInterface?).I'm imagining something vaguely similar to this:[code]Additionally, is there any way to qualify the Type parameter?For instance, can I require that the Type I take as a parameter is of a particular class tree?I should mention that I am using this in the context of a property of an attribute so the class declaration itself cannot be generic (this is purely focused on qualifying a method parameter rather than typing a class and its methods).
View 3 RepliesDeclare Many Parameters Are Array Type In Function?
Dec 10, 2009Public Function manyarrays(ByVal ParamArray ints() As Integer,ByVal strs() As String) End Function But it is error . How can i fix it ?
View 3 RepliesStored Proc As Aspx Datagrid Source?
Dec 7, 2010Currently I have the following in default.aspx
View 6 RepliesVS 2008 Call SQL Stored Proc Asynchronously?
Jun 9, 2011I 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?
C# - Where The 'Type' Of A Reference Value Is Stored In Memory?
May 10, 2011As the reference values are stored in the heap as a data; where do the type information of any reference value is stored?If there are a couple of instances of class Artist; when they are stored in the heap how the .Net tags those memory blocks as type of Artist?
View 3 RepliesVS 2008 Action(Of T) Not Accepting More Than One Parameter?
Aug 4, 2009I can't get this to work..
vb.net
Private Sub UpdateLVItems(ByVal Index() As String)
lvDrives.Items.Add(Index(1))
lvDrives.Items.Item(Index(0)).SubItems.Add(Index(2))
lvDrives.Items.Item(Index(0)).Tag = Index(1)
End Sub
[Code]...
ByRef Parameter With Type Conversion
Mar 19, 2012I did create a XDateTime class that is able to handle inaccurate date and time. This class has all the CType operators required to convert to and from a string and it has been fully tested during the last months.
[Code]...
Create A New Instance Of A Type Given As Parameter?
Mar 7, 2010I've searched for an answer and found some c#-examples, but could not get this running in vb.net:
I thought of something like the following[code]...
I know, I can create a new instance with the Activator.Create... methods, but how to create an array of this type or just declare a new variable?