devxlogo

Tip Bank

Persist ADO.NET extended properties

Many ADO.NET classes, including DataSet, DataTable, and DataColumn, use the ExtendedProperties property to enable users to add custom information. Think of the ExtendedProperties property as a kind of generic cargo

Handle child XML nodes with care

When you work with XML documents loaded into an XmlDocument class, you often need to examine the contents of child nodes. The XMLDOM programming interface purposedly provides the ChildNodes property.

Continue After Hitting an Error

If you use VB6 to write COM programs that raise errors, it seems impossible to continue after hitting one of them. However, the (almost undocumented) commands ALT+F8 and ALT+F5 let

Cleanup Your IF Statements with IN

IF statements can become quite long when you’re testing for multiple values. Using the IN expression can make them more readable.So, instead of typing: IF (@testvar = 1 or @testvar

Use enum Terminated with count

Always use an enum instead of defines and always close the list with an additional count. This makes life simpler and helps the compiler.Instead of defines: #define TypeA 0#define TypeB