I'm using EPPlus 2.9.0.1 with Visual Basic.I have a DataTable with 35 Rows and 4 Columns and the code below:[code]When method 'LoadFromDataTable' is called, I get an ArgumentException (Negative row and Columns numbers are not allowed). I don't have negative numbers in row or column numbers, as far I know.
View 1 Replies
I'm trying to get the value of the third column of any row in a listbox, and this code works ONCE (It doesn't matter what column I select, I get the value), after that, and row I select has an Argument out of range exception. Here's the code:
[Code]...
i have about 20 possible exception messages that i want thrown when an error occurs.i need somthng like this when catching the exception
Try
' do domthing
Catch ex As CustomInvalidArgumentException
'do domthing
[code]....
do i have to create a class that inherits from Exception for each type of exception?
Public Class ABC
Public Sub Foo()
AA.Bar(nothing, Sub()
End Sub)
End Sub
End Class
I feel confused at the second argument of function AA.Bar, this argument is specified as a Sub/End Sub procedure.What is the function AA.Bar's possible definition looks like?An event? Delegate? Pointer like?...Where can I find the latest VB.NET Grammar Specification?What are the new features in VB.NET 4?
catch an exception and then throw another exception? Like so:
Try
' Do operation xxx
Catch ex As Exception
' Operation xxx failed, need to execute cleanup
[code]....
The reason for doing this is that while I catch my exception on a higher level logic (to make sure I can log it properly), I need to do some actions in the event of the exception that I can only do inside my class/function.
I have the following code:
[Code]...
I thought at first that because during testing GetFormsByStatus() returns 0 results maybe that was causing problems, but it doesn't make sense that Except() wouldn't work if the provided list had 0 items.
I have the following code:
Public Shared Function GetAvailableManufacturers() As List(Of Manufacturer)
'first get all the live orders and extract their mfrs'
Dim sos As List(Of OrderForm) = GetFormsByStatus(StockStatus.Building)
Dim unavailableMfrs As New List(Of Manufacturer)
[code]....
My idea to get available manufacturers was to get a list of all the manufacturers in my open forms, then get a list of all manufacturers and exclude all the manufacturers in the first list, illustrated like so (pseudo):
List A: {1,2,3,4,5,6,7,8,9,10}
List B: {5,7,10}
Result: {1,2,3,4,6,8,9}
I have set up my Manufacturer class according to this article so that it can be compared, but I'm still getting this error:
Unable to cast object of type '<ExceptIterator>d__92'1[csCore.Manufacturer]' to type 'System.Collections.Generic.List'1[csCore.Manufacturer]'.
I thought at first that because during testing GetFormsByStatus() returns 0 results maybe that was causing problems, but it doesn't make sense that Except() wouldn't work if the provided list had 0 items.
The following sub is throwing a"Object reference not set to an instance of an object."
exception.
For Each element As Song In modFiles.getSongs()
Dim col(2) As String
[code].....
I'm throwing an exception that looks like this...
View 3 RepliesI am getting an exception when running the following code.
Public Function getSongs() As Song()
' Dim dir As New DirectoryInfo(Application.ExecutablePath)
Dim dir As New DirectoryInfo(directory)
[Code].....
I get an uncaught exception that says:
"Object reference not set to an instance of an object."
The song object has a:
Public Sub new(By Val filename as String)
... sub that sets a variable and retrieves file info (this code works)
I have a problem with running CLR profiler. It throws an exception: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
[code]...
I started out with a console application but half way I switched to windows form in the application properties. Does that have something to do with it? I do this because I don't want to show the console. My application takes about 57 miliseconds to run. Maybe it's too fast for the clr profiler ?
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
I am having a weird problem. IIf is messing up when I am working with an array. Apparently it is checking my else statement even though it isn't activated. Here is some code that demonstrates the issue:[code]
View 2 RepliesI am trying to get the type of a class by calling Type.GetType(), however it is throwing an null reference exception. I'm supplying the fully qualified name of the class as a string, I'm not sure what I am doing wrong. Here is what I am doing:Type.GetType("The.Name.Space.TheClassName")That is the fully qualified name of the class, it works fine for import statements.
View 2 Repliesi did this Dim strUser As String = txtacno.Text cmd1 = New OleDbCommand("Select * from BookDetails Where AccountNo =@acno and MemberId=@memid", con)
[Code]...
the select query that i used in the above code,i have use and in it;so is this a valid sql statement?
I have written a small application perform CRUD operations on a Designations table. User search a Designation by Index and can make changes and the updates. I cannot see anything incorrect in my SQL and SQL works perfectly fine. Since i've created my Dataset using the desiner it automaticaly added the Optimistic concurrecy handling to the Dataset, therefore if an update fails it shold throw the DB conccurency exception.That's where the problem is, it doesnt throw the exception, application can retreive can update also fails to update on conccurency violation but when it happense it doesnt show the exception..... since code is long and have BLL and Presentations layers i've added a link you should be able downlaod the code + DB...
View 1 RepliesI am creating a simple mathematical game in VB.NET for kids!!the game checks for some simple calculations!!I am having the problem regarding the if else block in the codehere is my code
[code]...
I am getting an error "Operation is not allowed while object is closed". On this line of code "Do While myRecSet.EOF = False" here is all my code. First the module/function
Code:
Module Module1
Public coater As String
Public myQuery As String
Public myRecSet As New ADODB.Recordset
Public Conn As ADODB.Connection
[Code] .....
What do I use for the format number function to show a - for negative numbers instead of ()?
View 2 RepliesI am writing a parsing method for a csv record and want to throw an exception if the number of fields in the record do not match the expected length
View 3 RepliesI have a class as below in VB.NET. The issue is class calling itself. So vb.NET throwing Stock Overflow exception. But the same class is working fine in VB6 version of code in VB6.How to resolve this issue?
[code]...
I am trying to convert one of my unix text files to a dos text file. I am using the following command:
Shell(string.format("unix2dos {0}", sFileCompletePath))
I've already added the unix2dos command in my environment path on the server.But when I execute the above mentioned command I get a FileNotFound exception even when the file is located on the disk.
I have this
[Code]...
All that is happening above is two players are being compared by scores and a winner is then decided. The calculation works fine and places the winner in the correct spot (txtWinner1.Text) as long as the numbers are positive. So if txtU1D.Text has 13 and txtU2D.Text has 14...txtU2 is the winner. Works with no problems. However, if txtU1 has -1 and txtU2 has -2...it says txtU2 is the winner. The negative scores are common in the game being played so the situation often happens, but may be one player only. It seems to work if one is positive and one is negative, but if both are negative it thinks the higher negative number is the winner for some reason. So it will give the win to someone who has -9 over someone who is -4.
I'm doing a uni assignment and my application has to go to a specific folder and locate a file for data.The folder has 300+ files in it with a specific format for the naming of the files ie. the program goes to the folder looking for one specific file that has been derived from a different function and user input in the form.The program works fine when the file that it is searching for is there, but I keep getting a FileNotFoundException whenever the file that it's looking for is not there.I don't want the application to throw an exception every time the file doesn't exist because the program needs to return back to the loop to see if the next file is there or not.And so the loop continues until it's found all data and loaded it all into an array.How can I do a check of the folder to search for the file, and if it's not there, go to the next step without throwing an exception?
View 2 Repliesim dr As DataRow = CType(Me.ProductBindingSource.Current, DataRowView).Rowbut I get the error saying:
View 15 RepliesI have seen all over the internet to format a NEGATIVE double value with a parenthesis WITH a $ symbol ie. currency type.
I am looking for a .NET format string, to format
12345.67 = 12,345.67
-12345.67 = (12,345.67)
I have a program in which users are entering numbers into text boxes. I'm checking for proper data entry using a TRY-CATCH block. It works great and delivers an error message if the users enter anything non-numeric.
The problem is that now I need the users to enter negative values, but the TRY-CATCH is seeing the negative sign as non-numeric.
I get an Invalid Cast Exception - Conversion from string to double not allowed. I don't know what to do.
Option
Strict
On[code]......
I have written a program that generates and prints 10 random integers from -10 to 10, my problem is that I am returning both negative and positive numbers, aligned right with a pad of 2, but the negative is on the right hand side of my number instead of the left. here is my code, all work but I need to align the numbers and have the correct notation of negative.
[Code]...
I have this piece of
Private Sub FORNECEDORESBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FORNECEDORESBindingNavigatorSaveItem.Click[code]....
The idea is to detect if the cell of the first datagrid column is null and display the message. However, the code is not detecting the cell as null and the table adapter is throwing the OleDb exception.
