Home All Groups Group Topic Archive Search About

TableAdapter not updating table if the table is empty when loaded?

Author
10 May 2007 10:08 PM
Brooke
I am having problems with the table adapter not updating (inserting a new
record) the sql server table if I open the form with out any records already
in the sql server table.

If I add on record in sql server management studio, the the table adapter
will work correctly, but there has to be at least on record.

What is going on??

There are not any exceptions being thrown.

I checked the table adapter commands (delete, insert, select, update) and
they match the other table adapter that are working correctly. (just
different fields and parameters)

What else can I check for?

Thanks

Author
11 May 2007 7:03 AM
Miha Markic
Code, please.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"Brooke" <tbroo***@hotmail.com> wrote in message
news:OfdDM$0kHHA.4596@TK2MSFTNGP05.phx.gbl...
>I am having problems with the table adapter not updating (inserting a new
>record) the sql server table if I open the form with out any records
>already in the sql server table.
>
> If I add on record in sql server management studio, the the table adapter
> will work correctly, but there has to be at least on record.
>
> What is going on??
>
> There are not any exceptions being thrown.
>
> I checked the table adapter commands (delete, insert, select, update) and
> they match the other table adapter that are working correctly. (just
> different fields and parameters)
>
> What else can I check for?
>
> Thanks
>

AddThis Social Bookmark Button