I have used drag and drop to create a dataset in VS 2010 with SQL Server CE 3.5 on the user computer and SQL Server 2008 R2 Express on the server computer. Everything was done using the VS 2010 designer. At first, all records were inserted properly and updates were done. That was before I began inserting URLs into the image path textbox. Now, the Update will do some updates but not any which are a link to a web address such as http://www.somewebsite/foldername/filename
. When running, I can upload an image and view it and the path to the image is inserted into the bound textbox where it belongs. When I attempt to save it, the textbox is blanked out and the record may or may not be updated, depending on which changes are made. If it is a new record, nothing is inserted. If it is an existing record and the changes do not involve the image path textbox, then it is updated. If it is a new record without an image, it is inserted. If the image path is inserted into the table on the server and then synchronized with the local database, the local database correctly updates the field.
I have looked at the dataset using the .GetChanges method and when the path is typed into the textbox, it shows in the pending changes dataset but when the path is programmatically inserted, it does not. In either case, the record is not inserted/updated.
I cannot find any calls to fill the datatable between the changes and the updates.
I have found other references to this kind of problem on this site and other sites but no definitive solutions. I've lost about a week over this. My question is this: Is there a fix for this or should I scrap the existing dataset and start over? I have done this exact same thing on other programs and not had this problem. Suggestions would be greatly appreciated.