Did you know that you can wrap a variable in a using statement without having to set its reference? Someone showed me this today and it of course makes sense, I've just never tried it before and have never seen anyone do it in examples or otherwise...
//datareader variable
using (_reader) {
while (_reader.Read()) {
writer.WriteStartElement("Customer", ns);
for (int fieldIndex = 0; fieldIndex < _reader.FieldCount; fieldIndex++) {
writer.WriteElementString(_reader.GetName(fieldIndex), ns, _reader.GetValue(fieldIndex).ToString());
}
writer.WriteEndElement();
}
}
I learned something new today, guess I get to go home. :-)