Is there any max/min range of input for the first parameter of FormatNumber() function in VB.NET?As I am sending 99999999999999.99 (which is the maximum limit a column could hold in my sql database) to FormatNumber() it is returning 100,000,000,000,000.00.
View 4 RepliesIs there a .Net equivalent of the FormatNumber function?
View 5 RepliesI'm Trying to Call the Stored Procedure which has one input Parameter and one output parameter . VB.net code is below
[Code].....
Is 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 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 do a filename compare, sort of fuzzy match.Here's what code i have.First of all i load 2 directory's into 2 listbox's as strings and remove the filepath. Directory1
Code:
TextBox1.Text = FolderBrowserDialog1.SelectedPath
If TextBox1.Text = "" Then
Else
Then when i click the compare button i am trying to pass listbox1 and listbox2 through Distance and return the resulting fuzzy file matches.
Code:
Dim MyObject As New StringSift2
Dim ReturnVal As Single
ReturnVal = MyObject.Distance(ListBox1.SelectedItem, ListBox2.SelectedItem)
[code]....
But i get this error.
Code:
TreeView1.Nodes(lb1).Nodes.Add(ReturnVal.ToString())Specified argument was out of the range of valid values. Parameter name: index
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 RepliesMy text file lines look like this
------------------------------------------------------------------------------
AGILENT 3070 FIXTURE WIRING REPORT Sat Mar 07, 2009 06:43:05 PM
/var/hp3070/boards/Celestica/wbf303/fixture/wires
------------------------------------------------------------------------------
Fixture Type : Agilent SimPlate Express
[code]....
but this line Dim Iend As Integer = line.IndexOf(")", Istart) give me error
"Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: startIndex"
I'm trying to validate input boxes for numeric value and range value. If I validate for either numeric value OR range value there is no error (for example, comment out one of the validation statements), but if both statements are present and I enter "a" I get an error "Conversion from string "a" to type 'Double' is not valid." Can anyone tell me what I'm doing wrong?
[Code]...
I want to make a GetAllContacts method which takes a sort parameter of type Func(Of Contact, TKey) which is the same type that the OrderBy method for an IEnumerable(Of Contact) takes.[code]"Too many arguments to extension method 'Public Function ElementAtOrDefault(index As Integer) As Contact' defined in 'System.Linq.Enumerable'." on the second parameter.
View 2 RepliesI am facing a problem with FormatNumber functions as follows,
'default locale : Georgian
SetLocale("1033") 'changing the Locale to US
var1 = "1,2"
[code].....
I would like to create a form there I can enter three values (A,B,C)in textboxes and then submit these parameter to a program that run in a dos promt windows. Parameter A , B , C..Program.exe /A /B /C..It would be great if I can have a progress bar as well.
View 6 RepliesI have two user inputs (as textboxes) for two numbers I'm looking to check for all the prime numbers with the range of those two numbers and display them within a multiline textbox, however my code returns nothing but zeros, and I have seen easier ways to do it without functions but I am curious as to how to go about calculating primes within the function.[code]...
View 7 RepliesGetting error filling grid view from reading through data table:
Dim myDataTable As DataTable = myDataSet.Tables("SunTrust")
Dim myRow As DataRow
Dim i As Integer = 1
Try
[code]....
Error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
I am using Sub to format datagridview but during Form_Load this error occur. There are rows in datasource and dg.row.count is > 0.
.Columns(0).Width = 50 <==== ERROR HERE
.Columns(1).Width = 150
.Columns(2).Width = 80
.Columns(0).HeaderText = "ID"
[code].....
What im trying to do is send vars to a flash file.The following is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim oTitle As New ArrayList
Dim oSub As New ArrayList
Dim oRate As New ArrayList
[code]....
What I'm expecting the output to display is something like "t1=value&s1=value&r1=rate&t2=value&s2=value&r2=rat&t3=value&s3=value&r3=rat" But... i keep getting this exception: index was out of range. must be non negative and less than the size of the collection. Parameter name: INDEX.
I have a datagridview, with 3 columns, each containing dropdown filters (in the column header). Of the 3 columns, 2 are working perfectly fine, but whenever I try to filter the 3rd column, it gives me this error: (Also all of the column's have the ColumnType property set to: DataGridViewAutoFilterTextBoxColumn) "Index was out of range. Must be non-negative and less than size of the collection. Parameter name: index." The error points to the part that begins with "If dgv1.Rows(e.RowIndex)..."
Private Sub dgvWPS_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv1.CellFormatting
If e.ColumnIndex = 1 Then
[code]....
i am trying to get the value into the cur_stock where item_id = datagrdiview.curentcell.value.I am lookin out for the solution since couple of days, but couldnt figure it out.Well, m trying to make this work on CellMouse click event
Below is my vb.net code:
Private Sub DataGridView_stockout_CellMouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView_stockout.CellMouseClick
Dim i As Integer = Stock_checkDataSet1.Tables(0).Rows.Count - 1
[code]....
I am trying to create a form that allows users to input two numbers a high bound and a low bound then when you click the calculate button it determines all the primes within the range and displays those numbers within a multi-line text box. It seems I have everything working except how to display the prime numbers, the result from the following code displays nothing but zeros so I suspect that the range is not being saved somehow? I have asked this on other sites and people just give me completely different code or their own, can anyone help me with this specific code without changing the underlying code, I have a feeling I might be missing a variable or I am calling the function incorrectly.[code]
View 2 RepliesI have an Excel VBA function that takes a number of optional parameters, including an optional Range:
Function DazBeta(A As Range, Z As Range, _
B As Integer, _
Optional Freq As Integer = 1, _
Optional c As Double = 0, _
Optional r As Range, _
Optional Pct As Boolean = True, _
Optional Label As Integer = 1)
I am translating to VB.NET, and it's the optional Range that is giving me grief because VB.NET does allow optional Ranges. Or rather, optional parameters must provide a default value. What is the recommended way to change the VB.NET function signature so that the code is callable from an Excel cell as a UDF? (The VB.NET implements a UDF, the assembly is registered as a COM server, and the Excel spreadsheet is told of this server and type library, allowing the VB.NET code to be called from an Excel spreadsheet cell.) I have other compilation problems, so I have not been able to explore this. I am thinking that accepting an optional Object (default value Nothing) might work and then I could cast the Object to a Range. Alternatively, if there were a default value that could be specified with an optional Range, that would work, too.
I have an input parameter for my stored Proc, Instead of choosing available values from a drop Dwn, the customer wants an empty input box that when left blank returns all records. the parameter type is numeric(6,0) in the Db. I have not found a way to leave the input blank and retrieve all records. my default value for all records is '-99' and also is declared as the default value for the param in the proc.
View 1 RepliesI have the following code. I would like to perform a if then check via a button click before the user processes the information.
Private Sub TestBTN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TestBTN.Click
If TBSearch.Text = "" & ".exe" Or TBSearch.Text = "" & "" Or TBSearch.Text =
[Code].....
I would like it to just check to see if the text box info has been entered in one of three formats.
1)blah.blah
2)blah*.blah
3)blah*.*
Per this UserControl that can be added to a blank form, I would like to use the HorizUnits array below to map custom grid x coordinate from a mouse x position.For a given input value 13, what syntax would I use to obtain a value of 2 where 13 lies between Value 10 and 16 for which 2 (Name) would be the custom grid's displayed coordinate position?
View 1 RepliesThe following two statements seem the same to me but the first throws a design time error, and the second does not. The first one is passing the first parameter in hex and the second passes the first parameter as its decimal equivalent.
Public Shared ReadOnly Test As New Guid(&HCC58E280, &H8AA1, &H11D1, &HB3, &HF1, &H0, &HAA, &H0, &H37, &H61, &HC5)
Public Shared ReadOnly Test2 As New Guid(3428377216, &H8AA1, &H11D1, &HB3, &HF1, &H0, &HAA, &H0, &H37, &H61, &HC5)
Here is the error associated with the first statement:
Error 1 Overload resolution failed because no accessible 'New' can be called with these arguments: 'Public Sub New(a As Integer, b As Short, c As Short, d As Byte, e As Byte, f As Byte, g As Byte, h As Byte, i As Byte, j As Byte, k As Byte)': Constant expression not representable in type 'Short'. 'Public Sub New(a As UInteger, b As UShort, c As UShort, d As Byte, e As Byte, f As Byte, g As Byte, h As Byte, i As Byte, j As Byte, k As Byte)': Constant expression not representable in type 'UInteger'.
I have a statement:
dat.XoaNhanVien(Me.dtgcapnhatthongtin.CurrentRow.Cells(1).Value, message)
That is a function for deleting info. Now I want to create other function and get above function to parameter. I mean:
Public Function func(Byval func as " What type can be ?")
its just like that in other langauges (php in the example)
function myFunction($message,$sender="nodoby") {
return $message." by ".$sender;
}
i have one more issues, and hope is the last for now. How can I limit a textboxe's input to only numerical with certain range of values (eg -10 to 10) and with that happening while I type in the values?
View 9 RepliesI have a Sub with an array of strings as parameter:
Private Sub des(ByVal array() As String)
Dim i As Integer
For i = 0 To UBound(array)
[code]....
When I call the function inside my main function , the value of str changes even if the array is passed to the function Byval
Dim str() As String
str = {"11111", "22222", "33333", "44444", "5555", "66666"}
des(str)
I tried making a copy of the array in the Sub, but it still changes in the main function
Private Sub des(ByVal array() As String)
Dim i As Integer
Dim array2() As String
[code]....
I read on a site that you cannot pass arrays ByVal ,is this true? If so , how should I proceed?
How can i create a optional parameter in C# as we create in VB.Net
Public Sub Demo(ByVal a As Integer,Optional ByVal b as integer=3)
End Sub
I want to declare this in C#
[code].....
I am using visual basic and trying to create function. I am getting this error:
"Argument not specified for parameter '_IsDayRateCheckBox' of private function CalculateParikingCharges(_HoursDecimal As Decimal, _IsDayRateCheckBox As System.Windows.Forms.CheckBox) As Decimal'.
This is the code.
Private Function CalculateParkingCharges(ByVal _HoursDecimal As Decimal, ByVal _IsDayRateCheckBox As CheckBox) As Decimal
This is how I call the function.
Dim HoursDecimal As Decimal
Dim AmountOwedDecimal As Decimal
If Not Decimal.TryParse(HoursTextBox.Text, HoursDecimal) OrElse HoursDecimal < 0D Then
ErrorLabel.Visible = True
HoursTextBox.Focus()
[Code] .....