Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
The best choice for your web site host, email hosting, and domain registration.
 


  Sponsors  

Meet Our Sponsors

Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  SQL Transction in DotNetNuke
Previous Previous
 
Next Next
New Post 5/13/2008 7:06 AM
User is offline yonscun lie
1 posts
10th Ranked


SQL Transction in DotNetNuke 
Hi, I'm new in dot net nuke development. From some internet resources, I were able to create a simple DNN module, but currently I have a problem when implementing sql transaction in dotnetnuke. For example if user pushed "Save" button, some values will be added to table1 and table2, if any of SQL INSERT operation was fail, then system must rollback the whole transaction. How to perform this in dot net nuke? (note: I already follow the tutorial by creating Table1Info.cs, SqlProvider.Cs, DataProvider.cs, etc) For clarity, this is my pseudocode try { Db.StartTransaction(); Sql.Execute("insert into table1 values ('some value1')"); Sql.Execute("insert into table2 values ('some value2')"); Db.Commit(); } catch(Exception Ex){ Db.Rollback(); Throw New Exception ("Sorry Operation is failed!!!") }
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  SQL Transction in DotNetNuke
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


UK - DotNetNuke providers
UK providers of DNN module development and skin package design. Oxford Information Labs provides cost-effective solutions for businesses and organisations specialising in Skin design and bespoke module development.
www.oxil.co.uk 		TronixSoft
Hosting for local businesses that want more from their websites.
www.TronixSoft.com 		The Forerunner Network
The Forerunner Network consists of a group of Dynamic Website & Interactive Membership Portal hosting services that are managed by Forerunner Communications. Our services span a wide range of markets and enable individuals, organizations and businesses to build and manage dynamic, interactive portals and websites.
The Forerunner Network

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP