Way To Retry A Statement That Threw An Exception?
Feb 23, 2009I usually do something like this:
Dim Attempts = 0
Try
Retry:
[code].....
I usually do something like this:
Dim Attempts = 0
Try
Retry:
[code].....
I usually do something like this:
Dim Attempts = 0
Try
Retry:
<Block>
Catch
[Code]...
This is really bad looking for me, but i don't know of a better way of doing it.
I'm currently working on trying to improve the amount and quality of exception handling I do in my code and one thing that I am trying to figure out how to do is retry a method if it fails.
The an example of the circumstances when I would want to do this is for SqlExceptions. One of our clients has a poor network that means that occasionally connecting to SQL Server times out, but if we try again immediately afterwards it will work perfectly.While I could possibly call the method from itself, I would rather not do that just in case there is a permanent error and then we'll get into a infinite loop, which is not what we want.
I was wondering whether anyone has any advice on how may be a good way of going about dealing with problems like this.[cod]e...
Catch exception handing in .Net easy could it be to add an Ignore, Retry, Cancel when an exception is caught? Or how do we implement something like it?
View 8 RepliesWe have just converted a large VB6 desktop app to VB.NET 2008. First via the VB 2005 (open project), then days of fixing errors, etc. Then opened the VB 2005 in VB 2008 so now it is a 2008 solution.The more we try to test the worse it gets. It did start and crash with typical errors but now it does not even get off the ground.[code]The more we try to fix the earlier it crashes. The 1st form load does not even start (break point not stopped on but it did before and failed on AppFrameWorkOn = True where AppFramWorkOn is just a boolean in another module.Except same code works in other programs.We have written several dozen other VB.Net 2005 programs but this one just doesn't make sense.There is also no Configuration Manager in the Build menu.
View 11 RepliesWe have just converted a large VB6 desktop app to VB.NET 2008. First via the VB 2005 (opened the project), then days of fixing errors, etc. Then opened the VB 2005 in VB 2008 so now it is a 2008 solution. There are about 30 forms with code behind and about 40 other modules.
Message InvalidOperationException was unhandled.
... The type initializer for .... threw an error.
on
[code].....
The Type Initializer for <Module> threw an exception?What does this error mean.
View 11 RepliesWe have a VB .Net windows application developed with VS 2005, framework 2.0.
The executable when run on a different machine throws the above error. It cannot be caught with the IDE due none of the developers experiencing it.
I have project which is implemented in VB.Net using VS 2008. I install build on Win 7 64 bit machine an see a splash screen after which it thorws exception saying "The type initializer '<class name>'for threw an exception". The class is NotInheritable and the method which I'm trying to access is shared. The same project works fine on win 7 32 bit machine. The build is also compiled using x86.
View 2 RepliesI am creating a medium/largish program in VB Express 2008. To keep it more simple i have created each section of the program in individual projects/solutions and then when they all work well, copy the code from each project into one Big project. Everything was fine, but when i put the global variables all together in 1 module, i get the following error:'The type initializer for 'WindowsApplication1.Module1' threw an exception.' This appears everytime a line of code is ran that reads/writes to a var in the module.
View 2 RepliesI just make one login SQL form and one module global variables. This is the code in module
Imports System
Imports System.IO
Imports System.Text
Imports System.Data
Imports System.Data.SqlClient
Module globalVAR
[Code] .....
Ok, so I'm making a small system that deals with route making. Effectively all I'm trying to do is open the connection to my SQL database at the moment and this error turns up.
The data it says is the problem is:
{System.Collections.ListDictionaryInternal}
[code]......
I've been writing an application, and all has been going smoothly; I tried to debug my application, after many previous debugging sessions and from nowhere, I received an error. I've not changed the module in which the error is coming from, but I can't narrow the error down either.
Here's the error: The type initializer for 'HG520b.MHProgramming' threw an exception.
This occurs any time I attempt to debug my application and linked to a function, property or enum which resides in my module.I don't know where to start looking for this error seen as it's all random...
I am having trouble deploying a dll to a Windows 7 machine. The app works fine on my Vista machine.
The dll is RAPI2.DLL The target machine encounters an exception when the object is instanciated:
System.TypeInitializationException: The type initializer for 'System.Devices.RemoteDeviceManager' threw an exception. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {35440327-1517-4B72-865E-3FFE8E97002F}
[Code]...
Is there something wrong with my connection string that I would get this exception thrown back at me from my code? I have the string saved in the code and when I try to create an SqlConnection I get the exception above thrown and below is my connection string which is actually the address to my DB file.
Connection = "Data Source=.SQLEXPRESS;AttachDbFilename= C:Documents and SettingsTTTMy DocumentsBASEO.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
an error throws up on the line:
con.open()
it says "The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception."
Private Sub BtnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnLoad.Click
Dim Con As New OleDb.OleDbConnection
Dim DbProvider As String
[code]....
I'm using express 2008 build the windows app. and in the app, it calls a webservice which was built by VS2003.It works fine on most PCs. however, there is one PC, it always shows this error:
System.TypeInitializationException: The type initializer for 'System.ServiceModel.ClientBase' 1' threw an exception
....
System.configuration.ConfigurationErrorException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException:
Unrecognized configuration section system.serviceModel
.....
however, the configuration file was generated by express 2008, and it seems there is no error.
I just created this program 2 weeks ago, and stop doing for two weeks... before, it perfectly run and has no errors on all of my instance variable that i declared, though in is not finish...
[Code]...
I encountered this exception when I trying to load a certain page. It doesn't show me which line of code has problem, which makes me kind of dizzy now..What is a type initializer? What is it used for? and how can I troubleshoot this problem?
View 1 RepliesI have this SQL Statement:
de.SqlStatement = "SELECT A.Name, A.Catagory , COUNT(Patient_ID) AS PNO FROM PatientApplyToAssociation P INNER JOIN Association A on A.Association_ID = P.Association_ID WHERE A.Catagory='" & "health" & " '" & "' GROUP BY A.Name '"
[code].....
I'd like to read from a file and if I fail, let the user retry or otherwise give up. So far the code looks like this:
Read_Again:
Try
my_stream.Read(buffer, 0, read_len)
[code].....
I am trying to pass a LIKE parameter to a SELECT statement but receive an that strSearch is an invalid field name error:
Private Sub Search()
Dim strSearch As String
strSearch = txtSearch.Text & "%"
[code]....
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?
When trying to use Try/Catch in my code the INSERT statement does not work, but when I comment out the Try/Catch it works fine with no error. The section of my code is below:
[Code]...
Please advise with any info you might have. I have the code below. Everything works ok until I try out the select case. When I do a retry the curser doesn't set back into the password textbox so that the user can try again.[code]
View 8 RepliesI am getting a Syntax Error in INSERT INTO Statement when trying to simply create and add a new row to the Customer table (tblCustomer). My code is as follows:[code]
View 3 RepliesI am using modal window for my VB.NET program and I am trying to open this child modal window from another window, after I close the child modal window I am trying to refresh the parent but I am getting retry/cancel popup, I tried a lot of things to avoid but I can't get rid of this popup.
View 1 RepliesIt is possible to catch an exception and throw a new exception which wraps the first exception as an inner exception: [URL] Also, if I call a function and it throws a certain error, but I catch it, will the calling code's catch handler execute? If so, and it is of a higher exception type, is this not wrapping the exception? eg I can throw exception ex of type IndexOutOfRange, log it but rethrow, catch a higher up exception and do something, or I can throw a new exception and wrap an inner exception like:
View 1 RepliesIm new to vb and mysqlHow can i make it where you type your username and password and it connects to my database hosted on my site and then if the user nameexists and password exisits it will login and if it doesn't it will get you a error message?
View 2 RepliesI need the picture boxes to switch threw the images and here is my code. Im using the imagelist to hold my 3 images so far (0-2)
[Code]...