I came accross TransactionScope as I try to resolve an issue bothering on the use of Transactions on Typed DataSets. But when I tried to implement it, my intellisence does not recognise it. I have to Import System. Transaction. TransactionScope but it is not recognised. How do I use it cos it seems like it holds some clues to my problem?Only performance counts!
View 5 RepliesI'm currently working on a legacy project in VB.NET 2.0.The project has a very funny DAL-layer which does not incorporate transactions :-|Anyway, it's my job to make some parts of the program transactional and I don'thave access to the DAL layer code.So I'm trying to put entire sections of code inside single TransactionScope.
View 1 RepliesI have the following routine:
[code]...
Running this against both our production and test Oracle 11g database sporadically (or if there is a pattern, I haven't found it yet) generates the Oracle Error:ORA-02049: timeout: distributed transaction waiting for lock Since this is the only process running against the test database, there shouldn't be any issue with different users competing for a lock.
I have some VB.NET code that creates a TransactionScope instance:
LoggingUtility.LogDebug("UpdateCallTable", "SatComCallDataImporter", "About to associate call data with contracts")
Using ts = New TransactionScope()
LoggingUtility.LogDebug("UpdateCallTable", "SatComCallDataImporter", "Getting all unimported SatCom calls")
My application is throwing an exception on the call to the creation of a new TransactionScope, with "Object reference not set to an instance of an object.". The exception isn't thrown on my development machine or my test machine; only on the customers production machine, and I have no idea why. I've placed debug lines immediately before and after this line so I'm positive it is this line causing the problem.
A have used TransactionScopes throughout the application and this is the only place throwing the exception on the client machine."About to associate call data with contracts" gets written to the log and the next log entry is the "Object reference not set to an instance of an object".
Code works fine if I move it out of a transaction.I've been struggling with this for 4 days now and have got no closer.
I'm encountering a hang when the program tries to access the fruit database. I've already enabled network access MSDTC on both my development computer and the SQL Server server.
[Code]...
I use Microsoft ODBC For Oracle, and process a distributed transaction with ransactionScope, but, the code throws a error: ERROR [HYC00][ORACLE][ODBC]option not implement, my code is in vb.net.ere is my code:
sub Main()
dim strConn1 as string = "Driver={Microsoft ODBC for Oracle};Server=server1;UID=user1;PWD=pwd1;"
[code].....
Does the database connection have to be set inside a TransactionScope?
Or can I set it in the ctor and then have instance methods create up a TransactionScope?
EDIT: e.g.
Public Sub New()
Dim conn = new SqlConnection(...connection string)
Public Sub SomeClassMethod()
[Code].....
the question is do you need to create the connection to the database after you've created a TransactionScope or can it be done before?
I have trouble using the transactionscope on SQLite, i am using the following code. Changes are still commited to the database while i don't call the ts.Complete() function.
Using ts As New System.Transactions.TransactionScope()
Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()
' Do your individual saves here'
[Code].....
I'm trying to incorporate TransactionScope into my code and am failing at the first hurdle. I am unable to open a connection inside TransactionScope block. I get exception Connection Not Open.
Public Sub PerformDBWork()
Dim cnA As New OleDbConnection(My.Settings.DB_CONN_BUSINESS)
Try
cnA.Open()
[code].....
My cnA.Open() fires as expected but my call to cnBusinessDB.Open() fails.
Is there a vb.net equivelant of the #If thingy in C#? Like this (works a bit like # region #end region):
[Code]...
I have a simple Windows Service that reads from an Excel spreadsheet and imports the records into a SQL Server 2000 database table. Before it loads it checks if the file has been successfully imported before (using filename) and whether any of the records in the file have been imported before (using primary key). If these checks are ok I load the records into a datatable and then update the datatable to the database.
However, I need to do this in a transaction as I want to ignore the whole file if there is an error. The file goes to a discarded folder and the user gets an email with why the import failed. (This is likely to be because the store the record is for is not yet added to the database and the referential intergrity of the db fails). If there is no transaction the records before the failure record are imported. When the file is imported again (the store has been added to store table) the file is then rejected because duplicate records are already in the db.
Heres my code:
[CODE]...
Is there a VB equivalent to C#'s Program.cs?
View 1 RepliesIm trying to make a simple program which changes the files properties and was wondering how i would make this
@echo off
title File Changer
:menu
[code]....
I have below statement (bold, italics and red) in C#, but i want to know the vb.net equivalent. And also an explanation of c# statement would be great
IMessage m = parser.Parse(strMessage);//str message will contain your HL7 Message
ADT_A01 adtA01 = m as ADT_A01;
string strPID = adtA01.PID.GetPatientIdentifierList(0).IDNumber.ToString(); string strFamilySurName = adtA01.PID.GetPatientName(0).FamilyName.Surname.
ToString();
tell vb.net equivalent of following method:
C# Syntax
public class RecentPosts : Control
{
[code].....
Is there any equivalent for Typdef and Void in VB.NET.What I'm trying to do is, I have a function call for DLL in VC++ which is as follows:
[code]...
how it can be translated in Vb.NET?
Is there an ODBC equivalent to OleDbCommandBuilder? I usually use the OleDbCommandBuilder to make changes to my database but one database I am using is Oracle.This is what I would normally do using an Access DB
f Me.planStatusCB.Text = "MATERIAL ORDERED" Then
Dim da2 As New OdbcDataAdapter("SELECT WORKORDER.WONUM, WORKORDER.STATUS FROM ORACLEDB.WORKORDER WHERE WORKORDER.WONUM=?", conn)
[code].....
In my project I was using Parallel port to drive a relay circuit with the help of inpout32.dll. But as we all know nowadays parallel ports are getting extinct and USB is getting replaced in its place. Is there any other means I could adapt for driving external circuits from PC, instead of using Parallel Port
View 1 Repliesbefore posting i've been searching here, alot, what is the simplest way to READ AND WRITE to/from txt file.i found here, in the forum, many ways to do that
View 2 RepliesI have got a dgv which on clicking a cell or row triggers the row_enter event, this in turn fills a list which is then placed as the datasource for the datarepeater. Heres the event which works within a dgv
Private Sub dgv1_RowEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgv1.RowEnter
Dim NameList As New List(Of TestList)
For Each item In Example.Item(e.RowIndex).Names
[code]....
Now this is all well and good but i need a way to do this using a datarepeater. I have tried about 5 events to get something like e.RowIndex and have been unable to find any event that would let me use this routine?
Is there an Equivalent for the following code in VB2008?
VB6:
Load frmAlarm ' Loads the form
frmAlarm.EditAlarm oAlarm ' Loads what was saved on that form
[code]....
What is equivalent property of Window.document in vb.net?Window.document it is the property in vb 6.0.What is equivalent property in vb.net?in vb.net Web browser.document property is available,but I want Window.document equivalent property in vb.net.
View 1 RepliesTell vb.net equivalent of following:
C# Syntax
public class AuthorList : Control
{
[CODE]...
Which on build in visual studio 2008 gives an error.
I am trying to get the following VB6 listindex to work within my vb.net code:
setTheR CStr(payReq.ItemData(payReq.ListIndex))
But if i copy and paste that into VB.net it wont accept it.
This is what VB.net did with the converting of the VB6 to .net code:
strContract = payReq.Items.Item(payReq.FocusedItem.Index).Text
However, checking that value it returns the name instead of the index. While the VB6 code returns the value of 2311 (which is what it needs to return)
[Code]...
But that does not work with my listview in .net since that above is a listbox and not a listview. Is there an equivalent in .net for the listbox to have a custom index?
I have been using DBTransaction for my current projects that access a single database. However, I read some documentation on TransactionScope and was wondering in which scenario would using TransactionScope be better? Or should I be replacing DbTransaction calls with calls to TransactionScope?
View 2 RepliesI know that AndAlso is equivalent to && and OrElse is equivalent to ||. But what is the cleanest way to achieve the equivalent of Visual Basic's And and Or in C#?For example, consider the following VB.NET code.The ValidateForControl method performs some validation and returns whether the state of the specified control is valid. The entire input form is valid if all controls are valid. However, each control must be individually validated even if one is invalid (which requires the operator not to short-circuit). Visual Basic's And operator is perfect for this situation, but unfortunately there's no equivalent operator in C# as far as I know (&& short-circuits).
[Code]...
I am Validating a TextBox on it's KeyPress Event in VB.
VB.Net
If InStr("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz`~!@#$%^&*()_+|[]{};:<>/?,.'" & """" & Chr(8), Chr(KeyAscii)) = 0 Then KeyAscii = 0
What will be it's equivalent in C# ?
Let me know how can i use this Err in c#.This is VB Code:
If Len(sPart1) <> PART1_LENGTH Then
Err.Raise(vbObjectError, , "Part 1 must be " & PART1_LENGTH)
[code]......
What I am trying to do is to check if a value matches one of two numbers (and easily be able to add to the numbers to compare to). Rather than doing a longer-winded way such as: [Code] I have found that this only works when SectionID is 2 or PageID is 8. If SectionID is 3 or PageID is 12 then it doesn't work. Why is this and what can I do to try to get around the problem?
View 3 Replieswhat is the equivalent for OLE in .net
View 1 Replies