473,396 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Transactions in an Ajax form

I am trying to use Transactions in conjunction with Ajax and mutable
pages. I am supposed to have the user complete the entire process
before any data is committed to the database. Does anyone have any
idea if this is possible? I am using CommittableTransaction in the
"GetContainer". It seems to me their should be a way to get a guid
from the Transaction and then use that guid on the next page to pick
the Transaction back up on the asynchronous postback.

I found pages like this http://msdn2.microsoft.com/en-us/lib...tions.enlistme...
it does not seem to cover this. Any help would be appreciated.

Dim factory As DbProviderFactory =
DbProviderFactories.GetFactory("Oracle.DataAccess. Client")
Dim Connection As DbConnection =
factory.CreateConnection()
Connection.ConnectionString = constr
Dim cmd As DbCommand = factory.CreateCommand()
Try
Connection.Open()

Connection.EnlistTransaction(TransactionContainer. GetContainer(_name))
cmd.Connection = Connection
cmd.CommandText = sqlSelect
Dim reader As DbDataReader = cmd.ExecuteReader()
Dim table As New DataTable
table.Load(reader)
result.Tables.Add(table)
result.AcceptChanges()
Catch ex As Exception
Rollback()
Finally
Connection.Close()
cmd.Dispose()
End Try
Feb 29 '08 #1
0 882

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: RC | last post by:
I have a form where the user types the shipping container number into a box and then types the Pallet number into a combo box. The AfterUpdate event for the combo box runs the following code which...
4
by: Raposa Velha | last post by:
So, chosen the interface for my app, finally I got stuck with transactions. Boy!, how many ways of doing the same job are there?! Any suggestion so I could find myself in the right direction?...
9
by: TD | last post by:
I am trying to add transactions to my code. The original code worked fine until I followed an example to setup transactions, now the code does strange things, but no error messages. Could...
2
by: Sridhar | last post by:
Hi, I am trying to implement sql transactions. But I am not knowing how to do that. I created a data access layer which contains methods to select/insert/update tables in a database. I have also...
12
by: Rami | last post by:
I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database. 2- Two machines have a .net business logic...
5
by: lucyh3h | last post by:
Hi, I am trying to use XMLHttpRequest to do server side validation. I have several fields on a form and a submit button. The submit button has an event assocated with it when clicked. The...
7
ak1dnar
by: ak1dnar | last post by:
Hi, I got this scripts from this URL There is Error when i submit the form. Line: 54 Error: 'document.getElementbyID(....)' is null or not an object What is this error. Complete Files
2
by: =?Utf-8?B?VG9u?= | last post by:
Hello, I want to understand teh benefits of ajax technology. Does anyone has a good website where AJAX EXTENSIONS is worked out so I really understand it. There a 2 main questions: 1) How about...
1
by: Mechanic | last post by:
I am trying to use Transactions in conjunction with Ajax and mutable pages. I am supposed to have the user complete the entire process before any data is committed to the database. Does anyone have...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.