This article explains my predicament
Now I would expect a simpler solution for working (and testing) with a local database, but that's a different story ;)
Thanks for the help, onwards we march.
I am trying to say that the data is there during execution time, but not afterwards. It makes no difference if I use SQLcommand or data adapters.
It could be that I am working in a database instance that is not being moved to the actual db, but that is what a commit is all about, isn't it?
But the problem does not appear to be with the adapter or the vb code. As I mentioned, I tried inserting it through a SQLConnection as well.
Besides, prior to this sub sits one in the line of 'if not exists, then insert'. It does not process double records.
So during execution...
Getting my feet wet with .NET, and I bump in to this stupid problem that I trust you can help me with.
I have a (local) database, with some stored procedures for inserting, deleting, etc.
Stored procedures work just fine when I execute them by hand.
Created a tableadapter with these stored...