I'm trying to loop through and insert data into an excel template i have created. It works the first time, always the first time and never again after. All the values are correct and should work, I dont understand why it wont. Here is my code, there is an '>' beside the line that throws an error.
[Code]...
When I start to save only one record from collection, no error was found, but when I start to save more than 2 records in database table then it can save only the first record and it can not continue to save the second record.The exception was that:
InvalidOperationException was caught ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
[Code]...
What is the list of exceptions that CAN'T be caught in .NET? Or where can I find such a list?
View 6 RepliesI am converting an existing classic ASP website to (VB) MVC and I don't want any of the existing URLs to break. I have read many posts (like this one: Routing Classic ASP Requests To .NET - SEO Redirects) about how to do the proper 301 redirect. With the latest MVC release, I've gathered that
Response.RedirectPermanent(objRedirect.new_url, True)is all that is needed.
I have entered all of my old URLs in a database table with a corresponding column of the new URL. I have added code in my custom 404 page to get the original URL:
Dim strURL As String = Request.RawUrl.Substring(Request.RawUrl.IndexOf("aspxerrorpath=") + 15).ToLower()
so I can look it up in the database. (Interesting sidenote, MSDN's documentation here - Redirect Mode - seems to say that if I set RedirectMode=ResponseRewrite in the CustomErrors section of my web.config, I won't have to worry about doing the above, but when I've tried that, I get IIS errors saying it won't serve an ASP page?The problem I am encountering is that any of my old, Classic ASP URLs that have the same directory as a new MVC route are somehow being partially routed. For example, "/test/default.asp" shows up as "/test/test" in the above strURL variable of my error page.
[Code]...
Is it possible to catch the combined key presses of Ctrl-Alt-Delete so that event can be handled?
View 9 RepliesFor some reason the exception is caught sometimes it's not?Here is the code:
[code]...
I've tried to Google this problem, but haven't found any relevant results.I am trying to handle HTTP 500 errors when logging into a web service (the web service returns 500 when login is incorrect). An WebException is thrown, but I can't seem to catch it properly. The exception is highlighted in green instead of the normal yellow (having trouble finding info on this as well)
[Code]...
I have a form that is used at design-time to configure various properties. I've tried two ways to do a form-level catch all exception:
(1) I add a handler to Application.ThreadException in the constructor.
(2) I wrap the Show method, of the form, in a Try/Catch block
Both of these work at run-time when I test by adding a property grid to a form and set my component as the SelectedObject. However, at design-time the form simply closes with no message whatsoever; neither my message nor any message explaining that there is an unhandled exception. This is not about debugging at design-time. It's about how to present the user with a friendly message when my type editor encounters an unhandled exception.
I generate emails from my website to deliver order notifications to my customers.Some of these emails are treated as spam by spam filters. I've used MailingCheck to examine the emails and one of the problems contributing to it being identified as spam is:PRIORITY_NO-NAME Message has priority but no user agent nameIs there anyway within asp.net that I can resolve this problem? Presumably by somehow setting th
View 3 RepliesI am trying to read from a .dbf file in vb.net.This is my code.I am getting the following error.
OleDbException was caught: External table is not in the expected format.
Error in Detail:
System.Data.OleDb.OleDbException: External table is not in the expected format.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
[code]....
I am currently trying to send Email but am stuck with the GeneralFailure error caught with try and catch. I got the sample code somewhere off the internet last week and modified it when I have the chance.
The following is the code I am working on for now.
Private Sub btnSend_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSend.Click
Dim message As System.Net.Mail.MailMessage
Dim mailClient As New System.Net.Mail.SmtpClient("smtp.live.com", 25)
[CODE]...
Is there anything unnecessary, missing or am I on the wrong track? Right now I am trying to test send a mail from hotmail to gmail or another live account. Also, I have tried searching through the internet for a solution and some said I need to have IIS which I had it installed for it to work. Another said I need to add a reference but did not specify it. Those were pretty old messages though.
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If e.KeyChar = Chr(13) Then
[code].....
Preview Access SQL COMException 'm fairly new to VB.NET and I'm having difficulties performing a basic Access SQL statement.I'm trying to delete content the contents from the table but it keeps erroring out on me.
View 2 RepliesI've got a small problem that is nagging at me right now. I'm implementing a DataGridView to DataGridView drag and drop opperation. Here is the line that starts the Drag and Drop opperation:
dgvSource.DoDragDrop(New DataObject(dgvSource.SelectedRows.GetType.ToString, _
dgvSource.SelectedRows))
When I used the following code:[code]the workbook opens but I get the following error - Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
View 1 RepliesI'm working on an app that writes to excel. The following piece f code is working properly ( it fills the requested cell) but generating a run time exception that I can't get rid of.
[Code]...
I am trying to save an object (Class1) as string in a cell value. My issue is that from time to time I have a ComException:HRESULT: 0x8007000E (E_OUTOFMEMORY)(It is kind of random but I have not identified any particular pattern yet) when I write the value into a cell. Any ideas will be welcome
For illustration purposes:
Let Class1 be the class to be converted to an Xml string. (Notice that I removed the xml declaration at the start of the string to avoid having the preamble present- non printable
[code]....
I use the following code to access a VSS item:
Dim sItem As String = "$/MyVssProject/InexistentFile.txt"
Dim oItem As SourceSafeTypeLib.VSSItem = Nothing
Try
[Code]....
The problem I face is when I try to get an instance to a file that doesn't exist in the VSSDB, thus leading to a COMException, which basically wouldn't be of a problem (I would expect). In fact the exception occurs, but instead of proceeding with the catch code, the debug cursor stays on the line "oItem = m_oSourceSafe.VSSItem(sItem)", showing a dialog with title "COMException crossed a native/managed boundary.
From here the execution doesn't proceed, until I change the content of sItem to an existing file.
Why does the exception not get caught, and how can I achieve it?
Environment: VS2010 with .Net 2.0 on WinXP SP3 x86
I have done quite a bit of research on this issue and haven't came up with anything definitive yet. I am having issues with Excel randomly getting ComExceptions while writing out reports. I am using a Visual Basic 2005 (framework 2.0) console application to create these reports. The problem has been difficult to figure out because it occurs in random places while writing out reports so I can't catch the error to see the problem. I have looked through the differing items that it breaks on and there is nothing odd about them that would cause any of these problems.
[Code]...
I have a problem with a Com Object. The object open a file for each instance and when the files open reach 20, the program raise a ComException saying that there are too many files open. I'd changed the config.sys and the config.nt to Files=120 but the exception still is raised.
View 1 RepliesI am just trying to run an application on another machine than I created it and I get this error - COMException (0x80040154). I think it needs more files, but I copied the source, where could I find the other files necessary for it? [Code]
View 5 RepliesI have a component that I have built that includes a webbrowser control. I don't know if that is important, so I mention it anyway.
When I put the control into my form everything is fine,however, when I debug the application I get the following cryptic message:
COMException crossed a native/managed boundary
Error HRESULT_FAIL has been returned from a call to a COM component.
Private m_MouseOverListBox As Boolean = False
I'm getting a COMException was unhandled (class not registered) error on this line of
VB.NET
ADOXcatalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "/clubs/" & txtClubName.Text & "/data.adf;Jet OLEDB:Database Password=password")
This is the imports and references i have:
VB.NET
Option Explicit On
Option Strict On
Imports System.IO
Imports System
[code]....
Along with Microsoft ActiveX Data objects library 6.0 and Microsfot ADO Ext 6.0 for DLL and Security. It was all working fine, and I moved my entire project folder across from one PC to another. Both windows 7, and had no external references.
Basically I am trying to check for the file's existence, if not, open a template file and do a save as to a file name?However, I am stuck with the error in the title of this post at the openning of the template file line "oBook = oExcel.Workbooks.Open("X:dataOTEMPLATE.xlsx"). Below are some relavent lines in my code:
If File.Exists(str_filetemplate) Then ' Check for template file before moving on
oExcel = CreateObject("Excel.Application")
If File.Exists(str_fileoutput) Then ' The output file already exist, do what I need to do
[code]....
I'm trying to confirm if an Excel worksheet exists. However, doing so results in a COMException error.
For i = 0 To myWorkBook.Worksheets.Count
If myWorkBook.Worksheets.Item(i).name = "NewSheet" Then
iNewSheetCount += 1
End If
[code]....
I am trying to read text from an image. I have been trying to use OCR from MODI but I keep getting an error. Here is the simplest version of code (I've tried several)
Dim miDoc As MODI.Document
miDoc = New MODI.Document
miDoc.Create("C:document1.bmp")
miDoc.OCR()
miDoc = Nothing
As far as I can tell, my program gets stuck every time it gets to:
miDoc = New MODI.Document
it tells me a COMException was unhandled
I am using vb in vb.net, and I have a reference to the COM "Microsoft Office Document Imaging 12.0 Type Library". Every thing I have tried seems to come up with the same error.
I install this application done by MS VisualBasic2008 when i install this application on other
desktop, they pop out this error when i run the program, wheareas when i install in my own
workstation and run the program it can open up the program.
how to solve this problem?[CODE...]
I can't seem to find a thing on what this exception code indicates on Google or MSDN, and it's occurring intermittently and without a pattern I can discern.The failure seems to occur on the final line here:
Dim olApp As New Outlook.Application
Dim olNS As Outlook.NameSpace = olApp.GetNamespace("MAPI")
Dim olMail As Outlook.MailItem = olApp.CreateItem(Outlook.OlItemType.olMailItem)
When I run the following code, I get the exception below:
''# NOTE: ExcelApp is a Private main form variable
Dim ReportBooks As Excel.Workbooks = ExcelApp.Workbooks
Dim ReportBook As Excel.Workbook = ReportBooks.Open(localFilename)
[code].....
My Windows Forms app collects data from user input and mathematical calculation and outputs a set of results to an Excel spreadsheet.
Here's my code (for convenience, I've included only the code that seems relevant to the problem):
Dim exc As New Excel.Application
Dim book As Excel.Workbook
Dim sheet As Excel.Worksheet
[Code]....