Top "Tableadapter" questions

a .Net component, that fills a dataset with data from the database.

Failed to enable constraints. When using a data table adapter

I'm getting Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. for the …

c# .net sql tableadapter
C# WinForms - how to send updates from DataGridView to DataBase

I have a .mdb file with a Customers table and an Agents table. The only thing that the Agents table …

c# database datagridview dataset tableadapter
How do you filter a TableAdapter's FillBy based on two tables?

I'm using VS2008 C# Express and the Northwind database on a Windows Form application. I used drag and drop to …

c# filter strongly-typed-dataset tableadapter
Updating MS Access Database from Datagridview

I am trying to update an ms access database from a datagridview. The datagridview is populated on a button click …

c# sql datagridview tableadapter dataadapter
Incorrect ID is returned after insert using TableAdapter

When I perform an insert with TableAdapter: int pid = this.purchaseTableAdapter.Insert(supplierid, datetime, "", totalprice, amountpaid); It returns the incorrect …

c# c#-3.0 tableadapter
TableAdapter.Update not working

Here is my function: private void btnSave_Click(object sender, EventArgs e) { wO_FlangeMillBundlesTableAdapter.Update(invClerkDataDataSet.WO_FlangeMillBundles); wO_HeadMillBundlesTableAdapter.…

c# sql sql-update tableadapter
ADO.NET databinding bug - BindingSource.EndEdit() changes current position

What is the correct order of processing an insert from a data-bound control using BindingSource, DataSet, and TableAdapter? This is …

winforms data-binding dataset bindingsource tableadapter
Relaxing Constraints for a data table adapter

I'm trying to relax my constraints while using a data table adapter, but I'm getting a Object reference not set …

c# .net sql winforms tableadapter
C# - using TableAdapter to return a single value from stored procedure returns null

I do not understand but my stored procedure which I added to table adapter only returns null value. It is …

c# stored-procedures tableadapter
Fill command giving "failed to enable constraints" error. How can I work around?

Issue I am refactoring a project written by a developer in C# .NET 4.5 project which contains a dataset.xsd. I …

c# asp.net dataset constraints tableadapter