Ado.net - Attribute - Ensure 2 Calls Are Enlisted In A Transaction
May 7, 2009I need to ensure 2 calls are enlisted in a transaction
[Code]...
I need to ensure 2 calls are enlisted in a transaction
[Code]...
I 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 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)
What the Win32 API is? I have looked around but no where really outlines what it is. Is it basically a set of procedures, outlined by Microsoft for programmers in order to get services from the operating system? In essence is it the equivalent to making system calls abd and library calls in UNIX? And yes I now Windows makes library calls too.
View 2 RepliesI 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 Replieshere any algorithms/pseudocode for reading/parsing 3-column csv data and determining unique objects/attributes/values?
example data:
john,height,1.75
george,age,21
[Code]....
i have already implemented a solution of my own but it's too slow and i can't find any relevant literature on the internet.
Possible Duplicate: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive
I am using window xp and iis 5.1 to run the application.
error is occurred Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.
[Code]...
I get an error when I try to build my project.'SSLAccessFiltercannot' be used as an attribute because it does not inherit from 'System.Attribute'. [code]
View 1 RepliesSay if you had two private subs on a form, how do you ensure the first sub called has completed it task before the second is run.
[Code]...
I have a problem with ensuring no duplicates. I have an Appointments form (frmAppointments) and within it exits 4 date time pickers. The first 2 date time pickers are dedicated to creating an appointment date whilst the other 2 are for the purpose of changing an existing appointment date. When the date and time is entered into either one of the pairs (of date time pickers), the values inside get transferred to 2 corresponding textboxes. The user then clicks Save (btnSave) and the values are saved to sql.
How can I ensure no duplicates (of the date and time) can be created?
I am having a small 'head banging' experience working on one of our DLL products.The problem I am having is that this application is an outlook addin, and as such, does not own its own Message Pump. No problems there, I have a UI class, which starts a thread, and calls Application.Run(new fControlForm)
I use the Application.Run passing a form, rather than an ApplicationContext purely because I want this form to be in charge of displaying other forms: ie, I can use BeginInvoke to ensure that a second, and many more forms are created in the context of the thread that owns the Message Pump.
I however feel this to be quite hackish. I get a form displayed at startup (which I am sure I can hide if I needed to)My question: IS there any way to create some form of Invoke procedure in an applicationContext that uses the Message Pump thread? I have created a class which implements the ISynchronizeInvoke and can Invoke from a thread that it owns, however this is not the same as invoking from the Message Pump owner.
How can I ensure that a user enters data in one text box before being allowed to move on to the next text box Example I have four text boxes the user can enter a grade in. I want to lock the other three box until the user has entered a number in text box 1. Once a valid number has been entered in text box 1, that releases or enables text box 2. Once a valid number has been entered in text box 2, that releases or enables text box 3. And once a valid number is entered in text box 3, that releases or enables text box 4.
View 5 RepliesSo when that code run the program don't switch.Say I want to
Open a file
Write something
Close a file
Way when I open a file, another thread want to open that same file. That means open a file get executed twice.
I have a screencasting program where it takes 10 screenshots every second and saves it to a temporary directory then through ffmpeg the series of images are compiled into a video format. My problem is that due to the computers processing power or the size of each screenshot and its quality it sometimes takes longer than 100 Milliseconds to create one causing the whole video to be off balance. How can I ensure 100% that 10 Images will be stored?
View 1 RepliesI've created some classes that will be used to provide data to stored procedures in my database. The varchar parameters in the stored procs have length specifications (e.g. varchar(6) and I'd like to validate the length of all string properties before passing them on to the stored procedures.
Is there a simple, declarative way to do this?
I have two conceptual ideas so far:
Attributes
public class MyDataClass
{
[MaxStringLength = 50]
[Code]....
This seems like a lot of work and will really make my currently-simple classes look pretty ugly, but I suppose it will get the job done. It will also take a lot of copying and pasting to get this right.
I have a WCF service being hosted in a Windows Service (using techniques discussed here) and it works great. I'm now writing a (VB.Net) frontend app that needs to call that service, but I don't want my users having to fiddle around with the services snap-in and starting the service manually. Can I write some code to ensure the Windows Service is started, or start it if it isn't?
Edit: OF course, I can ensure the Service startup is set to automatic, but it doesn't need to be running all the time, and even then the frontend app still needs to be sure the service is running and start it if it isn't.
I need to make sure that the connection to a POS printer is successful before writing data to the database and then printing a receipt. The POSprinter is normally of type BTP 2002NP but may differ. The common thing is that they are all connected via COM-port and NOT usb, so no drivers installed at all on the client. Can I send some kind of "ping" on a COM-port and check if a device is connected and turned on? Additional information, the application is developed in VB.net and Visual Studio 2008
View 2 Replieshow to ensure that a process created via the diagnostics.process class goes away when my app does. My app starts two processes, one runs plink and one runs psftp. Due to reasons that I don't want to become the focus of this post it is possible that my app will shutdown in an ungraceful manner. When this happens the psftp process dissapears but the plink process remains left behind. See the code below for how I am creating these processes.
Code:
Public Sub New()
Try
p = New Diagnostics.Process
'p.StartInfo.FileName() = "plink"
[code]....
Please take a look at the code below. I was told by the individual that developed itoriginally that the code only adds the rows of data the user entered. In other words,there 5 rows of textboxes. user can enter data into one row or into all 5 rows. If the user enters data into one row of textbox, that's what gets inserted into the db.I made some minor change to the code so that users can tell when a payment is made by check or cash payment.Since I made that change, whether a user enters data into one row or all 5 rows, all 5 rows get inserted into the db.How can I modify this code to ensure only rows entered get inserted?
For x = 1 To 5 Step 1
dedval = obr.FindControl("ded" & CStr(x))
chckvalflag = obr.FindControl("chck" & CStr(x))
[code].....
I have the following code which is part of a PA Call system: The 'SetPTT' nd 'DisableZones' statements set controls on the form where the code is. The LAPG2Coms.SetZones command starts another project within the solution to control an external controller. What I can't understand is why it executes the LAPG2 statement before SetPTT or DisableZones. The LAPG2 statement for messages is in the PlayMessage Procedure
[Code]...
I need to ensure that the user can only click the button (to acknowledge the message) and not do anything else (like clicking another button). How can I do that?
View 2 RepliesI'm trying to find out how to ensure a font is found by a project.I would expect to be able to add it (Them) to the recourses but can't find how to do that.When I get to 'Add item' I've tried 'New' and 'Existing' but can't find a template for fonts, so I'm lost (again).
View 3 RepliesI have a listbox that is sorted and the data table that is bound to it is also sorted. I am trying to add a Record to this data table and ensure that it is always at the end of the list. Is there a way to do this using specific character combination?
View 2 RepliesI've written a small program that monitors the customer field in Quickbooks and query's a database to determine if there are any important notes for the selected customer. This works fine however, I either need the messagebox or a form to come to the front of all open windows on the system to inform the user that the selected customer needs to be reviewed.
How can I ensure that a form (or messages box) that opens in my program comes to the front of any and all application windows that are open?
How can I ensure my app fully compatible with x64 Win7 platform? I have a choice of 32 or 64 bit development machines to use.
View 10 RepliesI have an application that opens a Excel file into a form using AxWebBrowser.Navigate. This works fine unless there is another Excel file open before I run the application, in which both excel files are opened in the same Excel application which then causes problems.
How can I ensure the AxWebBrowser.Navigate opens a New Excel application?
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop.Owc11
Imports System.Runtime.InteropServices
[Code]....
I have an application that gathers information from a user into a Win.Form and then uses the Process.Start() to start Notepad and then using Sendkeys write the Notepad document.Sometimes this works great and sometimes the Notepad window is not started as the foreground process and the document is not written.What is the best way to ensure that the window opened by Process.Start("Notepad.exe") is the active window for the duration of the Process?
View 10 RepliesHow can we ensure that an NUD has a value DISPLAYED if the user deletes its contents?
View 5 Replies