I am working with existing VB.NET code for a Windows Application that uses StreamWriter and Serializer to output an XML document of transaction data. Code below. Private TransactionFile As ProjectSchema.TransactionFile
Dim Serializer As New Xml.Serialization.XmlSerializer(GetType(ProjectSchema.TransactionFile))
Dim Writer As TextWriter
[code].....
I have a situation where data in a field contains CrLf characters. Code has been in place for a couple of years and many records have been affected.Should I add code to catch the CrLf characters at the field level?Should I add code to catch and possibly correct the data before it is uploaded to SQL?Should I modify the upload to catch CrLf characters and possibly correct the data in the upload procedure?Whichever approach is more appropriate, how do I identify CrLf characters and then correct it.
View 6 RepliesI want to know that do you still need to rollback your transaction if you haven't commit the transaction that was created earlier.
[Code]...
I output a text field with CrLf to an xml file and the textbox shows everything in just one line in the win app.
View 4 RepliesI get this error at the Commit of a transaction in a desktop application:
This OleDbTransaction has completed; it is no longer usable.
Other posts I have seen with similar error suggests this can occur if it takes a long time, or contains large amounts of data. This is not the case here.Logging tells me it takes 140 ms from Begin to Commit and about 10 commands executed inside the transaction.It is using an Oracle database.This class is a simplified version of my database class:
Class MyDatabase
Private mConnection AS OleDbConnection
Private mTransaction AS OleDbTransaction
[code]....
Is it not allowed to run a select inside a transaction like this? Or can it be done by running the transaction in a specific isolation level (I see that the BeginTransaction method has an optional parameter for doing this) ? ..Or some other sollution..? In my case, it was not a problem to move the select to run before the transaction started, but what if you need to run selects that must run inside the transaction?
I've seen plenty of examples of transactions in the actual store procedure's SQL. But I'm wanting to do the transaction and keep track of it in code. I tried this but it says that my insertcommand's transaction object is null. How can I fix this?
vb Dim conn As SqlConnection = DBConnections.SQLServerConnection
conn.Open()
Dim params(1) As SqlParameter
[CODE]....
What is this kind of exception?
Error : Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The transaction property of the command has not been initialized..
This one causes the error: Dim oOperation As COperationOutputTypeBS
oOperation = COperationOutputTypeBS.GetOperationOutputType(txtOperationCode.Text)
how would I accomplish saving a large piece of data, using the Stream Reader for the Line-by-Line, while keeping the carriage return line feeds in there?
[Code]...
Below is my code for DELETE button. What i want is if the user select the transaction from the listview and press the DELETE button it must be able to delete the transaction from listview and text file(temporary log file) which i keep all the transaction record. At the same time the list view must able show the total current balance from the deleted trnsaction.
[Code]...
How to Implement transaction in function for an XML file?
View 2 RepliesI want to add from vb.net a file into a clob column in oracle 9.6.1 (8 mb). When i add the file within a transaction then it goes much longer (10x longer) then when i add it whitout transaction. Why i have to wait so long with transaction object?
Here i have prepared an example code. the first code is without transaction and the second code with transaction. The first code is much faster then the second.
I have the problem only when i want to add the file in a clob column. When i want to add it in a blob column, then i don't have any problem.[code]...
I am explaining an issue that I have faced in my SSIS Package today. A script task reads a string from particular position in a feed file which is basically Transaction amount. I am providing the psuedo code below to explain the issue
[Code]...
I have a program in VB.Net that receives mails from Outlook, extracts attachments and inserts the attachments into a table through a query. I would like to put the query/queries in a Try/Catch block, but cannot do so as Outlook exceptions cannot be caught, and it gives me an error, and unless I put a very specific exception, I cannot catch it. Is there a workaround?
Edit:
Try
Catch ex As Exception
End Try
Exception is underlined and when I hover on it, it says: "Catch cannot catch type 'Microsoft.Office.Interop.Outlook.Exception' because it is not in 'System.Exception' or a class that inherits from 'System.Exception'". This is affecting all my other code which I'd like to put into a Try/Catch block.
The following code causes a "Warning" that Variable is used before value assigned.How do I restructure this Try/catch to eliminate error on the myreader.close command in the Catch part? Code appears to work fine but I dont like Warnings. [code]
View 8 Repliesi have problem when i click a ADD button, there is one null value in the textbox .. so the try catch statemnt is to catch that null value error but after that the catch is success but the button click never stop excute the statemnt till the end of the button event.
View 6 RepliesI have this scenario: in a Sub I have a Try...Catch statement.Within that Try..Catch I call another sub.In that 2nd sub is also a Try...Catch.(see below for example).Now if an exception occurs in the 2nd sub's Try...Catch, which Catch gets excecuted? The 2nd one, the 1st one or both?
Private Sub sub1()
Try
..do stuff[code].....
If I throw an exception from within a catch, does the finally (from the catch) still execute? i.e.
Try
..some code with an exception in it...
catch ex as Exception
throw new SpecialException("blah blah" & ex.Message, ex)
[code]....
I need to catch log4net exceptions (its own exceptions not app exceptions logged by it). I wish there's a way of doing it this way: [code] I have this code implemented and there's no errors in compilation but i force log4net to have an error (pointing to a non existing database in the config file) and nothing is threw.I've tried the listener aproach: [code] and it's writing the errors to log4net.txt, the forced ones i mean.This last aproach has a couple of drawbacks: it won't append every error to the file, if the error is the same it doesn't write it, i can't get the listener to write every error to that file, only one (I don't know how to fully configure the trace listener, it might be that). Thus it won't append the date and hour to every line wich is a necesity for me. Finally i can't give structure to it (xml). Even if the listener work i need to use the try/catch aproach, since i'm using ExceptionHandling from Enterprise library to log the errors in my app.
View 1 RepliesIf I paste code snippets, or debug.print text with CrLF line ends, to the Immediate Window they line ends are ignored and the text appears as one long string. This is very annoying behaviour on the Immediate Windows part. How do persuade the Immediate Window to honor line ends?
View 3 RepliesI m trying to read a text file, make some changes and write to another file.[code]...
View 1 RepliesHow to remove the last crlf code below?
Dim fh As StreamReader
Dim temp as string
Dim temp1 as string
[code]....
I have a window app written in VB 2008. I would like to find the first occurance of CRLF from a string.
I tried the following codes and none of them is working.
str="Things found wrong: Cover on left side of engine leaking.
Starter mounting gasket leaking.
Left hoist cylinder leaking.
[Code]....
How can I parse out undesireable characters from a collection of data?I am working with existing VB.NET code for a Windows Application that uses StreamWriter and Serializer to output an XML document of transaction data. Code below.
Private TransactionFile As ProjectSchema.TransactionFile
Dim Serializer As New Xml.Serialization.XmlSerializer(GetType (ProjectSchema.TransactionFile))
Dim Writer As TextWriter
Dim FilePath As String
Writer = New StreamWriter(FilePath)
[Code]...
Because TransactionFile cannot be converted to String I get a "Conversion from type 'Transaction' to type 'String' is not valid" message.Bottom Line = How can I replace CRLF with a space when it shows up in TransactionFile data?
I have a multi line text box that accepts Enter and tab as input, but this data needs to be saved without these characters. When the user loads this data, the text should be displayed as it was originally entered.In PHP, there is a function to replace line breaks and tab characters with and , and with \. I need a similar function here.
View 13 Replieshow to proper split a string by crlf below is the code:
Dim str As String = "Hello" & vbCrLf & "World"
Dim parts As String() = str.Split(ControlChars.CrLf.ToCharArray)
For Each part As String In parts
[Code]....
I want to get rid the blank space in between the two.
Say my program has an assocciated file extention of ".abc". When the user double clicks / opens the file, my program would open, but how would I tell the program to read from that specific file?
View 4 RepliesIf I set the Text property of a RTB to a string that has CrLf's in it, it seems the RTB reduces the CrLf's to a single character & screws up the positioning to set the SelectionStart property.So, for example, if I know the position of a character in the original string & I set the Selection Start value to that position, the selection highlighting will be off by 1 character if the start position is preceded by a CrLf & off by 2 characters if preceded by 2 CrLf's, etc.So how can I determine the correct position to specify my SelectionStart value?
View 2 Replieswhat is best way to assign CRLF hotkey to button? In delphi it can be set to default one, but how its done in VB ?
View 1 RepliesI am using VB.NET 2005 to create a Windows forms application. I have a procedure named SendMail that creates an instance of Outlook.Application, to send an email from my application. I found the code on this forum, I think.The procedure works fine, but I can't use error handling with it.I call the procedure from a button click event. I put the procedure call in a try/catch block, and the application won't build, with the following error.
Error 68 'Catch' cannot catch type 'Microsoft.Office.Interop.Outlook.Exception' because it is not 'System.Exception' or a class that inherits from 'System.Exception'. C:datadevdmtiQTSQTSv7_1_20100212wQTSQTSReportsCriteria
pt_frmReportViewer.vb 43 21 QTS
Here is the code:
Sub SendMail(ByVal sFile As String)
' Create an Outlook application.
Dim oApp As Outlook._Application
[code]....
About catch webbrowser input file path.[code]How can i catch the file path into TextBox after i browse the file? such as C:UsersTestDesktopabc.jpg
View 1 Replies