473,406 Members | 2,769 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

VB.NET 2008 - TableAdapterManager ?

19
I have this situation with ADO that is giving me a problem.
I have two related tables -
Products
ProductVendors (id, VendorID, ProductID)

There is a One.Product to many Vendors relation and ProductVendors.VendorID + ProductVendors.ProductID must be unique.

They are on one Form that consists of one Product and a DataGridView that allows for the inputing of multiple vendors.

Here is the problem. If the user opens a record that consist of:
Product: Printer Toner 123
Vendors: ABC Inc
Zen Inc
xxx Inc
then user adds ABE INC again, then noticing the duplicate entry, and removes ABC INC in the first record, then when updating - using the
tablemanageradapter.updateall - it returns an error of a violoation of the Unique Key in ProdcutVendors.

I think what is happening is that the TableAdapterManager is first doing Updates or Inserts and as such it creates a violation.
I don't see an option to tell the TableAdapterManager to first process the Deletes.

Any suggestion how to handle this?
Feb 14 '08 #1
0 1172

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: bj7lewis | last post by:
I am currently C++/Win32/MFC & C# programmer using VS.NET 2002 and jumped into VS.NET 2003 but that was a waste so I skipped VS.NET 2005 cause buying VS.NET 2003. Now after checking out VS.NET 2008...
0
by: =?Utf-8?B?TWlyYW5v?= | last post by:
I tried it several times, setup disk is not damaged, everything is fine, but it always fails with the error below after completing like 75% of the installation. Then I saw other posts, and figured...
2
by: plonk | last post by:
Hi I am trying to write to a sql database, but the Update method is not writing the data to the database. I can view the data coming into the dataset grid ok and no errors are generated. I'm...
0
by: Fortis Florin | last post by:
CALL FOR PAPERS: Workshop on Workflow and Process Management (WfPM'08), September 2008, Timisoara, Romania ...
0
by: John | last post by:
Hi An outlook 2003 add-in solution created in vs 2008 on a pc with outlook 2007 when re-opened in vs 2008 brings up the conversion wizard. Cancelling wizard closes solution and does not allow to...
0
by: Fortis Florin | last post by:
2nd CFP: Workshop on Workflow and Process Management (WfPM'08), September 2008, Timisoara, Romania EXTENDED DEADLINES...
0
by: Fortis Florin | last post by:
Final CFP: Workshop on Workflow and Process Management (WfPM'08), September 2008, Timisoara, Romania EXTENDED DEADLINES ___________________________________________________________________________­...
0
by: =?Utf-8?B?anVsaW8=?= | last post by:
I am trying to use Update to save changes made on two DataGridView's to two tables with a FK relationship. I say private void bUpdate_Click(object sender, EventArgs e) { try { ...
3
by: John | last post by:
Hi Is there advantage of installing VS 2008 SP1 for vb winform database developers? Any issues that I should know? Thanks Regards
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.