I'm passing a simple text SQL select via the Command object and using the Fill method on the dataset. Then I add about 35 rows (79 columns in the row) and issue the Update method. The code throws no errors in either the UI or data layers, and I don't receive an error from the Oracle stored procedure, but the data never gets inserted into the table. I'll provide code details if I get a response...
Mark
Tony
Thanks for the response! Unfortunately, I'm not using ASP, I'm on the desktop. Hope someone can help you, I'm finding this forum to be rather useless!
Mark
cheers,
Paul June A. Domag
Once again, I thank you for the post, but I stumbled onto a solution. I had called the .AcceptChanges method prior to calling the data tier procedure. The RowState property of all the new rows that I added were changed from "Added" to "Unchanged". Thus, the stored procedure didn't throw an error because there were no rows to work on.
Thanks,
Mark
