Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 19th, 2007, 08:39 PM
Kia Kia is offline
Authorized User
 
Join Date: Jun 2007
Location: Sydney, NSW, Australia.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Record Locking & Transactions in Strongly Typed DS

Hi,

I have a form with 4 tables displayed in different tabs, all coming from the same dataset. Here's part of the Form.Load event so you know what I mean:

Code:
Me.taPaymentsApplied.Fill(Me.DsPaymentProcessing.PAYMENT_APPLIED)
Me.taNewPayment.Fill(Me.DsPaymentProcessing.PAYMENT, Me.txtCardID.Text)
Me.taExistingPayment.Fill(Me.DsPaymentProcessing.EXISTING_PAYMENT, Me.txtCardID.Text)
Me.taInvoices.Fill(Me.DsPaymentProcessing.INVOICE, Me.txtCardID.Text)
What I need to do is lock all the records that are opened in the latter 3 lines and begin a transaction. Then allow the user with the lock to add records to the first table and modify contents of the next 3. I'd prefer that other users simply not be allowed to even view these locked records.

Saving needs to be in a transaction, meaning either save ALL 4 tables or fail on all.

I can do this when I do everything programmatically, but I'm a bit lost when it comes to using objects from my Datasource window.

I'd appreciate any help.
Cheers

Kia
Reply With Quote
  #2 (permalink)  
Old June 29th, 2007, 06:34 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: India.
Posts: 224
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to ashu_from_india Send a message via Yahoo to ashu_from_india
Default

dataset is all client side...so u cannot lock database rows using dataset...
place an explicit lock using transaction before u fetch the data...and commit / rollback it after modification

Reply With Quote
  #3 (permalink)  
Old June 29th, 2007, 06:34 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: India.
Posts: 224
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to ashu_from_india Send a message via Yahoo to ashu_from_india
Default

and use IsolationLevel according to ur requirement

Reply With Quote
  #4 (permalink)  
Old July 2nd, 2007, 09:32 PM
Kia Kia is offline
Authorized User
 
Join Date: Jun 2007
Location: Sydney, NSW, Australia.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I keep seeing a little bit of code to extend the TableAdapter namespace and add a transaction sub to it. This is the code I saw on someone's blog

Namespace MyDataSetTableAdapters
    Partial Class MyTableAdapter
        Public Sub SetTransaction(ByVal trn As SqlClient.SqlTransaction)
            Me.Adapter.InsertCommand.Transaction = trn
            Me.Adapter.UpdateCommand.Transaction = trn
            Me.Adapter.DeleteCommand.Transaction = trn
            Me.Adapter.SelectCommand.Transaction = trn
        End Sub
    End Class
End Namespace

What I don't get is, what do you do with this? Where to put it? the only place I can figure out is the dataset's designed code, but it would get overwritten I thought. Enywhere else, I get an issue with the "Adapter" class not defined.
Reply With Quote
  #5 (permalink)  
Old July 23rd, 2007, 06:23 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: India.
Posts: 224
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to ashu_from_india Send a message via Yahoo to ashu_from_india
Default

i hv not worked on TableAdapters and Update Method
i always use Command object & SQL statements for Insert, Update & Delete tasks


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
strongly-typed DataSet.Rows r n't getting Updated srkvellanki ASP.NET 2.0 Professional 3 October 1st, 2008 05:26 PM
"Strongly typed" roman BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 2 June 26th, 2008 10:35 AM
Sorting Gridview bound to strongly typed object kulkarnimonica ASP.NET 2.0 Professional 10 September 20th, 2007 03:32 PM
Accessing Strongly Typed Session Data Woodman ASP.NET 2.0 Professional 2 March 9th, 2007 04:42 PM
Crystal Report and Strongly-Typed dataset jaucourt Crystal Reports 1 February 9th, 2004 07:39 AM



All times are GMT -4. The time now is 03:01 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.