How to handle NULL fields-error with fill method

From: Paul (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 10:36:02 -0700

I have a data adapter that is using a stored procedure and when I get to the fill method to fill a dataset I get the following error,
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
The results of the procedure has 6 columns by 50 rows with some NULL field values throughout so think the NULLs are causing the problem. Just wondering how to handle this? Thanks Paul.

Relevant Pages

  • Re: trying to generate a concurrency exception
    ... Hi Paul, ... Are you using the Data Adapter Configuration Wizard to create your ... > later performing an Insert as shown below. ... > cmd_dataitmlog.ExecuteNonQuery'Executes the stored procedure ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: DataTable made from JOINed tables and the DataAdapter wizard
    ... I have a class that uses a data adapter, and handles OnRowUpdating and ... the row>Command of the data adapter. ... what I do) to help you decide which stored procedure you want to call. ... > a CustomerBookings DataTable that contains fields from both Customers ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to limit size of record returned
    ... Paul wrote: ... > from a stored procedure? ... Why wouldn't you just limit your crystal report to only displaying 20 ... But, if you really want to do it backwards and format it in your query, ...
    (microsoft.public.sqlserver.programming)
  • concurrency update problem
    ... I have dataset with an update to a sql stored procedure created using the ... When a change is made in the text box, the data adapter @new and @orginal ... field has the same value containing the new value entered into the textbox. ... same value as the update clause, which of course causes the failure. ...
    (microsoft.public.dotnet.general)
Loading