SqlCommand getEmp = new SqlCommand(                "SELECT EmployeeID, Photo "+                "FROM Employees "+                "WHERE LastName = @lastName "+                "AND FirstName = @firstName", _conn);            getEmp.Parameters.Add("@LastName",  SqlDbType.NVarChar, 20).Value = plastName;            getEmp.Parameters.Add("@FirstName", SqlDbType.NVarChar, 10).Value = pfirstName;            FileStream fs;                          // Writes the BLOB to a file (*.bmp).            BinaryWriter bw;                        // Streams the BLOB to the FileStream object.            int bufferSize = 100;                   // Size of the BLOB buffer.            byte[] outbyte = new byte[bufferSize];  // The BLOB byte[] buffer to be filled by GetBytes.            long retval;                            // The bytes returned from GetBytes.            long startIndex = 0;                    // The starting position in the BLOB output.            string emp_id = "";                     // The employee id to use in the file name.            // Open the connection and read data into the DataReader.            _conn.Open();            SqlDataReader myReader = getEmp.ExecuteReader(CommandBehavior.SequentialAccess);            while (myReader.Read())            {                // Get the employee id, which must occur before getting the employee.                emp_id = myReader.GetInt32(0).ToString();                // Create a file to hold the output.                fs = new FileStream("employee" + emp_id + ".bmp",                                    FileMode.OpenOrCreate, FileAccess.Write);                bw = new BinaryWriter(fs);                // Reset the starting byte for the new BLOB.                startIndex = 0;                // Read the bytes into outbyte[] and retain the number of bytes returned.                retval = myReader.GetBytes(1, startIndex, outbyte, 0, bufferSize);                // Continue reading and writing while there are bytes beyond the size of the buffer.                while (retval == bufferSize)                {                    bw.Write(outbyte);                    bw.Flush();                    // Reposition the start index to the end of the last buffer and fill the buffer.                    startIndex += bufferSize;                    retval = myReader.GetBytes(1, startIndex, outbyte, 0, bufferSize)