in my app I use my sql commands with parameters. Now, I can't save the data in the database, because a parameter has an empty string value instead of a numeric value. And I want to know, which parameter it is. This command has 31 parameters.
My questions:
1. How can I loop through the parameters and print out it's values?
2. How can I print out the sql command with it's parameter values? (if it's possible).
Following code doesnt work and raise error "A parameter is missing. [ Parameter ordinal = 1 ]".What s wrong with it?I am developing pocket pc application in vs 2008 and sqlce 3.5 sp1.
[code]....
I'm Trying to Call the Stored Procedure which has one input Parameter and one output parameter . VB.net code is below
[Code].....
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 RepliesIs it possible to make a procedure have a single parameter but the values for that parameter are more than one? I have this procedure:
Public Sub autoComplete(ByVal cboCombo As ComboBox)
With cboCombo
.AutoCompleteMode = AutoCompleteMode.Append[code]....
Now I was wondering if there is a way to use it like this:
autoComplete(myCombobox1, myCombobox2, myCombobox3)
Or can I use a procedure like this with 'With...End With'?
I have a method which requires a parameter to be passed in. I would like to use the Addhandler to call the method through a dynamically created button control's click event.
When I include () in the AddressOf, VS complains: 'AddressOf' operand must be the name of a method (without parentheses).
When I exclude the brackets, VS complains: Method '...' does not have a signature compatible with delegate...
My code:
CODE:
One of the things that I think is really cool about VB.NET is how built-in functions and subs have extra help text in their ToolTips like "Expression: String expression to search for replace string." as well as the usual "Replace(...parameters...) as string" text. So are the pop up boxes with things like "CompareMethod.Binary" or "CompareMethod.Text." And finally I like how some functions and subs have different sets of parameters for the same routine. For example, New FileStream() starts with either a path (string) parameter or handle parameter, but none of the 15 sets of parameters contain both path and handle parameters. Is there a way that I can set up the classes and functions I write to use these things or do they only work with built in classes and functions? If there is a way, what are the proper names for them so I can look them up in the VS/VB documentation? I would be happy enough if someone would give me an example of them, but it would be nicer if I could go through the documentation and find out if there are other cool things that are related or near by.
View 3 Replieshave an idea on what i am doing wrong here:
Compiler Error Message: BC30455: Argument not specified for parameter 'dteRDate' of 'Public Sub New(strOName As String, strOAdd As String, intOPhone As Integer, strVer As String, dteRDate As Date, dteWDate As Date, strONote As String, strOrName As
[code].....
I have a vbscript that runs under asp page. I need convert the code to VB.NET
SET objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Application(DB)
With objCommand
[code]....
What is the VB.Net that will do exactly the vbscript does? I like paramer(0) and 1 and 2 etc since I don't need to define the parameter(0) as integer or varchar etc. I remembered I have discuss this before and it is possible to do in VB.NET?
where i put the *'s i get the error "The parameter 'address' cannot be an empty string. Parameter name: address".
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
Dim mail As New MailMessage()
Dim SmtpServer As New SmtpClient
[code].....
My query is this:
"SELECT TOP 5 * FROM [TableName] ORDER By NEWID()"
But I want to use a SQL Parameter so it could be something like this:
"SELECT TOP @ParameterName * FROM [TableName] ORDER By NEWID()"
The normal way dosen't work:
Ct.Command.CommandText = "SELECT TOP @ParameterName * FROM [TableName] ORDER By NEWID()"
Ct.Command.Parameters.AddWithValue("@ParameterName", SomeValue)
How can I add a Parameter in this situation?
Can anyone see what I am doing wrong here? the page should "YES This is a test"
Partial Public Class testForm1
Inherits System.Web.UI.Page
Private Property test() As String
Get
'if is in session, return it, otherwise look it up
[Code]...
When I execute this on MS ACCESS SQL window I have no problem I just enter the value of product_id_fk but when I run it on vb.net application I got No parameter value [Code]
View 10 RepliesI need to convert some code from c# to VB.NET from this page.
SafeFileHandle inputHandle = null;
SafeFileHandle outputHandle = null;
SafeFileHandle errorHandle = null;
[Code]...
I want use a continuewith with a sub that have a parameter.See my exemple:
Public Sub a()
Dim t1 As New System.Threading.Tasks.Task(AddressOf b, 10)
Dim t2 As System.Threading.Tasks.Task[code].....
One way or another I need to link groupID (and one other integer) to the button I am dynamically adding.
[Code]...
I have a report already setup on the ReportServer. And its subscription as well. What I'm trying to do is add the ParameterValue "CC" and some email addresses then send the email out. It doesn't seem to work.
My code:
Dim emailReader As SqlDataReader = selCount.ExecuteReader
Dim emailsTest As List(Of String) = New List(Of String)
[code].....
I want to add a parameter to my function but it is not force. Example : Public Function fct(Byval str as string,byval bol as boolean) End Function I want to when i call function, i can pass value for bol or not. it still ok. How can i do that.
View 2 RepliesI have an application in which I have inserted a DataGridView. I am populateing this DGV with a dataset created on design time. In this moment I have a question. Is it posible to add a parameter to this dataset?When I have populated the dgv, automatically was created the line of code: [code]In report is very simple to add parameters but here I cannot figure how to add a parameter.
View 3 RepliesHi. The assignment reads code the application using an idependent sub procedure to both calculate the display the bonus amount. Also use a sub procedure to clear the contents of the bous label when the text change event occurs. In addition code each texts box enter event procedure. When I call the calcbonus, it says argument is not specified for the parameter.
' Project name: Bonus Calculator Project
' Project purpose: Calculate a 10% bonus
' Created/revised by: Jessica Falcetta on 11/07/09
[code]....
Argument Not Specified For Parameter. [code]...
the error show to me in this line (( Adddata(TextBox1.Text, TextBox2.Text.ToString, TextBox3.Text.ToString, TextBox4.Text.ToString, TextBox5.Text.ToString) ))
I am currently working on a sample Invoice application. I have created a product class with a constructor and various methods and properties. In my form class I have added dim statements to create variables to hold my product objects and other various objects I have created.[code]....
View 4 RepliesI am new to web development and WCF. I am tasked to create a WCF application/service that can be accessed by other technologies as well. Thus I ended up with BasicHttpBinding. I will have a XML parameter. Here is my code:
<OperationContract()> _
<WebInvoke(Method:="POST", UriTemplate:="")> _
Function ReceiveMessage( _
[code].....
I have an issue with the VB IDE My project was working fine.I was adding some combo boxes and adding some code for the combo boxes to the form "iNet_MDI". I ran it in debug a few times to watch it and the next thing I know, I see "Key not Found Parameter name:key" in the Warning list. It says the Warning is on line 369 in iNet_MDI.Designer.vb.When I click on this message, it takes me to line 369 which is "Me.gb_RTO.Font = NewSystem.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular,System.Drawing.GraphicsUnit.Point, CType(0, Byte)I can comment this line out and the warning still exists and it still points to the same line.
I have tried to rebuild the project and clean the project.I have tried commenting out alot of the code, but nothing seems to clear this warning message. I can't get to the Design screen to try to remove any tools from the form. An error screen appears in place of the Designer I t gives me the option to "ignore and continue", which does not work.I see the Call Stack here on this page and it says:
at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value)
at
[code]....
I am getting an error when I write a value to the database. it tells me "Key cannot be null. Parameter name: key". However the key is an auto-increment value and i'm not even writing to that field. I have verified that there is a value being sent to the SQL. I also created a seperate program that writes the same SQL statement to the db and it writes just fine. I also have other places within the same program that write to the database without any problems.[code]
View 17 RepliesI am calling a crystal xi report from a windows form and passing 2 date parameters and a customer name. In some cases this customer name contains '&' eg Brown & Williams
In these cases my report fails and errors. if the name doesn't contain '&' it works. How can I pass the parameter with a & in it ?
i need to run a dos command with parameter and write out on text file from my win form
Dim a As String = Shell("D:docmd5.exe *.* > 'F:projectdocinfo.txt")
and
Dim a As String = Shell("D:docmd5.exe text.txt > 'F:projectdocinfo.txt")
but its not working i have vb 10
Dim Files As String() = Directory.GetFiles(StrTempFolderPath)
Dim Filename As String
Dim File_name As String = ""
[Code].....
I have a static sqlparameter default value which I need to display in a label but I can't get it to work. I tried:
lblDefaultRate.Text = SqlDataSource1.SelectParameters["rate"].ToString
but didn't work.
i'm having some problems here.i try to put in some data into sql server by using vb code. the data types are small integer and unsigned tinyint.i would like to assign the value as NULL instead of '0' because my reading takes 0 and 1.i tried in this way.
Dim Ignition As Integer = Nothing
Dim ADCCount1 As Integer = Nothing
Param = New SqlClient.SqlParameter("@Ignition", Ignition)[code].....
when i viewed my sql table i found that the Ignition and FuelRead1 show 0.previously i tried to set the value to NULL but it showed error.What should i assign the ignition and ADCCount1 so i will obtain NULL in database?