Inserting Picture

.NET
1

Hi guys, I am inserting a picture into a database, using the following code.


//Get File Extension
            strFileType = Path.GetExtension(filImage.PostedFile.FileName).ToLower();

            switch (strFileType)
            {
                case ".gif":
                    strMimeType = "image/gif";
                    break;
                case ".jpg":
                case ".jpeg":
                case ".jpe":
                    strMimeType = "image/jpeg";
                    break;
                case  ".png":
                    strMimeType = "image/png";
                    break;
            }

            //Store the content length
            int iDocLength = filImage.PostedFile.ContentLength;
            byte[] bDocBuffer = new byte[iDocLength];
            //Get stream object
            Stream streamImage;
            streamImage = filImage.PostedFile.InputStream;
            streamImage.Read(bDocBuffer, 0, iDocLength);

            cmPerson.CommandText = "INSERT INTO photos VALUES(@referenceid, @image, @imgtype)";
            cmPatient.Parameters.AddWithValue("@referenceid", iPersonID.ToString("000000"));
            cmPerson.Parameters.AddWithValue("@image", bDocBuffer);
            cmPerson.Parameters.AddWithValue("@imgtype", strMimeType);
            cmPerson.ExecuteNonQuery();

If in case that the user, did not browser for a picture, then, I have to use the nopho.jpg that is stored in the images/folder of my web app. How am I be able to do this? Please help me.

2

I would suggest saving the image path in the database instead of the image itself. Doing so will make your queries faster, db smaller, etc.

Then you can just check, if empty string, show your placeholder image. Else show the image. Put them in the same folder, which will make your life easier