i 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?
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 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?
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.
I can't find what I'm doing wrong. When I execute this code,
Dim dr As DataRowView = DirectCast(Me.LOTBindingSource.Current, DataRowView)
'Format variety Text
Dim drV As DataRow()
[code]....
I have problem with select case statement. When I click the button, nothing have happens.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim google As String
Select Case google
Case 0
[code]....
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 ?
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 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 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'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'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 RepliesI 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.
Number of downloads: 81This program is supposed to calculate the ever popular mortgage payment and amortize the loan in a list box. I keep throwing this error "Missing Member Exception" and can not find out how to fix it anywhere. Because of the error I can't even see if I can even get a calculation in the text box, let alone if the amortization will run. The purple text is where the exception is.
Public Class HarlessSmithIA3
Dim LoanAmt, Int, Result, Term As Double
Dim txtIntRate As New Object
Dim txtLoanAmount As New Object
Dim txtLoanTerm As New Object
Dim txtMonthlyPayment As New Object
[CODE]...
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
the FinalReleaseAnyComObject sub seems to be failing to do precisely what it is intended to which seems odd.
Code:
'Adapted From: http://www.xtremevbtalk.com/showthread.php?t=160433
'-------------------------------------------------------------------
Public oApp As Excel.Application
Public oWB As Excel.Workbook
[code]....
Exception Message: "Exception has been thrown by the target of an invocation."Inner Exception Message: "COM object that has been separated from its underlying RCW cannot be used."The exception is thrown when stepping to the next FinalReleaseAnyComObject within MySubFinal, not within FinalReleaseAnyComObject nor upon returning to MySubFinal from it. As noted in the code, if I bypass the sub and just in-line it then it completes without exception, which suits me fine. In testing I also noticed that if I comment out Worksheet_Change, i.e. declare WithEvents but no associated handler, then I also get no exception, but of course this entirely defeats the purpose and is unacceptable.
In case it matters or if anyone is willing to attempt to reproduce this, this is in the context of a COM Add-In where MySubInit is called from OnStartupComplete and MySubFinal is called from OnBeginShutdown. I am working with VB 2008 Express and Excel 2007.
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
I'm having problems trying to "bubble" up a custom exception I made... And I'm pretty new to custome exceptions, I was just told to use it this way and figure out the implementation. I have a custom exception class called "SystemIsBusyException"
[Code]....
have a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I need to use a SELECT statement to select all data under a column name (like all employee names) and then to add the values to a listbox.
I usderstand that the select statement must be:
"SELECT * FROM EmployeeTable WHERE EmployeeNames LIKE *" (at least I think)
but then what? combobox1.fill ("EmployeesTable") ?
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?