I am trying to use a transaction for the duration that the dialog is open and then commit the changes once the dialog has been ok�d or rollback'd if canceled by the user.My problem is when I use the transaction it is locking the whole of the tables that I�m using to update and insert new records too.I update the record in the first (current) table and insert a new record into the second (history) table. Obviously this is causing me problems as I only want the transaction to lock the specific records i'm updating and not allow a new insert record with my PK associated to my that I�m updating, not lock the whole of the 2 tables.This is my code[code]....
I have an application which upon a save button needs to save data to 8 different tables. 7 of those tables will have multiple new records added to them, while 1 will have just one new record. I want to encapsulate this giant Insert operation in a Transaction so that it will not complete unless I can save successfully to all tables.I have considered using Insert commands to a command statement, but adding what amounts to like 50 parameters, and the fact that using a parameterized query means it becomes very difficult to troubleshoot problems such as invalid values in the SQL statement (since I cannot figure out what the statement looks like with values in it
I have a project, which divided into three categories. i) Presentation layer ii) business layer, and iii) Data Execution Layer. Business layer communicate between 1st and 3rd layer. here my problem is I want update some tables through transaction batch. Here I am facing logical concept who to update transaction batch in business layer or data execution layer.
I'm trying to verify if data exists in two different tables in a single transaction. The reason for the single transaction is the database gets hit about 1-3 million times a day so adding anymore than 1 extra transaction would increase that number up to 9 million, and my poor little server needs a break :)
So I need to check if an ID exists in table X and table Y and return the results to my VB.net script so I can handle the outcome Ideally something like this would work
if exists (select id from X where id = @id) print 'True,' else print 'False,' if exists (select id from Y where id = @id) print 'True' else print 'False'
Which gives me "True, True" if exists in both or "True, False" etc etc... But that only displays in SQL print and not actually returning it as an object/string or array values that I can use.
I'm open to any sort of solution of this nature that can give me two results from a single transaction and how to handle that response in vb.
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
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 using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped) da.Update(dt) << This line 'da = dataadapter
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
I am in the process of writing an application that requires a single transaction updating several tables. The front end has a header record and several detail records. I do not maintain any type of lock on the original read. The read is performed by calling a stored procedure in an existing database to pass back the data.
When I update the data each detail record is updated individually. Is there away I can update all of the records within a single transaction? The update will be performed via a stored procedure that is stored on the server. I cannot store the code in the application as other applications will need to use the same server side code. I can handle updating a single record my issue come about when I've updated 5 records and the 6th fails, how do I rollback the 1st 5 records.
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I am developing a parser application to build a call tree from DDL files that have been extracted from a database. The idea is to take a large number of these DDL files and determine exactly what calls what. To do this I am using a .NET TreeView. The final output I am working toward is something like this:
I'm using vb.net 2005, I've got the following code running a thread to download a file. However, the process fails sometimes when trying to read the local copy of the file. I think I may need to unlock the local file somehow but I'm not sure how to do this.[code]
i have this application, that creates various custom AppDomains, each app domain executes a assembly and its dependencies, like a plugin, a separated assembly, that manipulates database, own resources, etc.
the application runs fine for a while, but suddenly, it locks up... the process does NOT die, it just freezes, i ran a remote debugger on top of it, on the thread window i can see EVERY thread, they are with the status "running" (not "thaw") but, in the same place, not executing. i can pause and run the debug, and it remains in the same place. there are NO locks, synlocks, monitors, on the code and the code for loading the appdomains is very simple, no big deal on it. like i said, its working, but after a while, it locks up. Any ideas on this environment?
How could I lock any file in my PC from others access? I am trying to lock some my video, picture, Excel and Word file in my PC by using Visual Basic. I am using Visual Studio 2008 to develop this application but I am unable to do this job. It'll be something like security utility application. Actually without me, some other people also using my computer and I am trying to lock their access in my personal file. And I wish to know the tools which I can use for this job. I am just a Beginner on this development field.
I am in the process of writing a pos for the first time for a friend for his new restaurant. I am need to allow users to input floating numbers only. How do lock out the keyboard?
In Visual Basic 6, locking a control would prevent the user from selecting a control without greying it out like disabling it would. Is there a way of doing this in Visual Basic 2010?
Simple question. I have a log of actions that is in XML. When some action occures, the XML log is updated. I am using:Dim xmlData as XElement = XElement.Load( "DataLog.xml" )
to load the existing data. I then create a new XElement (NewData) and use:xmlData.AddFirst( NewData )Which puts the latest item at the beginning of the log. And finally, I write it out using:xmlData.Save( "DataLog.xml" )Ok, that all works fine. But there is no testing to see if anyone has (or is) updating the file ("DataLog.xml") during the process. This may result in lost data. Is there an accepted way to implement some sort of file locking structure that can be used to prevent this potential loss?
I have some code based on some previous posts that just won't work right.The code all runs without error.
-' strErrorLog holds a valid file name with full path -' xmlNewError holds a valid xElement value
Using holdFile As New IO.FileStream(strErrorLog, IO.FileMode.OpenOrCreate, IO.FileAccess.ReadWrite, IO.FileShare.None)[code]When I step through the code, everything works.There is no error on the xmlError.Save call.However, the actual file is NOT updated.If I remove the "Using" commands and change the save to "xmlError. Save(strErrorLog)", then it writes just fine..It's got to be something really simple, but it's frustrating that I don't get an error message.But it does unlock the file..
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
I've stress tested the code below and it seems to work fine - what are the dangers of not locking in the simple case where there is a single thread writing and a separate thread reading a simple variable? Have a class that has a public property...
This is the situation when there is a shift change and one record is started by one person and finished by another. What one has written another can't change but must finished a record. So u must lock only the combo boxes and text boxes that are filled. This code lockes all the combo boxes and text boxes and 2 check boxes (NEZAVRSENE_INTERVENCIJE and IZMENA_RASKRSNICE) by clicking on a NEZAVRSENE_INTERVENCIJE check box. Lets say I have combo boxes 1 2 and 3 and text boxes 1 2 and 3 and I have to lock only the ones that are filled. How do I code that another check box lockes just the filled controls?
I'm currently having issues with the following scenario:
1. I will build several DLLs with "Generate XML Documentation" set.
2. The DLL and XML files are copied onto another server (the build drop).
3. The copy will fail as the XML files are being locked by other users referencing these DLLs from their open Visual Studio projects.
Note that this also occurs on a local computer; open up two Visual Studios and use reference paths to reference the Binary folders. You'll find that the refrencing instance of Visual Studio will lock up the XML files causing the first Visual Studio to have problems compiling.
1. Is this a bug in Visual Studio 2008? Why is it holding exclusive locks on these files from the other computers? Is there a fix for this?
2. Is there a way to "package" the XML file into the DLL? I've noticed a lot of other .NET DLLs in the world that include all of their comments INSIDE of the DLL. No XML files necessary. (unless they're not .NET dll's).We're doing a lot of framework development here and it's imperative to include the XML documentation... unfortunately we've had to disable it to allow new builds to trickle through.
Title says it all. I want the ToolStrips to remain on one row, and for the user to be able to rearrange on that row but not create additional rows. I tried using SetBounds on the LocationChanged event, if the user attempted to change the Y position it just sprung right back. However, this created some visual bugs, such as the mouse always jumping back to the location and the ToolStrips jumping around randomly (while dragging one, the other would hop around randomly on the bar...)
I also tried setting the MaximumSize of the toolstripcontainer panel, but it allowed the creation of a new row anyway (in which the toolstrips were hidden.) EDIT: Its been a few months, still no answers...is this even possible?
1) How do I lock my application to user's HWID?I want it to work this way: when a certain user opens my app, it automatically scans for his hardware ID and lock the application to it so noone other than the user can use the app.
2) I'm planning to use SmartAssembly trial version to obfuscate my code, will this affect my application in any way? Like, crashing?
