Home > Blogs
Browse by Tags
Home > Blogs
I recently had the need to access the information in a row marked as “Deleted“ in a DataSet as part of the update process. The first attempted netted a DeletedRowInaccessibleException exception. It is not possible to access the current information
Read More...
Occasionally, a situation arises where the contents of a particular data table within a Dataset *might* originate from more than one source. This entry discusses the issues that can arise when a child data table can have two different sources.
Read More...
DataSets serialize naturally to XML quite well and you have lots of control over that. Typed DataSets have the XSD with some properties that control that (and of course you can do it programmatically too). But one of the common problems with remoting
Read More...
If you Delete a row in a DataTable it's not really gone. It's just in a private buffer thing that hides the data out of the traditional Rows Collection and that works good for databinding and the like. The deleted rows are kept so when you do a DataAdapter.Update()
Read More...
DataSets are very powerful - and one of the features that makes it so powerful is computed columns. You can create a DataColumn that does not contain storage of data but rather computes a value dynamically. Computations can be done by SQL on retrieval,
Read More...
Here is a great article on binding in Windows Forms - specifically against a dataset. Lot's of gotcha's covered. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/databinding_winforms10_11.asp
Read More...
Datasets maintain some internal indexes to improve performs for things like finds and selects. When you are loading more than 1 row into a DataTable - with a DataAdapter.Fill or other technique, you can turn this index maintenance off by doing a MyTable.BeginLoadData()
Read More...