In my project i am using begin transaction commit or rollback changes. but this causes lock to the tables in that particular functionality.
So if the any other user does any other functionality those locked table are not available until the transaction is completed. I want to know if there is any alternative to transaction which insures data security but the tables are not locked out.
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)
I am getting the following error while handling transaction(Isoloation level is serializable) in Ado.Net."Transaction (Process ID 75) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."
View 3 RepliesI've created an app (VB.NET) where each installation of the app works with a single local database on the PC. No multiuser and no ability for the user to change databases - the database is effectively part of the app, with a fixed scema, only the data will change.At the moment the database is SQL CE. It has about 30 tables with some simple relationships between the tables.
I'm wondering if there is an alternative to SQL CE that might be faster in this scenario. Although SQL CE is excellent and easy to use, I get the feeling there is perhaps an unecessary overhead when using it for something simple - and it does seem a little slow when my app is doing complex stuff that interacts a lot with the DB. In my prototype I actually loaded the 'database' tables from text files into Arrays and developed subs and functions to perform the database searches etc. It was blindingly fast but I realised it wasn't a scaleable solution because it was an 'in-memory' database. A compromise would be to 'page' data into array when needed, but it all gets horribly complex and that's probably why some very clver people have created SQL CE !
Can I code to add transaction for some subs? If there is an error in any sub will roll back.For example,
sub1 delete some tables
sub2 insert data into tables which just be deleted
sub3 send out confirmation email
sub4 make submit button disable
I knew that transaction will work for sub1 and sub2 but I do not know if transaction will work for all of subs
I searched araound and having some difficulties in implementing one scenario with SQL Server 2000 and sybase.I have two SQL servers on different locations naming ServerA (MSSQL Server) and ServerB (Sybase server).I have a table called SALARY.Whenever I insert one record to customer SALARY in ServerA, I also will insert it into ServerB.If should any of them failed, both of them should be rolled back.I am using Asp .Net with VB for the programming.I do not have the right to change / add table in Server B. The only thing allowed in Server B is insert/delete/update record.I looked around and find a method to use TransactionScope but I am not quite sure it is the right way to do.url...
View 1 RepliesI've found my current side project has become a great learning experience and have decided to keep it going that way. What I'm trying to do is update a table from a DataTable. The datatable has been created and isn't a direct result of a
query otherwise I'd just use a update and not learn anything new. This is what I have for code thus far[code]...
I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "ExecuteReader 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." Pointing to this block.[code...]
View 1 RepliesUsing VB.net, I have a namespace which I'd like to rename for the future. However, I'd also like to keep the old obsolete namespace for a time to ensure backward-compatibility for our consumers for awhile. Is there a way in .NET to have two namespaces, one ordinary and one that merely is an alternative name for the other?
[Code]...
From the WINDOWS Date & Time settings FORM is this accessible as an alternative
View 1 RepliesBelow is the code for a linked list search I have tried to implement in to searching through each of the elements of htmlelements .For some reason If element.InnerText = (item) will only work if if is only a string ("example") .Are there any other ways of Implementing the for each loop to search through my item linked list?
Original code for searching for 1 string
Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False
[CODE]...
This is the Loop for item I have tried to implement but is not working ,because of the for each loop .The value of element.Innertext = "" or null when I try to use one of the linked list item[If element.InnerText = (item)] is used and only have a value when a string is used to [If element.InnerText = (google)]
Private Sub block()
Dim elements As HtmlElementCollection = webBrowser.document.All
Dim word_found As Boolean
word_found = False
Dim item As LinkedListItem = words.Head
[CODE]...
I've encountered a problem in a application that I inherited. It contains a combo box that loads information.The problem is that there are more data that the control will hold (32767
View 2 RepliesIs there an alternative to Uri.EscapeDataString? I'm trying to upload an image, by converting it into a base64 string, but I need to use Uri.EscapeDataString on it first, and if the image is big then Uri.EscapeDataString will say that the URI is too long.
View 2 RepliesMy clients web application is using TidyCOM to clean up dynamically created XML files from a SQL database query. With this TidyCOM, they are not able to upgrade the web application to .Net 4.0 framework. Is there an alternative to using TidyCOM so that these dynamically created XML files are validated correctly?
View 1 RepliesWe heard a lot about the vulnerabilities of using QueryStrings and the possible attacks.Aside from that, yesterday, an error irritated me so much that i just decide to stop using QueryStrings, i was passing something like[code]....
View 8 RepliesMy VB application also needs to manage simple appointments in an agenda, however one user has no MSOutlook. Someone knows of an alternative calendar tool, with which I can do this?
View 2 Repliesis there an alternative for timer?
View 4 RepliesSo I've been doing a lot of reading today and apparently SendKeys isn't very reliable anymore.Does anyone know of another alternative to it for what I need:
The application works by the form being positioned over a open window, notepad, word, excel etc and it then determines what it is over, notepad, word, excel etc and then reads the file, and does some processing using SendKeys at the moment.Though I do believe I could probably change the later at some point. The problem I'm having right now is when I try to send the Alt + Tab to change focus it's working roughly 12% of the time.If you are wondering I ran it 50 times and it worked 6 of those,thus the 12%.I'm thinking that is rather unacceptable.This is what I'm using which should work: SendKeys.SendWait("%{TAB}")
XP Service Pack 3 and vb.net 2005
First off, using VB2010. I'm in the process of upgrading some applications from VB6 to 2010 and haveing a great time of it. The current application I'm working on is using Sendkeys of which I have changed over to the WSH.Sendkeys of which is pretty decent. Basically the program is copy and pasting the current open file, reading some data and saving it as a different file type. It also has to change xls files to csv and then saving it to the format as well as a smiliar thing with word. Thus the reason for the copy and paste as it's changing the extension to a dot date (for example, test.830).This is the flow of how it works for a text file (most basic)
1. changes focus to notepad
2. Select all Copy to ClipBoard
3. Open Programmers File Editor and a blank file
4. Paste in text
5. Save as code.date extension to the directory
Excel files obviously have a few extra steps.
I need a good alternative for System.Web that is included in the .NET 4 Client Profile. Currently all of my frameworks are included in the client profile, except System.Web. What is a good alternative?
View 7 RepliesWhile working on some functions that update my database, I was writing some quick tests just to make sure my functions were executing properly. When it comes time to actually update the database I can pass a transaction to a function and then commit it:
user.Assignment("assignment value for some column in table", connection, transaction)
transaction.Commit()
I am curious if there is a way to write a quick test that can verify that the transaction will actually update certain rows before committing?
(pseudoish-code)
user.Assignment("assignment value for some column in table", connection, transaction)
If Not transaction["SomeColumn"] = "Expected value for SomeColumn"
assert("ColumnName was not going to be updated to the expected value!")
transaction.Rollback()
i am building a transaction called client search the location of movie in store which mean client search the movie then get the direction of the movie where it is located in store. So now i need to build classes for this transaction which i am unable to find it because i am confuse about direction table .
View 1 RepliesI am using visual studio 2008. and i put dataset to use report wizard. but, when i compiled it, i got this errors.
Error1Property 'Transaction' is 'ReadOnly'.C:\Documents and Settings\mahalia\Desktop\NewProject\NewProject\DataSet2.Designer.vb292321NewProject
Error6'OracleDbTypeEx' is not a member of 'Oracle.DataAccess.Client.OracleParameter'.C:\Documents and Settings\mahalia\Desktop\NewProject\NewProject\DataSet2.Designer.vb299113NewProject
--- and when i locate it, i saw it in dataset.designer.vb.
I am generating new code for a transaction.
View 11 RepliesI'm learning about VB.Net and need to work with an SQLite database using the open-source System.Data.SQLite ADO.Net solution.The examples I found in the HOWTO section are only in C#. Would someone have a simple example in VB.Net that I could study to understand how to use transactions when INSERTing multiple parameters?[code]
View 2 RepliesHowever, I've just inherited a problem and was wondering if anyone knows if I can solve it with a command line application written in .NET. Basically, we have a SAP transaction which has been written which imports data from a csv file.At the moment, it will be a manual process requiring someone to log in and run the transaction. Does anyone know if it's possible to action this from a command line app which we could then set up as a scheduled task?
View 1 RepliesWe are developping an application VB.net 2.0 and SQL 2005. Users are allowed to cancel a reception based on a purchase which may contains many received goods. But, during the process of cancellation, some questions are asked to users such as "Do you want to cancel Good #1".
If yes, delete. Then, "Do you want to cancel Good #2", no, do not delete and one another question (if received item is issued, a process must be made manualy by the user). And, at the end, if all goods were successfully cancelled, we have to cancel the reception itself. But sometime, if an error occurs or some conditions occurs once asked to user in this process, we want to cancel any actions made from the beginning and make it back to his original state. So I thought about Transaction.
[Code]...