<div>
Hi,<br />
<br />
&nbsp; Are your relationships using<br />
<br />
ON UPDATE CASCADE If they are then changing the key in the primary table will update the foreign keys.<br />
<br />
e.g.<br />
<br />
ALTER TABLE Books &nbsp;ADD CONSTRAINT fk_author &nbsp;FOREIGN KEY (AuthorID) &nbsp;REFERENCES Authors (AuthorID) ON UPDATE CASCADE &nbsp;<br />
<br />
Hope it may helpful to you.<br />
<br />
Thanks <br />
Guvera
</div>


<div>
<div class="content wysiwyg-content">
There is a dataset. It has two tables and contains a foreignkey constraint between the two tables. During the data insertion, the primary key of the parent table is changed. Will the change be affected in the child table <br />
before inserting the child data?
</div>
</div>


There is a dataset. It has two tables and contains a foreignkey constraint between the two tables. During the data insertion, the primary key of the parent table is changed. Will the change be affected in the child table 
before inserting the child data?

Datatable

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.