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...
Each of these tips relate to speeding up the searching of data in a dataset. Although indexes are created in a dataset they are not exposed. Knowing how to make ADO .net generate them gives you the power to enhance the performance of you DataBase application.
Read More...
In some mission critical applications, it's important create a log or audit trail against updates made against a specific table. Sometimes this could be done with triggers if you have all the information available, or perhaps your updates are encapsulated
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...
It's tempting to think that with objects like “DataView” and methods like “Select” that DataSets would support this option, but the bottom line is that they don't. A DataView is a sorted and/or filtered list of rows from 1 table
Read More...
http://www.tek-tips.com/gfaqs.cfm/pid/796/fid/3940
Read More...