Problem with Dataset Update
This project has turned out pretty tricky.
I have a site that loads a dataset from a SQL Server database. The site has several pages, so I persist the dataset using the Session object, e.g.
Session("ds") = ds.GetXml
Session("dss") = ds.GetXmlSchema
This works great for maintaining the data and schema between pages, but it doesn't seem to be maintaining the DataViewRowState, because when I call the ds.update method, it generates INSERT instead of Update commands, and I wind up with a table with twice as many records as when I started.
Any ideas? Thanks.
Aaron
|