I'm trying to run a transaction and I'm having some issues. What would cause a query to be executed before the transaction.commit() is called? Is there a specifice order that queries should be ran when working with a transaction? I have 1 update query that will always execute no matter what, before the .commit() is called. [code]
View 4 RepliesI 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 want to know that do you still need to rollback your transaction if you haven't commit the transaction that was created earlier.
[Code]...
Sample Table
Job_ID Job_Name Status
1 TEST00001 FOR KE
2 TEST00002 FOR KE
[code]....
I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will query that.Now, what if two queries was executed at the same time? Will the two users get the same jobname? How can I avoid that?
I'm trying to extend my new WPF Touch Screen Keyboard (DLL) Library, to allow the user to get events from the Touch Screen Object. I'd like to be able to tell the Programmer what Object made the call (or executed the subroutine) that raised the event. Not dissimilar to the Sender as Object event parameters one gets when working with a System Object. Which begs the question, How do I get that information, if I don't ask for it?Is there a way to get this information from some call made in the subroutine about to raise the event?
View 2 RepliesI'm trying to extend my new WPF Touch Screen Keyboard (DLL) Library, to allow the user to get events from the Touch Screen Object. I'd like to be able to tell the Programmer what Object made the call (or executed the subroutine) that raised the event. Not dissimilar to the Sender as Object event parameters one gets when working with a System Object. Which begs the question, How do I get that information, if I don't ask for it? Is there a way to get this information from some call made in the subroutine about to raise the event? That would be nice, and a time saver for me.
View 1 RepliesI am using VB.NET 2008 and SQL Server 2008.My program runs the below query all the time for different values, but yesterday, this query was executed, and it set the other values correctly in myTbl, but it didn't set the "Status" column to 'C' as stated in the query.
update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
There is no error when executing the query.Why the "Status" column wasn't being set correctly, and what can cause this ?
m_cmdSQL = New SqlClient.SqlCommand
With m_cmdSQL
.Connection = adoCon
.CommandText = "update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
End With
m_cmdSQL.ExecuteNonQuery()
I have some pieces of code like this:
strSoftware = "select MobileSoftware.Entertainment, MobileSoftware.MobileApplication, MobileSoftware.RingingTone, MobileSoftware.Directory from MobileSoftware where MobileName = '" + strName + cmdSoftware = New SqlCommand(strSoftware, con)
drSoftware = cmdSoftware.ExecuteReader
When I write the query in one line, then it works. But when I do like this:
[Code]...
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]....
I want to add a query on a form called Customers.So, I want to type the begining of the Customer's name, and when i push the button, on the datagridview appear all the Customers with a name like that.
View 2 RepliesWhat 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've got a datagrid with checkboxes which calls a routine called checkbox_CheckedChanged. So far, so good. I've managed to get it to work out the value of another column in the dataview, which allows me to ascertain the id of the row I'm dealing with. I'm trying to get it to change the value of the column which defines the initial value of the checkboxes, but the SQL I've written doesn't work when called by vb.net - it does work when entered manually into SQL server, however. Here's my code behind:
[Code]...
I used to write this:
Private Sub Example()
Static CachedPeople As List(Of MyApp.Person)
If CachedPeople Is Nothing Then
[code]....
But then wondered if I could reduce this to:
Private Sub Example()
Static CachedPeople As New List(Of MyApp.Person)
...rest of code...
End Sub
will the "New" bit only be executed once when the function is first executed but in the next call, it will already exist.
i was wondering if it possible to have a condition where lets say you have a column in the datatable called amount and a textbox acting as the filter called say maxamount to set it so the rowfilter when filtering the table will sum the number in the amount column until the number in maxamount is met, then stop and only return the rows where the total sum of the amount column is equal or less than the maxamount value, so i guess if the next row takes us over the maxamount it discards this row and returns the rows previous to it. is this possible using datagridview rowfilter or should i be loooking elsewhere to achieve this?
View 4 RepliesI have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but dont know how to compelte the rest.
Imports System.Data.SqlClient
Public Class cbo2
Private Sub cbo2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
I have a form called FrmPracDetails which is built up with a List view called LvwColProc. Therefore when you click a field on the LvwColProc it takes you to another form called FrmColProcessing, here you can make changes to certain fields which are also present on FrmPracDetails. What I want to do is when you make changes on FrmColProcesing and Click the Save Button (which calls the Save function)the changes appear instantly on FrmPracDetails. Please note, FrmColProcessing will always be open next to FrmPracDetails. I have tried to put this code in the Save function present in FrmCol Processing as shown below, but it doesnt Refresh FrmPracDetails form. [code]
View 1 RepliesI have the following line of code in my program:
JCL_History.Enqueue(JCL_History(I))
This JCL_History object is basically a Generic.List encapsulated in a wrapper and has the following method:
Public Sub Enqueue(ByRef value As String)
If Members.Contains(value) Then
Me.RemoveAt(Members.IndexOf(value))
[Code].....
In my testing I have 2 items in this JCL_History list. When I call that first line of code I posted (the one that invokes Enqueue) with I = 1 I expect the first item to be shuffled to the bottom and the second item to be shuffled to the top.
After the thread returns from Enqueue I notice that this is exactly what happens to my list, HOWEVER if I hit the "step_in" button after the execution of Enqueue I go into the Default Property's set method where Index = 1 and value = and it screws everything up, because the item that got shuffled to the end (index 1) gets overwritten by the item value shuffled to the top.
So basically the set method on the default property is getting called at what I think to be a completely ridiculous time. What gives? By the way I'm running VS2005 on XP.
How do you commit a datagridview row?
View 3 Repliesi am deleting the row from the datagridview using following codedatagridview1.rows.remove(datagridview1.currentrow)but it is not commiting.how i can commit?
View 4 RepliesCan you look at my coding and let me know what I'm missing or doing wrong?I have a SSRS report that is called from a ReportViewer control and the ProcessingMode for this control is Remote. The report also has 1 parameter in it's DataSet.In the code I placed a MsgBox to make sure the code is finding the parameter and returning the parameter name. I am trying to stick the value of 10 into the parameter for playerID 10. Data for this player does exist.
I believe I need to add some more code to make this work but I'm not sure what else to add.
When the code executes the report is displayed but no data is shown in the report.
[Code]...
I recently found an awesome tool called "Freemind" that is called a 'mind mapping' program. It's similar to MS Visio but way cooler and more automated.I reeeallly would like to integrate this into a VB.net Form, but how?
Has anyone seen or heard of mind mapping inside VB.net before? Are there programs out there already that work with VB.net or anyone have an example they have seen / built that works?
Maybe there is a better way to do this. The jist of I want is to have SQL Server raise me 2 types of errors: a WARNING and an ERROR from a trigger when I update a table. If SQL server returns a WARNING the trigger should COMMIT but show the warning to the user (using .NET - preferably through a SQL Exception which is only raised if severity > 10) and if it is an ERROR the trigger should ROLLBACK and show the ERROR to the user (through a SQL Exception).My attempts (needless to say this isn't working) at this was to have a trigger like this:
ALTER TRIGGER [dbo].[TR_TRANSACTION_UPDATE]
ON [dbo].[tTRANSACTION]
FOR UPDATE
[code]....
I'm binding user settings to a bunch of controls on a WinForm dialog that has OK/Cancel buttons. While this works great to read in the bindings in, I would only like to commit binding changes if a user clicks OK, and not if they click cancel. Is there a simplistic setting to achieve this rather than managing all reading and committing myself?
Right now, let's say I have a textbox that binds to a user setting called "country". It has "United States" in it and if a user changes it to "Bolivia", that will get committed as soon as it is typed instead of when the OK button is pressed.
I'm binding user settings to a bunch of controls on a WinForm dialog that has OK/Cancel buttons. While this works great to read in the bindings in, I would only like to commit binding changes if a user clicks OK, and not if they click cancel. Is there a simplistic setting to achieve this rather than managing all reading and committing myself?
View 1 RepliesI have a DataGridView and in it a CheckBoxColumn, when I click a cell of that column the check box gets checked.I do it like this:
dgvMessages.CurrentRow.DataBoundItem("have_read") = 1
but the change does not get committed to the DataSource (or at least not immediately), so when I search through it I get wrong results.
I can't call AcceptChanges as that will refresh the grid and cause unwanted side effects... What can I do about this? Is there such a thing as an 'AutoCommit' property on a DataGridView?
[code]So both methods seem to step through fine but don't commit the changes back to the database. This function is my only 'edit' function. It needs to look for the datarow which is to be edited. Edit it and then save the changes to the database.My other two functions create datarows and work fine. This one I just can't work out. I have a dataset with two datatables. This is running as a web service. Database is MSSQL.
View 1 Repliesand in both table i have to insert values and later i need to update one table... the problem is when there is any exceptions in update it need to rollback fully and it also the values which have been inserted must be rollback..
View 2 RepliesI got the code below from a book but it doesnt seem to work:
[Code]...
So I'm going through a tutorial on how to get stuff in my vb form to update a Access Database. I know, I should be using sql, but Im just learning. Anyways, here is the code..
[Code]...
Created dataset with tableadapter.Dragged dataset and tableadapter to the form so I can reference it in code.New records successfully add to the dataset but will not commit back to the database.Gives no error or clue why it won't work.TableAdapter insert statement was created automatically and is parameterized (@p1, @p2, etc.), but I am trying to avoid those parameter.add statements as I want to be able to use a field-by-field format without having to essentially repeat the schema of my database in code with parameter.add statements.Command object and INSERT statements work fine, but then you always have to construct an INSERT statement -- a pain if they're complicated.I want something as simple as working with a ADO recordset,but in .NET.What can I do to accomplish the following without parameter.add statements? [code]
View 6 Replies