Waiting Game Photos -- With Soupcon of Source Code

While I am playing a waiting game in life, I have nothing for a topic on my blog today, so I will blog about nothing. I do have some pictures though. I have lots of pictures.

The first is of a tropical sunrise.

The second is of people trying to enjoy themselves on a cold beach.

So I sit here and write software code. What is the latest thing that I put into the beast? A file chooser to upload a blob to a database. Here is the source code snippet:

Stream myStream = null;
OpenFileDialog openFileDialog1 = new OpenFileDialog();
long FileSize;
byte[] rawData;
MySqlCommand cmd = new MySqlCommand();

openFileDialog1.InitialDirectory = "c:\\";
openFileDialog1.Filter = "All files (*.*)|*.*";
openFileDialog1.RestoreDirectory = true;

if (openFileDialog1.ShowDialog() == DialogResult.OK)
if ((myStream = openFileDialog1.OpenFile()) != null)
string filname = openFileDialog1.FileName;
using (myStream)
// Insert code to read the stream here.
FileSize = myStream.Length;
int fsint = (int)FileSize;
rawData = new byte[FileSize];
myStream.Read(rawData, 0, fsint);
string SQL = "insert into attachments (filename, filesize, blobdata, userPKID, messPKID) values (?Filname, ?Filsiz, ?File, 2, 1)";
cmd.Connection = conn;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("?Filname", filname);
cmd.Parameters.AddWithValue("?Filsiz", FileSize);
cmd.Parameters.AddWithValue("?File", rawData);
MessageBox.Show("File Inserted into database successfully!",
"Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

catch (Exception ex)
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);


No comments: