Home All Groups Group Topic Archive Search About

ForeignKeyConstraint StudentsSchYrSem requires the child key values (21000013) to exist in the paren

Author
10 Dec 2004 4:16 AM
jaYPee
I have created 3 sqldataadapter. each adapter.selectcommand has a
parameter. I have added a textbox to supply a value for each
parameter. My problem is when I press enter the second time to fire up
the keypress event from the textbox I recieved this error in datagrid
object "ForeignKeyConstraint StudentsSchYrSem requires the child key
values (21000013) to exist in the parent table"

I'm wondering before if I change the value of that textbox only the
second time have an error.

The parameter is lastname.
example if I provide a value in the textbox the first time and press
enter i did not recieve an error. the second time i change the value
of a textbox gives me an error. after that no error has occur.

seems this is a very strange error to me.

Author
10 Dec 2004 6:49 AM
jaYPee
Never mind. I have already solved the problem. The problem is that I
bind it two times in my code.


On Fri, 10 Dec 2004 12:16:12 +0800, jaYPee <hijay***@yahoo.com> wrote:

Show quote
>I have created 3 sqldataadapter. each adapter.selectcommand has a
>parameter. I have added a textbox to supply a value for each
>parameter. My problem is when I press enter the second time to fire up
>the keypress event from the textbox I recieved this error in datagrid
>object "ForeignKeyConstraint StudentsSchYrSem requires the child key
>values (21000013) to exist in the parent table"
>
>I'm wondering before if I change the value of that textbox only the
>second time have an error.
>
>The parameter is lastname.
>example if I provide a value in the textbox the first time and press
>enter i did not recieve an error. the second time i change the value
>of a textbox gives me an error. after that no error has occur.
>
>seems this is a very strange error to me.

AddThis Social Bookmark Button