I'm having some trouble receiving the identity value after an insert. I've
seen several posts about this, and the solution that seemed the most obvious
was to enable the advanced TableAdapter option - "Refresh the data table".

Well, I tried that  After I insert a row and call update, the table still
doesn't have the new identity value. Isn't that how it's supposed to work?
However, if I do my own Fill(), I get back a table that does indeed have the
rows with the new identity. I'm not sure if I'm doing it wrong or the
refresh isn't actually happening.

I went back into the wizard and tried to configure the Tableadapter and I
noticed that the "Refresh the data table" option was no longer checked, even
though it had been checked before. Is that expected behaviour? If not, what
do I need to do to make the refresh option stick.

-cwineman



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

VB6 memory recordsets to .NET
DataSet help -- .Merge() & .GetChanges()
TableAdapters and Transactions again!
binding tables in many-to-many relationships
comparison reporting -- technique suggestions?