I 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]....
I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
[code].....
What 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?
I 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 RepliesI have a oracle stored procedure that looks like:
[Code]...
I 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]...
I'm trying to implement a Web API project that exposes some models. However, the way the model is retrieved isn't very RESTful. 1.Instead of having just one ID, it has a combination of 4 different ones to populate the model data by running a stored proc on the server.Dim balance as New BalanceSheet(uid, mid, eid, fid)The snippet above will use uid, mid, eid, fid to retrieve the correct record from the database.
View 1 RepliesFor 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?
I am having some issues with a parameterized SQL Lite query. I can't seem to get the SQL Lite Parameter to accept the String value
Using cmd As SQLiteCommand = pConn.CreateCommand()
If tblLang = "en" Then
cmd.CommandText = "UPDATE [AT_Strings] SET [Data] = @tblData + 1 WHERE [RecordID] = @ID AND [language] = @tblLang1"
Dim tblData As New SQLiteParameter("@tblData")
[code]....
The error is as follows....Unable to cast object of type 'System.String' to type 'System.Data.SQLite.SQLiteParameter'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Data.SQLite.SQLiteParameter'.
Source Error:
Line 283: Dim ID As New SQLiteParameter("@ID")
Line 284: Dim tblLang1 As New SQLiteParameter("@tblLang1")
ERROR on Line 285...
Line 285: cmd.Parameters.Add(dataText)
I 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 RepliesI'm trying to learn VB and don't understand what is wrong with this code?
Private Sub ScoreRange(strStart as String, strStop As String)
Dim MyCell As Range
For Each MyCell In Range(strStart & ":" & strStop).Cells
[code]....
to solve my problem regarding dataset, crystal reports and exporting to pdf file? There are datas when i preview the crystal reports but when i export it to pdf viewer there's no data displayed. Here's my
DataOpen()
cmd.CommandText = "Select * From AllDTR Where BIOID = '" & myuser & "' AND Date > '08/31/2009' ORDER by Date"
[code].....
I have a form with 2 dateTimePickers and a SHOW button which gets data from an sql server database and displays it in a DataGridView. this works ok. I also have an EDIT button which brings up another form with textbox and comboBox controls displaying this one record. I want to be able to click in the DataGridView to select a Name and then click on the EDIT button to bring up the selected record. I don't know how to pass the ID as a parameter to this second form. Apart from that the EDIT button works, in the sense that I hard coded the ID (32 or 35 etc.) and it brings up the appropriate record. But how do i pass the selected ID. [Code]
View 2 RepliesI have a DataSet1.xsd This is connected to my access DB through OleDB. the DataSet Designer is stating that my column in my table is of type Double. Which is true when I verify it by opening Access and viewing that same column in my table.
I need to pass a parameter to my fill query so that on formload it populates the controls. I create the parameter in the dataset designer and give the paramter a name and specify the proper data type.
I edit the query to include the parameter.
on form load the generated code from the dataset designer inserts the fill command for the table adapter but doesn't include the parameter data, so I manually insert the data to be passed to the parameter.. This is where I get an error stating that datatype mismatched..
However the datatypes are correct.
[code]This works fine and passes 8 parameters into the sysimp.bat file. The problem is if I try to pass in a value that has a space between the text then it will treat it as two parameters rater than one.So if P1 value is for example "Hello World" then when passed into the bat file it will assign "Hello" to P1 & "World" to P2. Is there a way to wrap the text in the parameters or should this be done in the .bat file?
View 9 RepliesI designed a form simply holding a combo box, button & Datagrid, working well when executed from another erp application.Now i would like to get parameters from the application and pass on to the form. The parameter has to replace the value of Combobox value.
View 3 RepliesI need to call a function in an unmanaged .dll written in C lang from vb.net. The function declaration looks like this [code]Now the behavior of this function is that it copies some data in argument "reply" and returns a numeric value which signals its pass/fail status. How do i pass it a string object so that it can copy data. Following is how i access this function.[code]When the call completes, returned status is absolutely fine but there is nothing in string "str". What is it that i am missing. I'm not sure about the string object that i am passing as argument.
View 3 RepliesI need to call a function in an unmanaged .dll written in C lang from vb.net. The function declaration looks like thisLONG _stdcall ReadInfo(char *reply);Now the behavior of this function is that it copies some data in argument "reply" and returns a numeric value which signals its pass/fail status. How do i pass it a string object so that it can copy data.Following is how i access this function.
View 2 RepliesI 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]....
I would like to know if it is better to pass a listbox for control to a module with SQL stored procedure or to use the List(of ) function.
example:
in the form class---
SQLModule.getPartSearch(txtGroupID.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim(),
[Code].....
the code i have is working fine to pass one parameter to crystal,
Imports System.Windows.Forms
Imports System.Data.SqlClient
Imports OEE_NEW.Module1
[code]....
I'm a beginner in VB.NET programming.. Please help me on how to pass SQLParameters in the below function..
This my code:
[Code]...
i want to populate a crystal report based off a selected phone number, but i'm not sure how to pass the phone number to the report. I've tried the following, but other than that i'm lost:
' Dim pField As New CrystalDecisions.Shared.ParameterField()
'Dim disVal As New CrystalDecisions.Shared.ParameterDiscreteValue()
'Dim pFields As New CrystalDecisions.Shared.ParameterFields()
[Code]......
I 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]....
I have this code
Code:
Public Function ExecuteDataReaderSP( _
ByVal storedProcedureName As String, _
ByVal ParamArray arrParam() As SqlParameter) As SqlDataReader[code]....
I try various ways to pass the parameters, every time it return a different error.How is the correct way to pass those parameters?
I need to convert the following C# code to VB.NET:
public bool TryGetRewriteMatch(UrlContext url, out RedirectMatch match)
{
// NOTE: Normally this would use regular expression matches, cached database
[Code].....
However, I need to reference Url and ProductID in the function and I don't know how to pass them as parameters or get their values from the original function.
I have a situation where I need to programatically pass paramaters using VB through to my crystal report. I am using Visual Studio 2008 for my development.
Everything is working fine, but when I run the report I get a "Value cannot be Null" error. this is in the Crystal Reports Rorm Viewer.
My complete code is below.
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Data.OleDb
[Code]....
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
I have a stored procedure with two input and one output parameters. I need to execute the stored procedure from VB 2008 code passing it two parameters and returning the output parameter. How might I go about doing this? I don't have how to do this. Newbie here.
View 1 RepliesI need to write a VB.Net Winform application that is called through Windows' context menu in Explorer and can take multiple parameters, where the final parameter is the full path to a file with spaces in it. I tried the following as parameters, to no avail:
[Code]...