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'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:
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
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.
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..
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'.
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'.
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
i 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
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?
I 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.
Okay, 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?
What'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
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'm in the process of upgrading asp code to vb.net but there is a vbscript which is used to validate each user that I can not convert so I want to pass it a paramater and run it and then retrieve the boolean variable created. But I don't know how to run a vbs file.
I managed to open a program from the start>run (commandline) and pass parameters. I write "C:myprogram.exe" parameter1 parameter2 etc.. in my program I retrieve it using the enivroment.getcommandlines(). This works fine, however when I try the same command in a url I only get the the path "C:myprogram.exe" and not the parameters.
I am trying to create a DisplayAverage sub procedure that accepts 3 integer numbers as parameters. This procedure should find the average of these 3 numbers and display the numbers along with their average in the list box.
Private Sub btnAverage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAverage.Click Dim a As Integer = CInt(txtone.Text) Dim b As Integer = CInt(txtTwo.Text)[code].....
I would like to pass two values to a stored procedure. I am using a sqlreader to export data to an excel sheet. I need the user to be able to select a range, rather that the whole sql table. the code works fine without adding parameters, but I need the user to be able to select a range, rather that the whole table.
Dim data As String = "" sqlCon.Open() sqlCmd = New SqlCommand(strSQL, sqlCon)
I am trying to use the following query Dim sqlQry As String = "SELECT * FROM tblTest where Name=@NM and Rank=@RN"..Then I fill my dataadapter by Dim dAdt As New SqlDataAdapter(sqlQry, conStr) But do not know where to put the parameters that I have set after where clause.
I am trying to write a DLL that will take two parameters; a path and the text to write text to said path.
I want to be able to call this function from any other language that can be coded on windows, but nothing happens when I try to use this?
Public Class UTF16TextFile
Public Function UTF16TextFile(ByVal path As String, ByVal text As String) As String Dim fs As New IO.FileStream(path, IO.FileMode.Create) Dim sw As New IO.StreamWriter(fs, System.Text.Encoding.BigEndianUnicode) sw.WriteLine(text) sw.Close() fs.Close() End Function End Class
