I've carefully watched the videos many times on how to use the Add Data Sources to bind my database to a form. That works great. When I run the app I can see the data I have input from ShowTable view on the form I created. I can add and change data on my form also. However, after closing the form and going back to ShowTable I see none of my additions or changes.
I've read all the fourms I could find already that addressed this issue, but I cant seem to find a fix that works in my case.
Also, I dont know if it's relavent or not, but while in show table view, I get a big red exclamation point in each cell as I type. Once I fill out the entire record everthing seems to fuction normally. Changes stay, additions are availible. I only mention this because that "tool tip " was not evident in the videos I watched on databinding.
Any one know if it's just an options setting I've got out of place I have already set the options back to defaults. Maybe one of the default options is wrong
Help! And thanks in advance!
Dataset Update to DataBase VB Studio 2005 Express w/ Sql 2005 Explress
pdx_benjamin
This is a frequently misunderstood issue that has to do with how local databases are handled. By default there are two copies of the database - one that you are using at design time, and another in the output directory that you are using when you run. The resolution is to change the setting of the Copy to Output DIrectory property.
For a full explanation, see the following post" http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=140988&SiteID=1
Hope this helps,
Steve Hoag
Visual Basic Express
squimmy
Ted Warring
thanks - this was very helpful (needed to set the "Copy to Output Directory" property of my Database.mdf to "Copy if Newer").
Just some feedback: this wasn't (I don't think) mentioned at all in Bob's video lesson 9 and I have spent several hours trying to work out why even the sample project just didn't work. Otherwise the videos have been excellent: this just proved a bit frustrating...
Metal_Fly
Ahmed Kuradi