Hey, Bonnie, you like datasets ...
Playing with a "wide and shallow" concept for child data.
In my proof-of-concept app I want to stored a dataset ( untyped - schema created in prop sheet - bound to datagridviews on form ) to a strongly typed property of my business object which will then be stored as part of the record in a SQL 2008 table.
Should I use varchar(max) or varbinary(max) to store this object ? Do I want to write it out as xml or just bitstream it out as a byte() array?
In this first iteration I am looking for the simplest, cleanest way to get the dataset into the prop and back out again. I almost had it working, I thought, using these functions to serialize and deserialize to xml varchar(max) but for some reason the last row of the grid doesn't properly write changes in the xml. Quirky. Perhaps it is something else I"m doing wrong on that one so if you say this looks good to you I may bang on it some more
http://codebetter.com/blogs/jay.kimble/archive/2004/03/30/10383.aspxAnyway, suggestions - and especially code (vb or c#) very welcome.
Dataset to SQL column via strongly typed prop
TIA
Cetin - ne var ne yok ?
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.