The Weird and The Wonderful

<br />
/* does the user have read permissions on the file */<br />
try<br />
{<br />
   FileStream fs = new FileStream(name, FileMode.Open, FileAccess.Read);<br />
   using (fs) { fs.Close(); }<br />
}<br />
catch (Exception){continue;}<br />

<br />
FileInfo fi = new FileInfo(name);<br />
<br />
DateTime dt = fi.LastWriteTime;<br />
<br />
int yr = dt.Year;<br />
if (yr >= 2000)<br />
   yr -= 2000;<br />
else<br />
   yr -= 1900;<br />
<br />
string year = yr.ToString();<br />
if (yr < 10)<br />
   year = year.PadLeft(2, '0');<br />
<br />
/* TODO: Format to be changed for US market */<br />
<br />
string date = dt.Day + "/" + dt.Month + "/" + year;<br />

<br />
System.Text.UTF8Encoding encoder8 = new System.Text.UTF8Encoding();<br />
System.Text.Decoder utf8Decode = encoder8.GetDecoder();<br />
byte[] todecode_byte8 = Convert.FromBase64String(_body);<br />
int charCount8 = utf8Decode.GetCharCount(todecode_byte8, 0, todecode_byte8.Length);<br />
char[] decoded_char8 = new char[charCount8];<br />
utf8Decode.GetChars(todecode_byte8, 0, todecode_byte8.Length, decoded_char8, 0);<br />
_body = new String(decoded_char8);<br />

for each row in result<br />
 for each column in the result<br />
     if the datatype is a int, it must be a foreign key <br />
            do a whole load of messin to work out the foreign key table<br />
            so do another sql statement to pull back the foreign key value from another table<br />
            output the foreign key value<br />
     else<br />
            output the value<br />
     end if<br />
 next column<br />
next row.