The description for DataTable.LoadDataRow says:
Finds and updates a specific row. If no matching row is found, a new row is
created using the given values.
So I would think from that, that I should be able to fill the object[] array
with values that correspond with each column of that row, and if a row in
the table is found with the same value in the PrimaryKey column, then the
row would be updated with the values in the array. But instead, I get the
error:
A first chance exception of type 'System.Data.ConstraintException' occurred
in system.data.dll
Additional information: Failed to enable constraints. One or more rows
contain values violating non-null, unique, or foreign-key constraints.
What have I missed here? Does LoadDataRow update a row's values?
Thanks,
Dennis 2 7899
Dennis,
The exception comes from the fact that the data table that you are
adding the row to requires something to be populated. For example, one
column might require a non-null value, but you are passing null.
You will have to check the constraints and make sure you are passing the
correct values in.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Dennis C. Drumm" <de*******@primacode.com> wrote in message
news:OX*************@tk2msftngp13.phx.gbl... The description for DataTable.LoadDataRow says: Finds and updates a specific row. If no matching row is found, a new row
is created using the given values.
So I would think from that, that I should be able to fill the object[]
array with values that correspond with each column of that row, and if a row in the table is found with the same value in the PrimaryKey column, then the row would be updated with the values in the array. But instead, I get the error:
A first chance exception of type 'System.Data.ConstraintException'
occurred in system.data.dll
Additional information: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
What have I missed here? Does LoadDataRow update a row's values?
Thanks,
Dennis
Thanks Nicholas:
It turns out I needed to Table.AcceptChanges() before the LoadDataRow, then
everthing will work fine.
Dennis
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:uC**************@TK2MSFTNGP11.phx.gbl... Dennis,
The exception comes from the fact that the data table that you are adding the row to requires something to be populated. For example, one column might require a non-null value, but you are passing null.
You will have to check the constraints and make sure you are passing
the correct values in.
Hope this helps.
-- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse.com
"Dennis C. Drumm" <de*******@primacode.com> wrote in message news:OX*************@tk2msftngp13.phx.gbl... The description for DataTable.LoadDataRow says: Finds and updates a specific row. If no matching row is found, a new row is created using the given values.
So I would think from that, that I should be able to fill the object[] array with values that correspond with each column of that row, and if a row
in the table is found with the same value in the PrimaryKey column, then
the row would be updated with the values in the array. But instead, I get
the error:
A first chance exception of type 'System.Data.ConstraintException' occurred in system.data.dll
Additional information: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
What have I missed here? Does LoadDataRow update a row's values?
Thanks,
Dennis
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stevey |
last post by:
I have the following XML file...
<?xml version="1.0"?>
<animals>
<animal>
<name>Tiger</name>
<questions>
<question index="0">true</question>
<question index="1">true</question>
</questions>
|
by: nospam |
last post by:
Ok, 3rd or is it the 4th time I have asked this question on Partial Types,
so, since it seems to me that Partial Types is still in the design or
development stages at Microsoft, I am going to ask...
|
by: Ekqvist Marko |
last post by:
Hi,
I have one Access database table including questions and answers. Now
I need to give answer id automatically to questionID column. But I
don't know how it is best (fastest) to do?
table...
|
by: glenn |
last post by:
I am use to programming in php and the way session and post vars are past
from fields on one page through to the post page automatically where I can
get to their values easily to write to a...
|
by: VJ |
last post by:
Hi..
I have 2 datasets, each with a DataTable. Each table has the same primary
key, and columns. I am trying to copy rows from one dataset to another,
based on an event from my application.
|
by: VJ |
last post by:
I have 2 datasets, each with a DataTable. Each table has the same primary
key, and columns. I am trying to copy rows from one dataset to another,
based on an event from my application.
It all...
|
by: Rider |
last post by:
Hi, simple(?) question about asp.net configuration..
I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm
first start application the follow message shown.
=========
Server...
|
by: Jeff |
last post by:
In the function below, can size ever be 0 (zero)?
char *clc_strdup(const char * CLC_RESTRICT s)
{
size_t size;
char *p;
clc_assert_not_null(clc_strdup, s);
size = strlen(s) + 1;
|
by: Anil Gupte |
last post by:
The documentation says that LoadDataRow updates or inserts based upon
whether the row exists or not. It does not say so in the documentation, but
I figured the only way for it to know that is for...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |