I have a problem with merging datasets.
i have a typed dataset on the server side which is manipulated and i need to update a mirrored dataset on the client side. i use getchanges() on the typed dataset which returns a normal untyped dataset. i try to merge this returned dataset with the typed dataset on the client side but the merge fails! How can a merge fail when both datasets have exactly the same schema
I also noticed that when getchanges() is called, the returned dataset contains rows from the parent tables which have not changed but whose child rows have changed. This makes sense and complies to what the getchanges() function claims to do. would this cause any problems in merging though i thought merge() works only on rows that do NOT have "unchanged" row state; therefore, even if the unchanged parent table row is included in the getchanges() dataset, the merge function will make sure that the parent row doesn't merge!
I appreciate any intput!
DataSet Merge Fails!!
Hot Topic
- Classes that reference eachother
- System.OutOfMemoryException when creating a new Thread
- Enum issues...
- MSXML Problems
- asynchronous event pattern and exceptions
- XML File with No Namespace information
- .Net 2005 app fails if built on XP Home machine
- .net client requirements clarification
- Send images over a network?
- Trusted_Connection Problem with VS2005
.NET Development
- Data trasfering tip required
- How do I access and pull the properties from an Object into an arraylist or collection
- TCPlistener for more than one Port
- Casting Generic Class
- unable to run exe. program
- c# performance
- Date time Picker in asp.net
- Is it possible to use MySQL without MySQL server installed on the client machine... like MS Access?
- Declarative Security & Serialization in. NET 2.0
- OLEDB Transaction
DataSet Merge Fails!!
progames25
thanks a lot for your reply!
regards,
Mike_Kla
The merge can fail for any number of reasons. For example if you deleted a row from the client side table and then tried to merge an update to the row on the server side then a conflict would probably occur. Use the MergeFailed event's MergeFailedEventArgs to identify the conflict that occurred. If you can't figure out where the conflict is occuring then please post some additional information about the situation. What conflict is occurring Were there any changes made to the client side table What code are you using to merge the information Are there any identity columns involved etc.
Michael Taylor - 7/28/06