Is there any way to see what the values of the parameters are in an OleDbCommand after they have been assigned?I have a large one and I have an exception claiming that one of the parameters has not been assigned a value and I was wondering if there was an easy way to determine which.
View 3 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesDoing a program that requires 2 web forms, and the program stats "We have elongated the window so you can see that the order information was passed as a set of Request parameters appended to the URL." I have no idea how to append parameters to the URL.
View 4 RepliesHow would one go about sending parameters to the application? For example, I want to send my exe some switches or parameters.
my_app.exe -param1 -param2
Something like that. Then I can use the para1 and param2 throughout the exe Possible? But it is not command line, it is gui based.
I need to pass four parameters to a SQL statement and i'm using the following code. It works fine for the first parameter but ignores the rest without erroring.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conz As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
[Code].....
I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
I'm using Jmchillney's formless tray application and I want to pass some parameters into it using some other application I have. Then I want the formless tray application to do some work with these inputs. How can I pass into an executable parameters from another executable? I want to send some parameters from Application A to Application B. If app B doesn't exist I want it result in an error message the app A to display an error message. If app B does exist, it will do some work with the parameters and return a result back to app A and that's it.
View 26 RepliesDoObj(byval this as string, byval two as string, byval three as string) I'm trying to pass multiple parameters through a thread to this sub. I have tried this:
[Code]...
I have a custom Attribute class where the constructor takes one fixed parameter and two optional parameters. It is my understanding that one can supply one or more optional parameters by using 'named parameters' such as this:
Private Sub CallMethod()
Me.OptionalMethod(-1, z:=1)
End Sub
[code]....
Well, I thought, perhaps Attributes don't support named parameters. I know they can behave a little weird (they don't support all types in their arguments for example I think), so I thought little of it.But then... I noticed something else. If you take a look at my code of the attribute class again. Notice that I am using an attribute on that class as well... And what do you know: named parameters. Working just fine... The AttributeUsage attribute has the exact same configuration: one fixed parameter and two optional parameters. I seem to be able to call them using named parameters just fine, where I cannot call my own attribute constructor with named parameters...
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
My program uses parameters from the calling program in this format
parameter1/parameter2/parameter3
parameter2 is a datafile path which may sometimes have a space like :
C:Program Files est company
I did this as a work around
Sub Main(ByVal Args() As String)
dim cArgs as string=""
Dim J As Integer
For J = 0 To Args.Length - 1
cArgs = cArgs & " " & Args(J)
Next
And then used the string split function. Is there a proper way to work with spaces?
how to send a procedure call to a Command Button.
What I would like to do is have one button be able to call any number of other sub routines when needed. In other words...the app is running and I need it to stop so the user can either read information presented...or make choices...then click the CONTINUE button to pick up where the app left off. However, I need this to happen many times across several forms and modules.
I know I can use a MessageBox and get the same effect..
Basically Commands has Parameters and parameters has functions like Add, AddWithValue, and etc. In all tutorials i've seen, i usually noticed that they are using Add instead of AddWithValue.
[Code]...
since it saves my coding time. So which is better to use? Which is safe to use? Does it improves performance?
is there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
View 3 RepliesI'm using the following piece of
mports System.Data.OleDb
Public Class Login
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code]...
On the da.Fill(ds) line i'm getting the "No value given for one or more required parameters." I've pulling my hair for hours because I've similar working pieces of code on other applications.
I've got a project in c# which is making use of another project written in vb.net. I am currently able to modify both.I've got a method in the VB project like:
Public Sub MethodName(ByVal param1 As String, ByRef param2 As String)
param2 = param1 + 1
End Sub
I am not able to call this method using the out keyword from C#:
public void CallOtherMethod()
{
string param1 ="test";
string param2;
provider.AddTransaction(param1, out param2);
}
Shouldn't the ByRef keyword in VB.Net have the capabilities of both "ref" and "out"?
I have this function to retreive stuff from a database. I don't know how to send SQL parameters to the database from VB.NET in combination with using SqlDataAdapter instead of DataReader. Help?
Public Function GetCountriesTable(ByVal continent As String) As DataTable
''----------------------------------------------------------------------
'' TODO: Risking SQL injections here?
[code]....
The line "query" doesn't look good to me. Is this where I'm opening up for SQL injection attacks?
I am using searching grid view using control parameters but in my code i search only text but not integer values. So i want to search integer values using control parameters please give a code..
My code is :
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="GridviewwithHighlightedSearch.aspx.vb"
Inherits="GridviewwithHighlightedSearch" MasterPageFile="~/Default.master" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolderMain" runat="Server">
<style type="text/css">
[Code]...
problem with AddHandler with parameters.
i've create a control, here is the code:
Public Class myWorker
Public Event Complete()
[code].....
A fast-food vendor sells pizza slices ($1.75), fries ($2.00), and soft drinks ($1.25).Write a program to compute a customer�s bill.The program should request the quantity of each item ordered in a Sub procedure, calculate the total cost with a Function procedure, and use a Sub procedure to display an itemized bill. A sample output is shown in Fig. 5.26.Coded it out but when I try to break it down to separate functions I keep getting:
Error1Argument not specified for parameter 'CalculateFries' of 'Public Function CalculateTotal(CalculatePizza As Double, CalculateFries As Double, CalculateSoft As Double) As Double'.
Error1Argument not specified for parameter 'CalculatePizza' of 'Public Function CalculateTotal(CalculatePizza As Double, CalculateFries As Double, CalculateSoft As Double) As Double'.
[code].....
Here is the problem I'm working on.A fast-food vendor sells pizza slices ($1.75), fries ($2.00), and soft drinks ($1.25).Write a program to compute a customer�s bill. The program should request the quantity of each item ordered in a Sub procedure, calculate the total cost with a Function procedure, and use a Sub procedure to display an itemized bill. A sample output is shown in Fig. 5.26.Coded it out but when I try to break it down to separate functions I keep getting:
Error1Argument not specified for parameter 'CalculateFries' of 'Public Function CalculateTotal(CalculatePizza As Double, CalculateFries As Double, CalculateSoft As Double) As Double'.
[code]....
We know some functions in dll files and can use them but if we haw a dll file and dont know functions names. is there a way to get the functions name and their parameters
View 3 Repliesi want to get all available midi device by name. i found this: Declare Function midiOutGetID Lib "winmm.dll" (ByVal hMidiOUT As Integer, ByRef DeviceName As String) As Integer
but: how do i get these informations now?
I have a function that accepts a list as the parameter and creates a CSV from the passed list.Currently, the List parameter is of type String i.e.Public Function GenerateCSV(ByVal Source As List(Of String)) As String..My question is, is there a way I could modify the parameter such that it accepts a list of any known type i.e either string, integer etc instead of forcing it accept of type string as I have done above?
View 5 RepliesI need to get the customer name from the user as in combo box when the user selects the user I want that selected customer name should be searched in the sql table (here table name is "obbalance") and all the entries in the table having the name as the selected customer naem it should be shown in the data grid view
cmd.Parameters.Add(New SqlParameter("@p1", SqlDbType.NVarChar).Value = ComboBox1.SelectedItem.ToString)
cmd = New SqlCommand("select obbalance from balance where custname=@p1", con)
dr = cmd.ExecuteReader()
Form2.Show()
After this also it shows a error. It shows error in declaration.
If I want to use a FolderItem verb like 'Copy to folder', then I have to somehow supply the name of the folder to which I want the object copied. How is this done. I dont understand how msdn can be so minimal on examples.
View 5 RepliesOkay, I know how to launch a file with its associated app:Process.Start("File.mp3")And I know how to launch an executable: Process.Start("program.exe")This is the best I've been able to come up with for starting an executable with parameters:Process.Start("program.exe", "@ 'List of command line parameters'")Will that work?
View 2 RepliesWhat's wrong in here, I always get some nasty errors even if the same code that I used earlier works. But when I apply it to other form it gives me the error above.
here's my code:
Imports System.Data.OleDb
Public Class Updater2
Public adminID As String
[Code]....
I'm trying out something with my Access db and gets this recurring error message: "No value given for one or more required parameters", even though there is no parameter in my query. Here's my code (By the way I am using Northwind DB):
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
strSQL = "SELECT CompanyName FROM Customers"
Dim con As New OleDbConnection(strCon)
Dim cmd As New OleDbCommand(strSQL, con)
[Code] .....
I've been assigned to build a windows service that is capable of launching a proccess into the current interactive user, using VB.NET 2005.
After some research, i've built the following code:
Dim hToken As IntPtr = IntPtr.Zero
Dim LastW32Error As Integer
[code].....