.NET Answers

Posts Tagged ‘tableadapter’

I recently had the need to implement transaction tracking between two separate databases on two separate servers.

Unfortunately, I could not be sure that DTC was implemented on either server, so using transaction tracking with the TransactionScope wasn’t an option.

I also wanted to be able to wire this in easily to the existing 3-tiered framework we are currently using so that what I ended up with could easily be implemented by other developers in a similar situation.

Read the rest of this entry »

Other Related Items:

Brother HL-5370DW Laser Printer with Wireless Networking and DuplexDesigned for businesses and small workgroups, this affordable printer keeps productivity high with fast print speeds. Built-in Ethernet and wireless n... Read More >

Caselogic ACC-15 Black Center Console OrganizerThe Case Logic Auto Travel Organizer ACC15 Universal center console organizer conviently holds easy-to-reach items such as drinks, cell phone, flashli... Read More >

Back Seat Rider NetKeep pets in the back seat.The back seat rider net fits all cars, vans, and sport vehicles. This stretchable, removable net keeps passengers in the ba... Read More >

I received the following question a few days ago:

“I am trying to use three tables from the same dataset in one form that I am creating in vs.net winforms my problem I guess is the setup of it as I can get them all on the form but cant get them to all post to the separate tables when I click save I am using a mysql database with the Mysql connector not the obdc can this even be done?”

Frustrating, isn’t it?  .NET makes some things SO easy, and then when it isn’t you figure you must have done something wrong.

The good news is, your problem probably has nothing to do with using mySQL–it is all in how you are using the database stuff in WinForms.

Read the rest of this entry »

Other Related Items:

Crystal Lucite Hard Shell Case for iPhone 2G from Prima CasesKeep your iPhone 2G safe and secure with the Prima Crystal Lucite case. Made from durable plastic, the Prima Crystal iPhone Case is able to protect yo... Read More >

Dress Form: New White Female Torso Dress Form Mannequin rndBrand New Female Dress Form. Available in black or white. Stand is available in Natural, Black Or Burgundy colors. Easy assembly, you shouldnt have an... Read More >

LINQ in Action

LLINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and databas... Read More >

Last Thursday, we looked at how to replace the TableAdapter with our own TableAdapter as a way or eliminating our dependence on Microsoft SQL.  The problem with this implementation is that every time you want to switch databases, you’ll need to switch what TableAdapter the code is using.

Read the rest of this entry »

Other Related Items:

Abd Binder 3 Panel 9In 46-6DAL411 (Each)--DALE MEDICAL PRODUCTS-- The new pre-paneled stretch material incorporates an innovative joining stitch that prevents skin from migratin... Read More >

Western Digital Hard Carrying Case for My Passport Portable Drives WDBABJ0000NBK-NRSN - BlackCase for Portable Drives

Speck Products Apple iPad ShieldView Anti-Glare Protective Screen Films, 2-Pack, IPAD-SHVW-A025MTScreen Film for iPad

One of the comments that showed up on the blog post about using 3-tiered with DataSets and the ObjectDataSource was, “How do we set this up so that we can swap out the DAL?”  The simple answer to this is, “roll your own Table Adapter.”

Read the rest of this entry »

Other Related Items:

LINQ in Action

LLINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and databas... Read More >

Chromatin Immunoprecipitation Assays: Methods and Protocols (Methods in Molecular Biology)

Over the past twenty years, the development of chromatin immunoprecipitation, or ChIP, assays has immensely enhanced the biological significance of... Read More >

My Favorite Brahms