Binding problem

[Guest]

Controls in my windows form are bound to columns in a SQL table. I configured
the current manager and everything else and I can see the data coming from
the table on my form. However, when I try to add a new record I got the error
"Additional information: DataBinding could not find a row in the list that is
suitable for all bindings".
The data adapter was configured to allow select, delete and insert,..
statements. What could have gone wrong. I have controls in another form bound
to a different table and I don't experience the same problem. Please help!!

 

[Chris]

Controls in my windows form are bound to columns in a SQL table. I configured
the current manager and everything else and I can see the data coming from
the table on my form. However, when I try to add a new record I got the error
"Additional information: DataBinding could not find a row in the list that is
suitable for all bindings".
The data adapter was configured to allow select, delete and insert,..
statements. What could have gone wrong. I have controls in another form bound
to a different table and I don't experience the same problem. Please help!!

Haven't run into that problem, but just a thought on what it could be:

If you have a control that can not handle a dbnull and your new row
doesn't have a default value for each column (therefore giving a dbnull)
you may get this error. Try setting the default values for your columns
and see if that clears it up.

Chris