Use One SQL Connection With Multiple Transactions?
Sep 19, 2011
I have a vb.net web app and I am passing a SQL connection and a transaction to a method which writes a single record to the database.
I would like to start and commit a transaction for each record that is written but using the same sql connection until the loop is done.
One method I saw was utilizing a using statement but it didn't work for me.it runs the first time and gives an error on the second that the transaction has already been commited
Using sqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
[Code]....
View 2 Replies
ADVERTISEMENT
Dec 22, 2011
whether is it feasible to commit one huge transaction per time or do it multiple times.Lets say around 1000 - 3000 of mixed updating or inserting rows for per transaction or having a loop to commit every transaction as it loops.Which one is preferred ? will it have any impact ?
View 3 Replies
Sep 8, 2009
I am using MySql 5.0. I using Mupliple datareader in same connection i get error message. Is possible to use multiple Datareader in same connection?
I using Mysql Connection is
MySqlConn.ConnectionString = "SERVER=" & gServerName & ";DATABASE=" & DBname & ";user=" & gUserName & ";password=" & gPassword & ";MultipleActiveResultSets=True"
MySqlConn.Open()
View 1 Replies
Jul 14, 2009
I am using datareader to retrieve data. I want to use multiple datareader at a time with same connections. WHen i used it, it gives an error as connection should be closed before using it next time.
View 23 Replies
Mar 2, 2010
I'm testing database programming in vb.NET 2008 at the moment and try to find a way to use a database connection in different forms, so e.g. I put the the database-connection-component into one of the forms. I know, I could access it by e.g. form1.databaseconnection.xxx, but is this the best way or can I "put" the connection into something more abstract which all forms know about?
View 2 Replies
Dec 15, 2011
is there a function that will allow coders to connect to multiple database? by just changing the connection string and not the variable declaration ...example:connecting to access is something like this
Dim Con As New System.Data.OleDb.OleDbConnection(ConString)
for sql is something like this
Dim Con As New System.Data.SqlClient.SqlConnection(ConString)
is it possible? acctually in vb 6.0 it is possible ...
View 2 Replies
Nov 10, 2010
I have installed SQL Server 2005 Express and VB 2008 Express.
For testing, I created a database with 1 table with 4 columns. I used SQL Server to add 2 records. I then created a new project with 2 forms. On one form, I put a DataGridView control. On the other, I used bound text boxes. Both had a ToolStrip. I made changes to the data through the forms. Both forms seemed to work properly, except when I looked at the data again using SQL Server, the data had not changed. Opening the forms again, the data had reverted to the original data.
I am using the code created by controls, so it should work. When I use the Database Explorer in VB, it shows the table and the data and I can make changes to that data. So why is my code not committing the transactions?[code]...
View 2 Replies
Oct 26, 2010
I am trying to use SqlTransaction object in my vb code for an application to insert vendor info.The code runs till inserting a transaction and then gives following exception:
"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."
[code]...
View 3 Replies
Aug 6, 2011
I have a VB Solution with a dozen forms trying to implement invoice system.My main form (Say Form1) only has a design to create , Edit or Delete Customers.My form 2 will be opened if Create button is clicked. In my form 2, I have textboxes where user can enter Customer details and click on SAVE. My doubt is here....On clicking this SAVE button in Form 2, I want a INSERT command to happen on the MSAccess's Database table called Customer (which I have already created... this table does not have any records as of now). In my form 1, I added a MSAccess Database with a Connection String. In my Form1's code I have code like this[code]...I got this piece of code from this link [1]: vb.net - sharing mdb access connection among multiple forms/Now, I do not know what more code does this require to INSERT records from my text box into the Customer table's fields.
View 1 Replies
Sep 7, 2010
I'm starting to put in a database into my application, however I'm drawing a blank on how to share a database connection among the dozen or so different forms in my MDI application. I'm assuming this has to do with interfaces or something but I can't find any relevant examples anywhere. Can someone help me out? Ideally what I'd like is when the app is loaded up there is a call to a function in the forms loading area which establishes a single connection to the mdb, that I can then call via any form so I don't always have to open/close connections everytime I need to update the db?
Here's a basic example of the mdb database access code I've got working:
Dim dt As DataTable = New DataTable()
Dim OleDbTran As OleDbTransaction = Nothing
Using connJET As OleDbConnection = New OleDbConnection("connection string here...")
[code]....
View 1 Replies
Sep 11, 2011
Am developing a server - client application using the system.net class , that will have more than 5000 simultenous client connection.what is the best way to manage multiple client connection like this?
View 3 Replies
Oct 27, 2011
I am creating an VB 2008 application which uses 2 connections strings in according in which computer is running (my test machine, and the production server). How should i manage the connection string in order not to change manually the connections string which are many inside the code??
I have read that you can read them from an external line, or if you put both connection strings in an external file, according in which machine the program is running can actually the correct string?
View 9 Replies
Nov 19, 2010
I wanted to know what (if any) differences there are to using the SQL Transaction within the application versus written into the stored procedure using TSQL statement. We would need to restructure the stored procs and vb code to get this to work and I'm not sure it would be worth the effort at this time.
Public Sub RetrieveTData(ByVal cID As String, ByVal cnn As SqlConnection) As Boolean
Dim sqlTran As SqlTransaction
cnn.Open()
sqlTran = cnn.BeginTransaction
[code].....
We aren't certain whether the timeout is occurring in DataAlreadyTransferred() or usp_BigNasty_CopyDataFromDB1toDB2 due to how the try/catch is written. We can restructure this code, but will take a week or so to get it to production (no errors occur on test/dev today)
DB1 - permanent storage, used by other applications as well
DB2 - working set, used only by Web App
DataAlreadyTransferred(cID) first checks to see if DB2 has any copies of the records, if DB2 does and those records are clean it deletes them (data could have changed in DB1 and we want the most up-to-date version). If DB2's data is dirty it is left alone and no data is deleted.
usp_BigNasty_CopyDataFromDB1toDB2 copies rows from approximately 20-30 different tables and copies over the perm copies from DB1 into DB2, essentially creating a working set from which the Web App can access
We are aware this is inefficient and are examining ways to improve it, just haven't had time yet... I believe by having the transactions in the app code it's locking many more tables than is really needed. If we move them to the stored procs, less tables will be locked at one time thus improving our chances of removing deadlock conditions/timeout issues we're seeing today. Just not sure on this..
View 2 Replies
Jul 5, 2010
I am looking at re-writing an application (currently in C) which uses HIS 2004 (Could use 2009 if required) to access mainframe transactions. Is there a decent framework which I could use to connect and call mainframe transactions and relay any infromation into the existing system? ( I am developing in a .Net 4 environment) to remove the c coded requirement?
View 1 Replies
Apr 1, 2010
I am using the SQL Server and DB2 in my application. The DB2 transactions do not work with the DBProviderFactory Class but SQL Server work. I have to use to separate DB2 API's to make the transactions work but its very messy and involves a lot of code change.I extend DBProviderFactory class and add the DB2 transactions to it?
View 3 Replies
Feb 15, 2012
Can someone here give me an idea how should I make a transaction form or should we say a payment form.I already have a database with lists of students in it.Also a database with an event in it. Along with a fee on which every student should pay.
The problem is I want to make a form on which if this entry(student)were to make a payment his/her name will be marked as paid in the student database.More like a payroll system.Sorry I am kinda noob when it comes to equations or money matters in Vb.net All I know is add edit delete and search. Can somebody point me to a tutorial or a good idea where to begin?
View 1 Replies
May 22, 2009
I am using vb.net and ms access for developing windows applications. I want to know how to take the backup of database for after each and every transactions.
View 2 Replies
Oct 23, 2009
CODE:
This is my code. I have a problem in displaying the total. Once checkbox is checked it adds the computation to the total. and when it is unchecked, even if the textbox= 0 still, the value of the total is retained.
When you are posting code please use code tags like this.
View 1 Replies
Mar 15, 2010
I want to make a simultaneous connection to multiple servers with threads, only to create a single connection.
Imports System.IO
Imports System.Net.Sockets
Imports System.Text
[Code].....
View 5 Replies
Jun 7, 2012
I have an application that I made in VB.NET. I put it in the server on my office and every other user access it via network connection. I only mapped the drive onto their computer and then I cope the shortcut to the application. can I close all the application that is running with a single code? I sometime need to close all the application first before I can do anything with the application (for example, modifying the report etc.). My current method is still the manual one, which is calling everyone to close their application or running all over the place closing the application myself.
View 1 Replies
Jun 3, 2011
I basically have a few thousand transactions 7,000 - 10,000 transactions to process over a short time. The flow goes like this.
---> ----> ---> ---> receive (1000) as each transaction takes approx 2 seconds so if i were to process synchronously it would take all night......
Now first i would like to ask if i am going about this the right way ? the service i am communicating with is not .net but is built to handle large amounts of requests. I have obtained the following code that suggests it will do what i am after
dim strxmlreq as string = '(this is where i input my xml string)
Dim request As HttpWebRequest
' Create the request
[CODE]...
The problem i have is if the above will work for me where exactly do i catch the returned xml string ? I assumed "result" would be the xml output string.
View 3 Replies
Sep 5, 2011
How do I download transactions info from Paypal using VB.NET
I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile.
[code]...Download Transactions Info From Paypal Using VB?
View 4 Replies
Sep 5, 2011
How do I download transactions info from Paypal using VB.NET I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile. VB.Net in relation to a local computer is something I can work with. Put with intergrating VB.NET with Paypal is alittle out of my depth.
View 3 Replies
Apr 18, 2011
So I'm developing a program were, given some data by the user, the prorgam inserts some records into a database. To insert individual records in different tables I use either the standard INSERT method provided by the Table Data Adapter or a custom Insert Method when I want to insert something slightly differently.Sometimes the user would press a button and an operation where different records in different related tables are inserted. Since each Insert is handled individually for by the DataAdapters of each table, how can I manage to bring the whole thing to an atomic transaction way? I mean, let's say for example the User inserts a new Document in the system, the document has one or many Editions. How could i do something like: if the document was not created properly, then do not insert the editions.
View 2 Replies
Jan 17, 2012
I have the below mentioned code in a seperate class file for establishing connection and carry out DB transactions. I have an issue where multiple connections being opened which sometime exceed the connection pool. When I stepped through the code I found that there are codes which call ConnectDB() in a loop without calling DisconnectDB(). But I expected that the condition OraConn.State = ConnectionState.Closed should handle the situation. Somehow the condition is always satisfied hence openning another set of connection. Can you suggest where am I going wrong and also what best practice can be adopted here?
[Code]...
The connection is again opened in function updData(). While I understand that it has to be closed correctly but keeping tab on every developer is not possible. Hence I want to control it directly from the connection class by using the same connection but the condition If OraConn.State = ConnectionState.
UPDATE I have put the code in UpdateDB under a Using block and removed call to ConnectDB and DisconnectDB from function like InsertData(...). It seems that the issue has been resolved. But I would like to know in case of exception will the connection remain open? and also OraConn is a public variable defined outside Using block so will it be disposed of by the GC?
[Code]...
View 1 Replies
Nov 24, 2011
I would like to use the transactions commit/rollback against a sql server rdbms within a VB 2010 module. I understand how these can be executed within a Transact-SQL session, but cannot seem to be able to code them correctly within VB as these are more like DDL statements.
View 4 Replies
Sep 5, 2011
How do I download transactions info from Paypal using VB.NET I want to create an app which when i press a button. It downloads each new Paypal transaction to a textfile. I would like information like purchase item name, item description. And price to be added to textfile.VB.Net in relation to a local computer is something I can work with. Put with intergrating VB.NET with Paypal is alittle out of my depth.
View 1 Replies
Aug 2, 2010
I am trying to create a database application that will keep records of all cash transactions. how to print a cash receipt to give it to the customer?
View 2 Replies
Aug 27, 2009
I am using Oracle 11g client, with ODP.NET. I am trying to add conditional Transaction handling.
Dim ds As New DataSet()
Dim txn As OracleTransaction
Dim _beginTransaction as Bolean = true
Using conn As New OracleConnection(ConnString)
[Code]...
How do I fix txn being nothing / null? The error is: Variable 'txn' is used before it has been assigned a value. A null reference exception could result at runtime. Edit: to RichardOD for pointing out that you can not explicitly declare that a transaction cannot be opend up on stored procedures via ODP.NET. I have verified that this is an issue. BUT We still haven't figured out why the error is occuring. I understand that txn is initially given a value w/in an if statement, but being defined outside of the try/catch block should make that irrelevant.... right? Or is that bad coding?
View 3 Replies
Nov 12, 2010
I am trying to implement transactions across multiple TableAdapters in VB.NET (using Visual Studio 2010) by extending the partial class as described in the following examples:
http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transactions-blog-post.aspx
madprops.org/blog/typed-datasets-and-sqltransaction/
stackoverflow.com/questions/2342289/net-tableadapter-to-dataadapter
However, when I attempt to expose any of the private fields created by the designer they are underlined in the editor with the following error:
'_adapter' is not declared. It may be inaccessible due to its protection
level.
Searching this site as well as google has not revealed anything useful, but perhpas I'm searching the wrong keywords.
Here is the code in MyDataset.vb
Partial Public Class MyTableAdapter
Public Property MyTransaction() As SqlTransaction
Get
[code]....
View 1 Replies
